Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
"treat empty cells as" is greyed out in charts
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
"treat empty cells as" is greyed out in charts
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Fletch260473" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating with empty-string ("") cells removed | Excel Worksheet Functions | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
How can I "glue" a picture in a cell and treat it as content? | Excel Discussion (Misc queries) | |||
Excel "recently used files" setting is greyed out. How to use it? | Excel Discussion (Misc queries) | |||
Sorting with formulaically "empty" cells | Excel Worksheet Functions |