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

[jsnyder]

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!

[mrice]

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

[jsnyder]

Thanks for the quick response...

I swear I tried that and got an error in the chart source data. But now that I know it should work, I will try again monday when at the office.

Thank you!!! Jennifer

[mrice]

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