Ignoring Series in Graph
Posted by Ben Posaner on May 01, 2001 4:21 AM
I'm having a problem with a graph that's built from data in a pivot table.
Basically I've built a pivot table and used the wizard. I've put my Variable where I want and then used the page option. This builds the pivot table fine and then I build a graph from the data in the pivot table. (The graph is all data). Then if I select the item from the "dropdown" box it rebuilds the table with the vaules that only belong to the item selected in the drop down box. This works fine and the graph changes to reflect only these items. However the graph still contains "blank series" which are shown in the legend.
Is there a way, without going into the graph and changeing/removing series, to just have the series shown in the pivot table.
Note: The choices in the drop down box have different number of variable.
I hope I haven't confused you all.