Chart axis format max min values

[me yu]

I need to be able to set the max and min values of a chart automatically so that the chart area is 1% above the max data value and 1% below the min data value.


Any help greatly appreciated.

 

[Luke M]

Check this out:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html


Method describes how to link to a cell, and you could easily write a a formula to calculate max value of your data + 1%.

 

[Hui]

Me Yu


Firstly, Welcome to the Chandoo.org forums.


In addition to using the techniques which Luke linked to above

You can also use another technique that doesn't involve VBA


Add two sets of data to each chart

The two sets will be calculated values and will be the Minimum and Maximum values for each chart based on the data for the charts

You can add +/- 1% to the data if you wish

Then add 2 series to each chart and set the series to have no line color and no markers

Make sure the Y Axis are set to Automatic Min/Max scale


You can also use this technique to set a common set of data across multiple charts

Just setup the Min/Max data to be the Min/Max of all the charts data


All done without VBA