| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I leave out blank cells in a line graph?
I have a line-graph linked to a table of data. Some cells in the data table
are blank (these cells have an apostrophe in), and at the moment the line graph displays these cells as zeros. But I'd like these blank cells to be omitted in the graph, and not displayed as 0. I've tried 'ToolsOptionsChart' but the 'Plot empty cells as Not plotted is greyed out'. Can anyone help?! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I leave out blank cells in a line graph?
Either blank, or with an apostrophe, won't be treated as empty. If the
cells aren't totally empty, try replacing the contents by N/A#. Perhaps IF(ISNUMBER(A1),A1,NA()). -- David Biddulph "Kirsty W" <Kirsty wrote in message ... I have a line-graph linked to a table of data. Some cells in the data table are blank (these cells have an apostrophe in), and at the moment the line graph displays these cells as zeros. But I'd like these blank cells to be omitted in the graph, and not displayed as 0. I've tried 'ToolsOptionsChart' but the 'Plot empty cells as Not plotted is greyed out'. Can anyone help?! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose from one sheet to the next and leave out blank cells | Excel Discussion (Misc queries) | |||
| Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel | |||
| Do not show lack of data as a zero on graph lines, leave blank | Charts and Charting in Excel | |||
| leave cells blank #2 | Excel Worksheet Functions | |||
| Leave Cells Blank | Excel Worksheet Functions | |||
Linear Mode
