 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / December 2006How to start Y-axis scale at odd value and have tick labels at even values?
On either an XY chart or on a scatter chart, I want to have a secondary Y axis (showing temperature) that goes from 32 to 212. But I want the labels to be at multiples of 10 (e.g., 40, 50, 60, - - - , 190, 200, 210). The reason that I want to do this is because the secondary axis is degrees FAHRENHEIT and I need for it to match the primary axis which goes from 0 to 100 degrees CENTIGRADE. How can I create a secondary Y axis with a scale that starts at 32 and has tick labels at even multiples of 10? Paul S. Natanson +1-908-630-0406 paul628 at concentric dot net December 26, 2006. Excel chart axes always put the first tick at the minimum and count by the major unit from there. You could use a dummy XY series to apply your own custom axis scale: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > On either an XY chart or on a scatter chart, I want to have a secondary Y > axis (showing temperature) that goes from 32 to 212. But I want the [quoted text clipped - 9 lines] > Paul S. Natanson +1-908-630-0406 paul628 at concentric dot net > December 26, 2006. Jon: Your web site shows that you have come up with a clever work-around that just might solve my problem. Many thanks. Paul 12-26-06 xxxxxxxxxxxxxxxxxxxxxxxxxx > Excel chart axes always put the first tick at the minimum and count by the > major unit from there. [quoted text clipped - 24 lines] >> Paul S. Natanson +1-908-630-0406 paul628 at concentric dot net >> December 26, 2006. Paul - I've used the workaround for this and for many other purposes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Jon: Your web site shows that you have come up with a clever work-around > that just might solve my problem. Many thanks. Paul 12-26-06 [quoted text clipped - 29 lines] >>> Paul S. Natanson +1-908-630-0406 paul628 at concentric dot net >>> December 26, 2006. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.