LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
NTE
 
Posts: n/a
Default Y axis, need varying units

I'm using Excel 2002.

I have data that looks like this:
X Y
2.56937391 4.077622647
2.58546073 8.180775241
2.589949601 12.29105172
2.657055853 16.50782651
2.741151599 20.8580621
2.854306042 25.38787495
2.862131379 29.9301067
2.935507266 34.58878672
3.192009593 39.65453856
3.250175948 44.812601
3.266936911 49.99726325
3.268343914 55.18415844
3.339451441 60.483902
3.354684554 65.80782066
3.454234896 71.28972673
3.465234095 76.78908865
3.532754379 82.39560594
3.572755465 88.06560537
3.582631439 93.75127807
3.937417581 100

I need to produce a scatter plot in excel. Simple to do in general.
However, the requestor has asked me to have the major y-axis values be these
(evenly spaced on the y axis):

0.1
1
5
20
50
80
95
99
99.9

I was able, using information found at http://PeltierTech.com/ (thank you
Jon) to make a dummy series that would portray the axis as I needed it.
However, the data is still plotted on the "real" axis and obviously does not
line up with the "fake" y-axis values. Because there is a different amount
of "space" between the major ticks, the distance between points will need to
vary.

Any suggestions appreciated. I am going to try a SAS solution as well, but
the end-users prefer to be able to do it in excel.

 
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
Y Axis - Horizontal Bar Graph Eagle Charts and Charting in Excel 1 December 9th 04 01:24 AM
Linking Axis Labels Neil Charts and Charting in Excel 2 December 5th 04 09:04 PM
Secondary Axis? AlCamp Charts and Charting in Excel 3 December 4th 04 02:28 PM
Problems with true value on secondary Y axis NeedHelp Charts and Charting in Excel 1 December 3rd 04 05:56 PM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 06:44 PM


All times are GMT +1. The time now is 07:28 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"