• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Chart with list box in Excel 2010

F

finlain

New Member
Hi

Years ago I created (with a lot of help from Andy Pope) a very cool dynamic chart that I was able to select the data series from a list box and my chart changes. I used named ranges with the Offset function.

I have tried and tried to duplicate and I am having no luck in the new Excel 2010. Is there a new easier way to execute this task that I am missing.

Any help or examples would be great.

Thanks

Elaine
 
Jon Peltier has an extensive set of articles on using/creating dynamic charts.

http://peltiertech.com/Excel/Charts/Dynamics.html
 
Yes I have used some of these as well but unfortunately I am not finding the type that I like. I am not so much interested in the data gowing and being "dynamic" as I am being able to select each "set of data" independent of one another.
 
About half way down the page were details on choosing which series of data you want, or even what type of chart to make. Can the techniques from one of these be adapted to your need?
 
Hi ,


Have you checked out these ?


1. http://peltiertech.com/WordPress/dynamic-chart-source-data/

2. http://answers.microsoft.com/en-us/office/forum/office_2010-excel/dynamic-charts-in-excel-2010/abe03edd-653a-46e3-b66b-64da37a89a76

3. http://dmoffat.wordpress.com/2011/05/27/dynamic-range-names-and-charts-in-excel-2010-the-right-way/


Narayan
 
You must log in or register to reply here.
Back
Top