Using a variable for a chart limit

  • Thread starter Thread starter Vince F
  • Start date Start date
V

Vince F

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
Thanks. I have handed this off to our local VBA expert and he says this
should do it. Take care.
 
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
 
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
 
Back
Top