Dynamic Charts - Changing Number of Series

[Ben Weyenberg]

I've read a lot of the entries regarding Dynamic Charts and think I
understand it for a single Series, but I'm having trouble getting it to work
when it's the number of Series that changes and the Category is static.

I'm using a line graph (data sample below) for sales at different locations
of dealerships during past years. Each dealership has a different number of
locations so I have an advanced filter that provides the unique locations by
dealer and would like the graph to adjust to the number of locations that are
returned.

Location Location Name 2005 2006 2007
800401 ABC TRUCKING 662 201 152
221081 XYZ TRUCKS INC 1523 2536 3478
657411 1234 Trucks 3542 5654 9888

Am I just having trouble rapping my brain around something simple? Thanks.

 

[Del Cotter]

I've read a lot of the entries regarding Dynamic Charts and think I
understand it for a single Series, but I'm having trouble getting it to work
when it's the number of Series that changes and the Category is static.

Dynamic charts as designed aren't able to change the number of series,
only the number of points in an existing series.

Have you tried a pivot chart?

 

[Jon Peltier]

If you don't mind a little VBA, this technique will help:



Dynamic Chart Source Data

http://peltiertech.com/WordPress/2008/07/03/dynamic-chart-source-data/


- Jon

 

[Ben Weyenberg]

Thank you very much! I think this will work.

If you don't mind a little VBA, this technique will help:



Dynamic Chart Source Data

http://peltiertech.com/WordPress/2008/07/03/dynamic-chart-source-data/


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______