View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
BoRed79 BoRed79 is offline
external usenet poster
 
Posts: 30
Default Auto Label Y Axis Values

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.