View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
bj
 
Posts: n/a
Default multiple rows and column, chart into 1 series?

select the first series and chart it, then goto <chart<source data <series
click at the end of the "y" entry and enter a comma and select the second
row data, enter another comma, and contiue for the 10 rows. hit enter and
they should be one series.

"Zawa" wrote:


Hi,
I have a table of data let say 10 rows and 50 columns, total 500 data
points.
I would like to chart all 500 points into a single continuous series.
But i keep getting 10 series each have 50 data points.

Thanks in advance,
Zawa


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172