Rashmi has attended:
Excel Intermediate course
Excel Advanced course
TM AutoChart
Is there another program like TM Auto Chart where you do not have to change the data each time?
RE: TM AutoChart
Hi Rashmi
Thanks for getting in touch. I wasn't familiar with TM Auto Chart, thanks for that.
There isn't a built in way to get a value and put it into the min / max axis values. It would be possible with VBA programming. If you record a macro where you change the axis parameter, you should be able to see where you can substitute a cell reference instead of a fixed value.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector