Graphing question

[daveybohh]

Hi,

I am looking to add a second series to my scatter plot which is just a part of my whole series. For example, I have ten minute data which I have plotted for a month. I would like to add a series to my plot for an individual day, so 144 (24*6) data points. I would also like to link this to a cell, so for example the cell would have the date, say the 3rd, and my series would include 144 data points, from 288 to 432.

Any help would be greatly appreciated.

Thanks.

 

[Andrew Poulsom]

You would need the date and times as as well as the values. To add a series to a chart right click and choose Source Data, Series tab. You can plot the data on a secondary x axis if you add a secondary y axis first.

http://www.andypope.info/tips/tip008.htm