Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 09, 10:12 PM posted to microsoft.public.excel.charting
Ken Ken is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 590
Default Position vertical axis

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?

  #2   Report Post  
Old May 6th 09, 08:29 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Position vertical axis

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?


  #3   Report Post  
Old May 6th 09, 01:16 PM posted to microsoft.public.excel.charting
Ken Ken is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 590
Default Position vertical axis

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?



  #4   Report Post  
Old May 6th 09, 02:52 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?




  #5   Report Post  
Old May 6th 09, 03:41 PM posted to microsoft.public.excel.charting
Ken Ken is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 590
Default Position vertical axis

Exactly my issue. Any way to resize via VBA? I'm trying to use the LEFT &
WIDTH of the axis & plot area to automatically figure out where the axis is
after it resizes & then resize to get the axis where I want it w/o success

"Andy Pope" wrote:

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?






  #6   Report Post  
Old May 7th 09, 04:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Position vertical axis

Hi,

You will need to adjust the WIDTH and LEFT properties of the plotarea but
you want to use the
INSIDELEFT and INSIDEWIDTH properties to determine whether you have the
correct position.

So first get the required positions, even just before changing values that
will alter the axis or from another chart.
The adjust the left and width properties whilst comparing the insideleft and
insidewidth properties.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ken" wrote in message
...
Exactly my issue. Any way to resize via VBA? I'm trying to use the LEFT &
WIDTH of the axis & plot area to automatically figure out where the axis
is
after it resizes & then resize to get the axis where I want it w/o success

"Andy Pope" wrote:

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?







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
position of vertical axis marshashing Charts and Charting in Excel 2 April 3rd 09 04:42 PM
Finding the position of the i-th non blank cell in a vertical range vsoler Excel Worksheet Functions 6 September 11th 08 06:59 AM
Graph - display Category (X) axis in the vertical position Idoia Excel Discussion (Misc queries) 3 April 8th 08 11:07 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 09:45 PM
Multiple charts in one big chart -- how to rotate to vertical position? Father Guido Charts and Charting in Excel 4 December 1st 05 01:35 PM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017