#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,069
Default extended y-axix

Do you know of a method in excel to condense the y-axis such that you still
use zero as the origin when your data is centered on, say, 5,000,000?

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default extended y-axix

You mean this?

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John" wrote in message
...
Do you know of a method in excel to condense the y-axis such that you
still
use zero as the origin when your data is centered on, say, 5,000,000?



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
extended formulas izzyt1972 Excel Discussion (Misc queries) 3 April 12th 07 09:42 AM
extended List box Ken Williams New Users to Excel 7 November 11th 06 03:37 AM
Formating text of x-axix value Jon Peltier Charts and Charting in Excel 0 February 24th 06 11:46 PM
Formating text of x-axix value Karel Charts and Charting in Excel 3 February 24th 06 11:44 PM
Geo mean extended Stephen Excel Worksheet Functions 0 January 18th 05 03:03 PM


All times are GMT +1. The time now is 10:24 AM.

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"