The sample chart is not the actual data. Basically, my rows contain data by
fiscal year. The columns would be the months of the year. The tricky part
is I want to select rows that are not in succession (i.e. every other row for
example). I want my end chart to be fiscal years FY 01 - FY 05 data on one
constant line on a line chart. The x axis is the fiscal years, the y axis is
my numerical data.

Since I posted this I actually made it work by putting the selected data in
a series rather than a data range. Now I'm just trying to add several titles
to one axis (fy01, fy02, etc).

"Barb Reinhardt" wrote:

What is the difference between the three groups of data? Were they
collected at different times or are they a continuation of data collection.
I think I see what you want (after reading it through several times), but
don't understand the purpose.

"ramseysgirl" wrote in message
...
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