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

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
One extra x axis item that wont go away - can anyone help? 3
Data labels along below x axis when y axis has negative values 1
Scatter chart with categories on x-Axis 2
simple chart 0
Align Y axis labels 1
change chart primary horizontal axis label or name 1

Top