Chart Min/Max from cells

  • Thread starter Thread starter Jim Edwards
  • Start date Start date
J

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
 
Hi Jim,

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


Jim said:
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
Click to expand...

--

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
 
Back
Top