M
medicenpringles
i'm looking for a function that i can use to put gaps in my chart w/
having to leave the cell empty. currently, the formula i have in eac
cell is =IF(B6>B5,B6,NA()). my problem is, when i make the chart
Excel simply doesn't show a plot point at that point and draws the lin
to the next point in which a cell shows a value instead of "#N/A".
want it to not draw the line, but leave a gap and only plot the poin
as if i had left the cell blank. is this possible?
thanks much,
stephe
having to leave the cell empty. currently, the formula i have in eac
cell is =IF(B6>B5,B6,NA()). my problem is, when i make the chart
Excel simply doesn't show a plot point at that point and draws the lin
to the next point in which a cell shows a value instead of "#N/A".
want it to not draw the line, but leave a gap and only plot the poin
as if i had left the cell blank. is this possible?
thanks much,
stephe