Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart data source
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 |
#2
|
|||
|
|||
Try =IF(H14=0,ISNA(),1780/H14)
Depends on what kind of chart chart though? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Rob" wrote in message ... 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 |
#3
|
|||
|
|||
Hi Ken,
I think you meant NA() instead of ISNA(). =IF(H14=0,NA(),1780/H14) Cheers Andy Ken Wright wrote: Try =IF(H14=0,ISNA(),1780/H14) Depends on what kind of chart chart though? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Dohhhhhhhhhhh - Cheers Andy. So used to testing for it as opposed to
creating one - grrrrrrrrr - :-) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Andy Pope" wrote in message ... Hi Ken, I think you meant NA() instead of ISNA(). =IF(H14=0,NA(),1780/H14) Cheers Andy Ken Wright wrote: Try =IF(H14=0,ISNA(),1780/H14) Depends on what kind of chart chart though? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Andy, sure I'm not going nuts - aren't there a copule of charttypes that
doesn't work on?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip |
#6
|
|||
|
|||
Hi Ken,
Doesn't work for area chart, that still drops to zero. Cheers Andy Ken Wright wrote: Andy, sure I'm not going nuts - aren't there a copule of charttypes that doesn't work on?? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
|
|||
|
|||
Cheers - Knew I wasn't going loopy there.
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Andy Pope" wrote in message ... Hi Ken, Doesn't work for area chart, that still drops to zero. Cheers Andy Ken Wright wrote: Andy, sure I'm not going nuts - aren't there a copule of charttypes that doesn't work on?? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |