LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.charting
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!




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have chart w/ data table - how can i control which series plot ShannaD Charts and Charting in Excel 1 February 15th 07 09:08 PM
Pivot Chart - multiple Data series Andy Charts and Charting in Excel 4 January 5th 07 05:39 PM
Create multiple data series for a chart in one shot... ronbrosh111 Charts and Charting in Excel 5 June 6th 06 06:16 PM
multiple rows and column, chart into 1 series? Zawa Charts and Charting in Excel 5 March 10th 06 12:21 AM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"