Thread: Source Data for Chart in Non-Contiguous Area

This is probably a simple No! You can't do that! type question. but I have a data set of daily blood pressure records that I want to be able to turn over to my doctor with a chart showing the BP over time along with the data set. I have been recording the BPs in month-long blocks vertically then moving horizontally for the next month. Is there a way to combine 2 months on the chart or will I have to get all of the data in a single block for it to work?

Thanks for you help! This forum is great!

You can create a chart from non contiguous data, http://peltiertech.com/Excel/ChartsH...ourceData.html

But it is simplier to use a contiguous data range.

You might even be better off using 2 columns of values, Date and Reading, and then use a pivot table and or chart to display the information.

Thanks Andy

That is what I was afraid of. I'll check out Peltier, but will probably end up just giving the Doctor the data and let him chart it if he wants to. I certainly don't need the building of the chart to increase the blood pressure numbers in the data.

Thanks again!