"treat empty cells as" is greyed out in charts

F

Fletch260473

I've upgraded to Office 2007 and opened an Excel workbook from Excel 2000
which contained a number of graphs both on sheets and on tabs of their own.
One graph is fine but the others are screwed up because of the way it is
treating empty cells or gaps in the data.

The radio buttons for "treat empty cells as" is grayed out except for the
"zero" option. On the graph that is OK I can choose the option to leave a
gap and its fine.

Does anyone know why this has happened or how I can correct this?
 
J

Jon Peltier

The availability of that setting depends on the chart type. I haven't dealt
with this enough in 2007 to know if this dependency has changed. I do know
that combination charts in general behave differently in subtle ways than in
earlier versions, and this may be one of them.

- Jon
 

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

Hidden and Empty Cell Settings 0
Save is Greyed Out 1
How do I get all 5 graph charts to show data (not be greyed out)? 1
Suppres Zero or empty Cell value in a line graph 1
Excel 2007 charts: want to avoid zero values 1
charting missing data (empty cells bug) 2
Cannot find "Plot empty cells as" option in 2007 8
How do you make a hole in a line graph? 2

Top