Chart Min/Max from cells

Hi,
I have a simple formula to calculate the min/max scale on our control
charts. I tried to link the cells with the min/max values to the Min/max
areas on the "Format Axis" form.
It didn't work with a "=" sign or a direct link.
Can I link these values to my cells values on the worksheet?
Thanks, Jim

Hi Jim,

Try Tushar's AutoChart Addin if you require a dynamic link.
(http://www.tushar-mehta.com/)


Jim Edwards wrote:

> Hi,
> I have a simple formula to calculate the min/max scale on our control
> charts. I tried to link the cells with the min/max values to the Min/max
> areas on the "Format Axis" form.
> It didn't work with a "=" sign or a direct link.
> Can I link these values to my cells values on the worksheet?
> Thanks, Jim
>
>

--

Cheers
Andy

http://www.andypope.info

Thanks for the idea Andy,.
The charts are on an at work networked system and I don't think it will
allow an xla file to load on the network. I guess it's not as easy as I had
hoped.
Jim
"Andy Pope" <andy@andypope.info> wrote in message
news:ON9GLdEsDHA.2392@TK2MSFTNGP10.phx.gbl...
> Hi Jim,
>
> Try Tushar's AutoChart Addin if you require a dynamic link.
> (http://www.tushar-mehta.com/)
>
>
> Jim Edwards wrote:
>
> > Hi,
> > I have a simple formula to calculate the min/max scale on our control
> > charts. I tried to link the cells with the min/max values to the
Min/max
> > areas on the "Format Axis" form.
> > It didn't work with a "=" sign or a direct link.
> > Can I link these values to my cells values on the worksheet?
> > Thanks, Jim
> >
> >
>
> --
>
> Cheers
> Andy
>
> http://www.andypope.info
>