Monday, July 30, 2007
Video: Using Controls to Change Chart Data
One of the best things about Excel is its seemingly infinite flexibility. In this video I demonstrate how you can use controls from the Forms toolbar to change the data in charts. There are so many ways to use this technique for presentations that it was difficult to choose one. I decided to show a very simple example that compares some financial ratios for GE over time to the industry averages.
The basic idea is that you use a control (a drop-down list in this example) to choose which of several data series to display in the chart. As part of the formatting of the control, you will
Comments (4) • Trackbacks (0) • Permalink • Tell-a-Friend
Sunday, June 17, 2007
Video: Creating Step Function Charts in Excel
A couple of months ago, I created my first screencast video using Camtasia Studio from TechSmith. This is a great tool, but I need to work a bit on my video creation skills. Today, I posted the video on YouTube, and I hope that people will find it useful. The video shows how to create a step function chart in Excel.
In this case, I used the Fed Funds Target rate as my data source, but there are many other data series that could be used. Any data that is usually constant, but occasionally changes to a new level is a candidate for this type of chart. Watch the video and let me know
Comments (5) • Trackbacks (0) • Permalink • Tell-a-Friend
