Excel Charts axis min, max values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

research - 31 Aug 2006 21:10 GMT

How can I set the X and Y axis minimum and maximum values by reference to
variable numbers in cells.

Signature

Excel R&D

Reply to this Message

Andy Pope - 01 Sep 2006 08:58 GMT

Hi,

You have to use VBA code to do this.

Jon Peltier has an explanation
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

And Tushar Mehta has an addin
http://tushar-mehta.com/excel/software/autochart/index.html

Cheers
Andy

> How can I set the X and Y axis minimum and maximum values by reference to
> variable numbers in cells.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message