View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Don F.[_2_] Don F.[_2_] is offline
external usenet poster
 
Posts: 2
Default Is it possible to chart series data from multiple rows in a ta

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!