Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need my chart to be blank between 2 points but the data
source it takes from contains the following formula =IF(H14=0,"0",1780/H14) even if I change it to =IF(H14=0,"",1780/H14) It still has the same effect unless the cell is cleared using the delete button. This I dont want to have to do because the person entering the information I have asked not to delete formulas Thanks Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) |