A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using a variable for a chart limit



 
 
Thread Tools Display Modes
  #1  
Old June 27th, 2008, 05:22 PM posted to microsoft.public.excel.charting
Vince F
external usenet poster
 
Posts: 4
Default Using a variable for a chart limit

Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.
--
Vince F
  #2  
Old June 27th, 2008, 07:39 PM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default Using a variable for a chart limit

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3  
Old June 28th, 2008, 11:19 AM posted to microsoft.public.excel.charting
Vince F
external usenet poster
 
Posts: 4
Default Using a variable for a chart limit

Andy
Thanks. I have handed this off to our local VBA expert and he says this
should do it. Take care.
--
Vince F


"Andy Pope" wrote:

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #4  
Old May 11th, 2010, 03:07 AM posted to microsoft.public.excel.charting
PYO1012
external usenet poster
 
Posts: 4
Default Using a variable for a chart's primary and secondary limits

How would you do this with a secondary axis? My issue is I have 2 Y axes and
I want them both to adjust relative to each other based on the data. I know
I can manually change the maximum values, but I would rather change the value
in which the 2 axes relate and have the charts adjust accordingly.

For example, 6 on the primary axis will equal 1 on the secondary, 12 will be
2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish
that without manual chart adjustments?

Phillip

"Andy Pope" wrote:

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #5  
Old May 11th, 2010, 09:08 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default Using a variable for a chart's primary and secondary limits

Hi,

The same way only you need to reference the secondary axis.

With ActiveChart.Axes(xlValue, xlSecondary)
.MaximumScale = 6
' Constant value
.MinimumScale = dYmin
' VBA variable
.MajorUnit = ActiveSheet.Range("A1").Value
' Worksheet range value
End With

Cheers
Andy

Read mo
http://peltiertech.com/Excel/Charts/...#ixzz0nbeBaxVT


On 11/05/2010 03:07, PYO1012 wrote:
How would you do this with a secondary axis? My issue is I have 2 Y axes and
I want them both to adjust relative to each other based on the data. I know
I can manually change the maximum values, but I would rather change the value
in which the 2 axes relate and have the charts adjust accordingly.

For example, 6 on the primary axis will equal 1 on the secondary, 12 will be
2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish
that without manual chart adjustments?

Phillip

"Andy Pope" wrote:

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #6  
Old May 20th, 2010, 01:56 PM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default Using a variable for a chart's primary and secondary limits

One (non-VBA) approach is to plot a dummy series with appropriate values
on each axis and then make this invisible (no lines, no markers), then
set both axes back to automatic.
So for axis 1, plot the MAX value (or maybe use
CEILING(MAX(your_range),2) to round up to the next 2 or 5 or some other
'round' number).
For axis 2 plot a dummy series which is 1/6 of the one you worked out
for axis 1.

Hope this helps.
Adam

On 11/05/2010 03:07, PYO1012 wrote:
How would you do this with a secondary axis? My issue is I have 2 Y axes and
I want them both to adjust relative to each other based on the data. I know
I can manually change the maximum values, but I would rather change the value
in which the 2 axes relate and have the charts adjust accordingly.

For example, 6 on the primary axis will equal 1 on the secondary, 12 will be
2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish
that without manual chart adjustments?

Phillip

"Andy Pope" wrote:

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.