Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Show value in Data Table but not on live chart
I am wanting to make a pivot chart that will show four data items in the data table, and only show two of the items in the line chart. I have found I can hide the lines, then I have to change and limit the Y axis. If I change to a different pivot item, then I have to rehide the lines again. Is there a simpler way to limit the lines in the chart and still keep the four items in the data table?
Thanks, Ed |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Show value in Data Table but not on live chart
Ed -
About all you could do is record a macro while you fix the pivot chart, then run the macro each time you repivot the table. Pivot charts and tables are notorious for losing any custom formatting when the pivot table changes. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Gonepostal" wrote in message ... I am wanting to make a pivot chart that will show four data items in the data table, and only show two of the items in the line chart. I have found I can hide the lines, then I have to change and limit the Y axis. If I change to a different pivot item, then I have to rehide the lines again. Is there a simpler way to limit the lines in the chart and still keep the four items in the data table? Thanks, Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Can you show data in a data table but not plot it on the chart? | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel |