Cell value as chart scale maximum
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?
|