Auto Label Y Axis Values

B

BoRed79

I am producing a dynamic chart and would like to be able to specify the
labels for the y axis of my chart automatically (based upon a formula),
rather than letting Excel set the scale.

I believe that to do this I need a macro - but I am new to using these and
dont really know where to start.

Basically the chart is on a sheet called Graph and the data that I want to
use for the minimum and maximums are in cells T4 and T5 on a sheet called
tables (although I have also named the cells Min and Max too).

Any help would be greatly appreciated.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
Data labels along below x axis when y axis has negative values 1
Y Axis : Dynamically Hardcode Min/Max Values? 1
Coordinate secondary y axis to primary y axis 2
y-axis auto scaling... 2
Make Y-axis values correspond to x- axis value 1
Chart - Secondary Y-axis with different values/scale 2
Changing y axis labels 1

Top