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.

On Wed, 2 Jul 2008, in microsoft.public.excel.charting,
Ben Weyenberg said:
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?
--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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



Dynamic Chart Source Data

http://peltiertech.com/WordPress/200...t-source-data/


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


"Ben Weyenberg" <Ben wrote in message
...
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.

Thank you very much! I think this will work.

"Jon Peltier" wrote:

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



Dynamic Chart Source Data

http://peltiertech.com/WordPress/200...t-source-data/


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


"Ben Weyenberg" <Ben wrote in message
...
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.