Thread: How do I plot non-consecutive data on a chart?

Hi-- please help! My first post, but this site looks so helpful!

I need to make many different charts off of one data table. The table is simple - it has 8 columns, 25 rows. I do not want to chart all of the rows -- just 1-10, then maybe 15,16, and 18-25. Can I chose source data that is not in consecutive rows?? I'm having trouble, but sure it can be done without re-doing the table each time.

Thank you!

Hold down the control key while selecting the subsets of the data and then plot the chart as usual.

The trick is to make sure that all the selected areas, if pushed together, make a complete rectangle with no gaps.