Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Suppres Zero or empty Cell value in a line graph
Hi I'm using Office 2007. I have two charts using data from the same sheet.
The second graph is a copy of the first. In the first graph, the empty and zero value cells are not displayed. In the second graph, the zero value cells is displayed (draged to zero) although the option "connect points with line" is checked. The strange thing: if I change the Y-data to another part of the sheet, it is no longer dragged to zero. Even if the cell is empty it's still dragged to zero |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Suppres Zero or empty Cell value in a line graph
A formula that returns "" is not an empty cell, it's a formula (or it's a
small piece of text). If you want the line to connect the points on either side, substitute NA() for "" in your formula. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Michael van E" <Michael van wrote in message ... Hi I'm using Office 2007. I have two charts using data from the same sheet. The second graph is a copy of the first. In the first graph, the empty and zero value cells are not displayed. In the second graph, the zero value cells is displayed (draged to zero) although the option "connect points with line" is checked. The strange thing: if I change the Y-data to another part of the sheet, it is no longer dragged to zero. Even if the cell is empty it's still dragged to zero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create blank empty square cell graph template | New Users to Excel | |||
how to create blank empty square cell graph template | Charts and Charting in Excel | |||
Hide the line when cell B is empty | Excel Discussion (Misc queries) | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
How To Suppres #N/A Values | Excel Worksheet Functions |