Excel: Create Scrolling Charts
Posted on Thursday, May 17th, 2007. Filed under Microsoft Excel.
My friend Peter showed me a very cool method of creating a graph or chart that lets you scroll through the time periods (or your x-axis) using a scroll bar. It involves setting up a few defined ranges containing formulas and using a scroll bar to control the starting point of your x-axis. You configure your graph to use named ranges as the sources for your data series. These ranges contain formulas.
Here is an example excel spreadsheet: Excel Scrolling Graph demo. I’ve zipped the spreadsheet and also made sure that it doesn’t contain any macros. You probably know this, but you should never enable macros (VBA) in workbooks that you download from the web unless you 100% trust your source. This trick doesn’t use macros or VBA, so if you get Excel asking you to enable them, don’t!
Here is a very detailed article explaning of how to make scrolling chart magic!
You can now:
Read Comment (1). Or, Leave A Trackback. Or, view Comments Feed.Previous Post: Automated Functional Testing Tools - Evaluation Guide »
Next Post: SAP vs. Oracle - Game On! »
One Response to “Excel: Create Scrolling Charts”
Leave a Reply
Note: Any comments are permitted only because the site owner is letting you post, and any comments will be removed for any reason at the absolute discretion of the site owner.You must be logged in to post a comment.
May 22nd, 2007 09:08
[...] math behind this is a bit tricky, but it’s all right there in the Excel formulas. Like the scrolling graph demo, this one doesn’t require any macros. I’ve included a demo file zipped up: Excel [...]