Dynamic Charts - Changing Number of Series

  • Thread starter Thread starter Ben Weyenberg
  • Start date Start date
B

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.
 
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.
Click to expand...

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?
 
Back
Top