Excel 2007 Pivot Chart Help

[tennisjon2002]

I am doing an excel sheet for work but I am completely stumped on a problem.
This is my first time using a pivot table. I am doing a very large dynamic chart and just need to display the data on a graph. I can't use a normal chart because there are more than 255 series in the data. I can't seem to get the pivot chart to plot the actual data though and not the sums.
For example on this graph:

The series shown is one of the ones on the very top of the chart in the 700-800 range, but the value that I want it to actually graph is only 6? How can I get it to do this?

Here are my pivot table and chart lists:

Any ideas? Thanks!

 

[SkipVought]

Hi,

Your data may be 6, but ALL the data is STACKED. So YOUR 6 might be near the top, where the y-axis valus is highest OR it could be near the bottom of the stack, depending on the ORDER of the data.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[tennisjon2002]

SkipVought, after looking over the data I see what you are saying.
How do I make it graph the point and not order of the stack? It seems like it would be simple enough to do but I can't seem to figure it out.

 

[SkipVought]

So what want to chart 255+ points across your x-axis?

What story are you trying to tell?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[tennisjon2002]

Here is an idea of what I have:

Area | Zone | Location | Substation | Circuit # | Jan | Feb | Mar | Apr | May | June.....
X......Y.........Z............A................1.. ...........0......4.......5.......1......2
Z......A.........C............B................2.. ...........1......0.......1.......2......0
. . . . . . . . . .
. . . . . . . . . .

There are 950 rows. I need to be able to filter the circuits by area, zone, substation etc and have the filtered data show in the graph.

 

[SkipVought]

Filtering the chart source data is a good technique to control your chart.

You can place Forms controls on your chart to aid in the control of what is displayed. What you'll need to do is create dependencies, so that when the Area is selected (in a ComboBox), a query runs, using that selected Area values and the resulting Zone is listed. When the Zone is seleted, a query runs using the selcted Area and Zone, shoing the Location. And etc. I have never used that many levels, but it is possible that drill down to the specific level of detail you want to view in the chart.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}