How do I disable "Plot visible cells only" when it is greyed out?

L

L. Klein

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Surpressing plot of blank cells 3
How do I plot "" as empty rather than zero in a chart 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
HOW THE HELL Can I get excell to stop ploting blank cells 4
XY chart not dropping off to 0, when there is not value 4
How do I put words as the Y axis values? 0
Charting null values 4
How do I eliminate empty cells from plotting on chart 1

Top