For a ready-made solution see AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--=20
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
=3D Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,=20
says...
I have a chart on a worksheet and want to make the Y scale maximum value=
=20
equal the value of cell Y3 (this is a merged cell range Y3:Y5), rounded u=
p to=20
the next =E2=A4=BD5=E2=A4=9D increment. For example, 101% in merged cell=
Y5 would be 105% in=20
the chart Y scale maximum. How would I do this?
=20