Dynamic Chart Review
by Jon Peltier
Tuesday, May 5th, 2009
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
My colleague and fellow MVP Debra Dalgleish shows a dynamic chart approach that lets you Select Excel Chart Dates From a Drop Down List.
Debra has provided her usual comprehensive step-by-step instructions and an example workbook you can download. Her example was done in Excel 2007, but it works as well in previous versions.
Debra contributed the first Dynamic Chart example on my fledgling web site, back when it was still just a hobby on GeoCities.
Here are more dynamic chart tutorials I’ve written:
- On the PTS Blog
- On the Peltier Tech web site
- Published in TechTrax ezine
Related Posts:
- Dynamic Chart with Multiple Series
- Dynamic Chart using Pivot Table and Range Names
- Dynamic Charts
- Grouping by Date in a Pivot Table
- Referencing Pivot Table Ranges in VBA
- Dynamic Chart using Pivot Table and VBA
- Dynamic Ranges to Find and Plot Desired Columns
- Explore Your Data With Pivot Tables
- Dynamic Chart Source Data
- Using Pivot Table Data for a Chart with a Dual Category Axis
Posted: Tuesday, May 5th, 2009 under Dynamic Charts.
Comments: 1
Comments
Comment from Gunjan
Time: Wednesday, May 6, 2009, 1:09 am
I have also written article on Dynamic Charts. Check at http://www.webanalyticsindia.com/2008-12-17/dashboard-design-tricks-using-combo-box-for-a-neat-treat/
Write a comment
I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.
If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.
Read the PTS Blog Comment Policy.