link chart axis scale to spreadsheet cell value

Hello,

I have a simple column chart. I would like to be able to set the maximum &
minimum values of the horizontal axis according to numeric values in 2 of
the spreadsheet cells. I cant see a way of doing this.

Is there a trick ?

Thanks

KK

Hi,

There is no trick. It required VBA code to do it.
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KRK" wrote in message
...
Hello,

I have a simple column chart. I would like to be able to set the maximum &
minimum values of the horizontal axis according to numeric values in 2 of
the spreadsheet cells. I cant see a way of doing this.

Is there a trick ?

Thanks

KK