Thread: How do I get source data to show on a chart only if greater than z
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mark Mark is offline
external usenet poster
  
Posts: 989
Default How do I get source data to show on a chart only if greater than z
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?
Reply With QuoteReply With Quote