ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Charts (https://www.excelbanter.com/excel-discussion-misc-queries/248156-pivot-charts.html)

GD

Pivot Charts
 
hi, i'm using a pivot chart to show some data in which the X Axis is a Month,
the Y Axis from 0 to 100, and then 5 series with monthly figures between
0-100 to plot as a line graph.
I've achieved what i'm looking for bar one thing, which is in the 'Data'
section where currently all series are 'ticked' to show on the graph, if I
untick one rather than it remaining in the selction unticked and thus
disapearing off the graph, it disapears altogether from the Data box - also,
the formats are tending to reset themselves as well. Any ideas?


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com