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.

Hi,

You need to use code.
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
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.