Search results for query: *

Yes your assumption is right. You can filter the data, but I don't see a way to make the data that is in row 255+ to display. It will only display the data that is in the original unfiltered first 255 rows.

X axis contains the months, y axis is the numbers for the data each month.

Skip that was just a simple example to show what I wanted it to be able to do. My actual data goes something like Area Zone Location Substation Circuit # Jan Feb Mar.. N W City xyz 1234 1 2 3 S E Town abc 9876...

I am using a pivot table because I have ~950 series of data and I can not use a normal chart with that much data. I am doing a spreadsheet involving some power distribution reliability numbers. I have the data and would like to filter it by region, area, substation etc and have that "filter...

I have a pivot chart and table set up with some data I am working on for work. I when I filter data on the chart I would like to make it able to "filter down" if possible. Here is a quick basic example of what I would like to be able to do. If this was the data Column 1 | Column 2 | Column 3...

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...

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.

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...