Use this range of data, but ignore 0s?

[ThomasCarter]

Hi...

I currently use a chart to tell me what day each report came into my inbox. Occasionally a previously expected report will not be issued at all. I don't want these ones to be tracked with the chart...

Now i know i could use an auto filter on the data itself to hide blanks, but this is inconvenient to me as I do actually want to see the data within the table itself, and creating a separate table that is filtered just for this specific chart would not be very feasible as this is a lot of data we're talking about.

Is there any way to do this in the chart itself?

[Pete_UK]

Post an example workbook then we can more easily visualise how your data is laid out and what you want to do with it.

Pete