mark a particular point on a graph

  • Thread starter Thread starter Mark Kennedy
  • Start date Start date
M

Mark Kennedy

I want to mark a particular point on a graph with a line.

When I have a series of blank cells with a 2.5 in two cells the middle, it
will show a line on the chart at 2.5 only which is what I want.

The problem is I want to do this with an IF statement. =IF(E1=2.5,2.5,"")
copied across the row. This shows a line at 0 which increases to 2.5 and
decreases to back to 0, which is not what I want.



_____

----/ \-------



How can I fix this?



Mark
 
Change the formula to =IF(E1=2.5,2.5,NA())
Now you will get #N/A in the cells rather than a blank and Excel will ignore
this when charting.

Best wishes
 
Thanks Bernard

Only problem is, the #N/A looks pretty ugly.

Is that the only solution?

Regards
Mark
 
Hi
only blank cells or #NA are ignored in charts. But you can hide the #NA
errors with conditional formating. Lets say your errors could appear in
F1:F100:
- select this range
- goto 'Format - Conditional Format'
- enter the formula
=ISNA(F1)
- choose a white font color
 
Back
Top