Hello,
I have a month of temperature readings from a silo that is emptied every day or two. I need to be able to plot the recorded temperatures as as single series with gaps included to show when the silo was emptied; attached is an image of what I am hoping for. I did not think that this would be very difficult, but I cannot find a way to switch the charts series from a single row to taking from multiple rows.

Here is a minor example of my data that I am using (Excel 2010):

7/14/2012 35.9
7/15/2012 33.5 33.7 34.0
7/16/2012 33.8 33.7
7/17/2012 35.5
7/18/2012 32.5 33.2

The gaps in the temp recordings are when the silo was empty

multiple series graph.jpg