Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting a discontinuous series Branchola Charts and Charting in Excel 1 March 6th 08 02:33 PM
Excel Charting: Multiple data series on two axis instead of one? Steven Charts and Charting in Excel 2 February 19th 07 01:56 PM
Charting Multiple Series? Dan Charts and Charting in Excel 1 March 29th 05 07:15 PM
Alternatives for Excel for charting dated time-series? Matthew Pollock Charts and Charting in Excel 2 March 7th 05 01:20 PM
CHARTING W/INDIRECT SERIES Ronbo Charts and Charting in Excel 3 January 3rd 05 05:17 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"