Chart Min/Max from cells

[Jim Edwards]

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

 

[Andy Pope]

Hi Jim,

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

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

 

[Jim Edwards]

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