I don't want to copy and paste the data into a new format b/c that
will take too much time.

Barb suggests Pivot Tables. It would be wise to learn about these, so you can set up
the data efficiently from the start. This page has an introduction to Pivot Tables,
and a link to other Pivot Table resources:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ramseysgirl wrote:

I have several rows of data that are separated by several other rows (that I
don't want to chart). Is there a way to chart several rows of data on one
continuous axis? For example (see below) I want to chart Row 1, Row 3 and
Row 5 on one axis that would show a trend of 25, 50, 75, 5, 10, 15, 1, 2, 3.
I have tried separting the rows with comas, colons, &, "", + and can't get it
to work. I don't want to copy and paste the data into a new format b/c that
will take too much time. Any suggestions?

Column A Column B Column C
Row 1 25 50 75
Row 2 10 20 30
Row 3 5 10 15
Row 4 2 4 6
Row 5 1 2 3