I'd like to revisit this topic. We have very detailed spreadsheets of data
and the row labels change position from year to year, but it's not an option
for us to standardize them because it would make adding new data more
difficult.

That said, how would I edit the series values of a graph so that they could
pull from one row until a certain column is reached, then switch to a
different row. Here's an example.


2000 2001 2003 2004
Ford 14 16 Toyota 30 31
Toyota 32 33 Jeep 25 22
Jeep 26 20 Ford 14 18

How would I graph Ford from 2000 to 2004?

Thank you.

"David Biddulph" wrote:

Yes, but what sort of chart are you trying to produce?

Do you want just one series covering the 3 years, or one series for each
year? If the former, what are you using as your X-values (category labels)?
--
David Biddulph

"Don F." <Don wrote in message
...
I am trying to chart a series of data from multiple rows - ref the
following
table:

YEAR JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
1992 164278 164864 164221 165084 165920 166544 167284 168184 170158 170859
171531 173598
1993 175683 174121 172829 176710 178999 178772 180987 180996 182227 183233
185266 186538
1994 185948 188562 191756 192275 191300 193606 194229 196568 197876 200281
200301 201139

Can this be done without reformating the table? If so how?

Thanks in advance for your help!