View Single Post
  #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