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!

I am combining data - line and bar - using two series of data on two axes.

I want one series for 3 years for each axes. X value will be the year
segmented by months.

"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!

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!

On Tue, 3 Jun 2008, in microsoft.public.excel.charting,
mrobles said:

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.

Give the two tables Range Names, say TABLE1 and TABLE2. Then use VLOOKUP
to find Ford in the table that corresponds to the appropriate year:


table TABLE1 TABLE1 TABLE2 TABLE2
column 1 2 1 2

2000 2001 2003 2004
Ford X X X X
Toyota X X X X
Jeep X X X X

Everywhere I have put "X", put a formula like:

=VLOOKUP($A1,table,column,FALSE)

to find your data in the tables. Then use the final table as a source of
your chart.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.