Hi Phil -
Use the approach I describe he
http://peltiertech.com/Excel/Charts/...nkToSheet.html
but link to CEIL(Y3,0.05) instead of Y3.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Phil Hageman wrote:
I have a chart on a worksheet and want to make the Y scale maximum value
equal the value of cell Y3 (this is a merged cell range Y3:Y5), rounded up to
the next 5 increment. For example, 101% in merged cell Y5 would be 105% in
the chart Y scale maximum. How would I do this?