I have some data that I'd like to put into a Line Pivot Chart.
The data is as follows:
1/1/10 Location 1 98%
1/1/10 Location 2 95%
2/1/10 Location 1 97%
2/1/10 Location 2 93%
3/1/10 Location 1 97%
3/1/10 Location 2 98%
etc.
I'd like to have the months as the x axis of the chart, the locations as the series, and the percentage values on the y axis of the pivot chartI want to be able to show how each location has performed throughout the year. I'd like it as a pivot chart because I actually have 8 locations and I need to have the option to show only 1 or 2 at a time. I can make it work in a chart, but not as a pivot chart. Any ideas?
The data is as follows:
1/1/10 Location 1 98%
1/1/10 Location 2 95%
2/1/10 Location 1 97%
2/1/10 Location 2 93%
3/1/10 Location 1 97%
3/1/10 Location 2 98%
etc.
I'd like to have the months as the x axis of the chart, the locations as the series, and the percentage values on the y axis of the pivot chartI want to be able to show how each location has performed throughout the year. I'd like it as a pivot chart because I actually have 8 locations and I need to have the option to show only 1 or 2 at a time. I can make it work in a chart, but not as a pivot chart. Any ideas?
