Dynamic Charts - Changing Number of Series

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 <Ben@Weyenberg.?.microsoft.com.invalid> 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 del@branta.demon.co.uk,
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/20...rt-source-data/


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


"Ben Weyenberg" <Ben Weyenberg@discussions.microsoft.com> wrote in message
news:5134626A-F977-4387-8F09-6F137DA8EFEF@microsoft.com...
> 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/20...rt-source-data/
>
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Ben Weyenberg" <Ben Weyenberg@discussions.microsoft.com> wrote in message
> news:5134626A-F977-4387-8F09-6F137DA8EFEF@microsoft.com...
> > 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.
>
>
>