View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Position vertical axis

You mean the plot area resizes when the value axis changes from displaying
single digit value to 4 digit values.

You would either need to resize and position the plotarea.

Or use a dummy series to provide the Y value axis labels. This would need to
be a xy-scatter series. And you would remove built-in axis labels.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ken" wrote in message
...
Sorry I wasn't clearer. I already have code to set the max/min. What I
need
to do is to fix the horizontal position of the y-axis so it doesn't change
when the axis numbers change from being short (e.g., 1) to being long
(e.g.,
1,000,000). When the numbers change, Excel automatically changes the
position of the y-axis to match the length of the y-axis unit numbers.

"Andy Pope" wrote:

Hi,

Either use code to set the min/max values of the axes in both charts.
Or add a dummy series that contain the min and max value for both sets of
data. The series will cause the Auto scaling of the axes to at least be
consistent.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ken" wrote in message
...
I have two charts that have the same category data but different y-axis.
I
would like to keep the vertical axis for both charts aligned. The
bottom
chart is populated via VBA & the y values can range from 0.1 to
millions.
How do I pin the y-axis so that it does not reposition itself when the
magnitude of the axis label changes?