ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel charting of 2 unrelated series (https://www.excelbanter.com/excel-discussion-misc-queries/222859-excel-charting-2-unrelated-series.html)

[email protected]

Excel charting of 2 unrelated series
 
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

Bernard Liengme[_3_]

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





All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com