How do I get source data to show on a chart only if greater than z

[Mark]

I am creating a chart that depicts fleet expenses. I want the chart to draw
from the selected source data only if the value is greater than zero. I am
knew to Excel and this has stumped me. I have 22 various entries for
expenses (oil change, etc.). I want the chart to check the table and if
there is an entry - chart it. Is this possible?

 

[Bernard Liengme]

In place of zero (or empty cell) use =NA(). This displays as #N/A and is
ignored by chart
Alternatively, activate the chart; use Tools | Options and open the Chart
option tab. There you can specify how empty cells are to be treated
best wishes

 

[Luke M]

If cell is actually blank:
Go to Tools-Options-Chart

Change it plot empty cells either as gaps, or interpolated.

If cell has a 0 in it:
Change the formula that generates the 0 so that is displays #N/A instead, i.e.
=IF(A1>B1,NA(),A1-B1)

 

[Mark]

Thank You,
I tried it and it seems to be working great. I appreciate you taking the
time to help me out. Thanks, Mark.

 

[Mark]

Thanks Luke,
It works! Thanks for your time. Mark.