Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing a charts series order | Charts and Charting in Excel | |||
Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel | |||
Make dynamic charts more dynamic | Charts and Charting in Excel | |||
Large number of dynamic charts | Charts and Charting in Excel | |||
Changing series information for approximately 60 series in a workb | Charts and Charting in Excel |