Re: Formatting Axes

Ian -

You need a macro, or a person who's not easily bored, to set axis scale
parameters based on worksheet calculations. A simple macro to apply
cell values to axis parameters is given in this archived article:

http://www.google.com/groups?selm=%...6%40tkmsftngp11

Instead of A1 and A2, link to the cells that have your formulas.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ian Belcher wrote:
> Hi,
> I'm trying to format a chart based on calculations on
> another sheet. Is it possible to set the
> miniminum/maximimum limits of an axis based on figures
> from another sheet without using a macro?
>
> Thanks for your help,
>
> Ian
>