Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I disable "Plot visible cells only" when it is greyed out?
I'm creating a chart from a pivot table that has some "zero" values. The
chart will not plot the values that have a zero "y value" along the x-axis and I need to see these. I assume I need to disable "Plot visible cells only." If I Select chart then Tools Options Chart, the "Plot visible cells only" field is grayed out. How can I get this field so I can change it? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I disable "Plot visible cells only" when it is greyed out?
Click on the graph first then go to tools, Options, Charts
"L. Klein" wrote: I'm creating a chart from a pivot table that has some "zero" values. The chart will not plot the values that have a zero "y value" along the x-axis and I need to see these. I assume I need to disable "Plot visible cells only." If I Select chart then Tools Options Chart, the "Plot visible cells only" field is grayed out. How can I get this field so I can change it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable autoformat of "true" and "false" text | Excel Discussion (Misc queries) | |||
How to Count only visible filered cells "FP" | Excel Worksheet Functions | |||
Cannot find "Plot empty cells as" option in 2007 | Charts and Charting in Excel | |||
how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
"treat empty cells as" is greyed out in charts | Charts and Charting in Excel |