LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
oldwafs
 
Posts: n/a
Default Charting Multiple Series as one line


Hi,

Sorry if this is a dumb question...but I'm stumped.

I want to chart multiple series of data as a continuous line on a
chart, not as seperate lines for each year. I don't know how to link
the series together to make this happen.

Prev
2 54,910 50,470 56,585 55,362 57,086 64,116 69,574 68,975 62,702 65,918 45,600 52,850
Prev
1 59,208 45,975 44,684 49,808 58,267 64,016 64,314 64,472 56,196 54,111 45,757 59,650
Last
Year 60,084 61,768 80,758 70,317 66,054 80,825 71,056 71,779 53,736 75,080 60,279 57,090


I want a line chart that starts at 54,910 and ends at 57,090. I know I
could line them all up in the same row, but this isn't practical for
all the months/years I have to plot.

Hope this makes sense.

Thanks!


--
oldwafs
------------------------------------------------------------------------
oldwafs's Profile: http://www.excelforum.com/member.php...o&userid=30690
View this thread: http://www.excelforum.com/showthread...hreadid=503549

 
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
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
Add series to line graph Barb Charts and Charting in Excel 4 December 8th 05 05:07 PM
need help with charting data from multiple worksheets. at Excel Discussion (Misc queries) 0 December 7th 05 05:46 PM
format data series line width default NoelH Charts and Charting in Excel 4 November 3rd 05 02:51 AM
Floating Bar chart with multiple series OpsMike Charts and Charting in Excel 1 April 15th 05 12:29 AM


All times are GMT +1. The time now is 02:33 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"