View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Excel charting of 2 unrelated series

Were you unable to follow my suggestions in the Chart newsgroup? Did you not
get a private email from me with a video showing how?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
I have two data series (with different number of points which are
unrelated but specified on the same units)
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, it seems it requires some sort of relation
(by rows etc.) but my series are unrelated, comments and suggestions
are very
appreciated,
Carlo