Add Text to Chart when Data Value = 0

[MikeSr]

The chart generated from a query contains data for both temperature and flow over time. Occationally the data shows zero for n records. Time and zero data are still recorded.
I need to place either a marker of some text over the zero data area on the chart stating "Communications Failure" as this is the reason for lost data.
Any ideas to ackomplish this would be very much appreciated.

Regards,

 

[Mr Smin]

Until someone comes by with a robust answer, can you take the query output to excel (which will generate a graph and allow you to manually add objects like text on top of it)?