| 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 | |||
Hybrid Mode
