| 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? |
| 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 | |||
Threaded Mode
