Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
blank cells
Perhaps I am trying to use the wrong kind of chart... I have information in
a pivot chart that I want displayed in lines. However there are some cells that have no information in the series I want to plot. But there is other information in the row, so it doens't ignore it as a blank cell. For example: Days Actual High Low 2 3 5 2 7 5 3 15 2.5 4 2 When I chart the actual series, it reads the blank as a zero and plots it as such. My columns in the pivot charts are averages. Is there any way I can get the chart to ignore the zero and still plot a line to the next point? I have tried using the excel options and the pivot chart options for ignoring blanks but it hasn't worked so far. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions |