View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] carlo.stenali@gmail.com is offline
external usenet poster
 
Posts: 3
Default problem with Excel graphs

thank you,
I did forgot scattered charts,
Carlo

Make an XY chart using the first data set
Select and Copy the second data set
Click chart to activate it
Use Edit | Paste Special and specify New Series & Category (X values) in
First Column
And now you have two data series on the chart
best wishes


I have two data series (where points are unrelated apart from x,y
values) coming from experiments
first (x,y)
1.23,340
1.4,320
1.5,360
1.7,400
second
1.25, 420
1.33,450
1.41, 470
1.6,500
1.85,470
1.7,400


I wish to *create a graph in Excel 2003 and have x and y axis in a
suitable range as x 1.0..2.0, y 200..500 however I am unable to
instruct Excel to do that, comments and suggestions are very
appreciated,
Carlo