Excel 2007 option

  • Thread starter Thread starter DPingger
  • Start date Start date
D

DPingger

The display option for charting 0 values is fixed on Zero; the gap option is
grayed out. How do I get this fixed or is there a step I'm missing?

TIA.


Dpingger
 
If your chart is a column chart or a combo chart that includes a column
series, the setting may be disabled. Start with a line chart, change the
setting, then convert the series to the types you need.

- Jon
 
Thanks for responding, Jon.

Yes it is a line chart, i should have said that earlier, and it's still
grayed out. That's why I'm perflexed. Is there another setting someplace that
I should check?

TIA

dPingger
 

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

Cannot find "Plot empty cells as" option in 2007 7
Charting blanks as spaces 1
Dont have secondary axis option listed in Series Option 3
Skipping Text Entries 4
How do I disable "Plot visible cells only" when it is greyed out? 1
Displaying zero values as gap in a chart 1
"treat empty cells as" is greyed out in charts 1
Zero Values on a Pie Chart 2

Back
Top