Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Variable or Split vertical axis scales

I'm charting figures that have about 5 numbers ranging from 1 million to 4
million and then the other dozen are all bunched together under half a
million. Is it possible to have two vertical scales? for instance the
initial scale from zero to half a million by units of $50,000 and then after
$500,000, the scale goes from 1 million to 4 million in half million
increments?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 396
Default Variable or Split vertical axis scales

You could plot a series on a second vertical axis.

Right click the chart series, choose options and in one of the tabs you can
indicate this.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Bone Daddy" wrote:

I'm charting figures that have about 5 numbers ranging from 1 million to 4
million and then the other dozen are all bunched together under half a
million. Is it possible to have two vertical scales? for instance the
initial scale from zero to half a million by units of $50,000 and then after
$500,000, the scale goes from 1 million to 4 million in half million
increments?

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 396
Default Variable or Split vertical axis scales

I meant: Right click the chart series, choose Format data series... and then
in the Axis tab.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Wigi" wrote:

You could plot a series on a second vertical axis.

Right click the chart series, choose options and in one of the tabs you can
indicate this.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Bone Daddy" wrote:

I'm charting figures that have about 5 numbers ranging from 1 million to 4
million and then the other dozen are all bunched together under half a
million. Is it possible to have two vertical scales? for instance the
initial scale from zero to half a million by units of $50,000 and then after
$500,000, the scale goes from 1 million to 4 million in half million
increments?

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Variable or Split vertical axis scales

Here's an alternative approach. It's more work, but may be less confusing to
read than a chart with primary and secondary axes:

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

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


"Bone Daddy" <Bone wrote in message
...
I'm charting figures that have about 5 numbers ranging from 1 million to 4
million and then the other dozen are all bunched together under half a
million. Is it possible to have two vertical scales? for instance the
initial scale from zero to half a million by units of $50,000 and then
after
$500,000, the scale goes from 1 million to 4 million in half million
increments?



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
3 different scales on the Y-axis coastal Excel Discussion (Misc queries) 4 July 11th 07 02:27 PM
How do I add two vertical scales to a line graph? IronRobbie Charts and Charting in Excel 1 June 12th 07 02:46 AM
could I have dual scales on the same axis Steve Charts and Charting in Excel 1 July 28th 06 03:06 AM
Two different y-axis scales? Chris Charts and Charting in Excel 3 April 25th 06 12:19 AM


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