Dynamic Vertical axis in a chart
 

excel 2007

I am return data using microsoft query and am graphing this data.

As the ranges change I want to be able to set a vertical range for the chart
using the min and max values in the data returned. I have calculated the min
and max into 2 cells.

I can do this manully using the chart tool 'vertical (value) axis screen but
it only takes fixed values not a cell reference.

Can this be done?

Thanks for any help

Dynamic Vertical axis in a chart
 

Hi,

It will require code to update the scale parameters based on cell values.
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NormanB" wrote in message
...
excel 2007

I am return data using microsoft query and am graphing this data.

As the ranges change I want to be able to set a vertical range for the
chart
using the min and max values in the data returned. I have calculated the
min
and max into 2 cells.

I can do this manully using the chart tool 'vertical (value) axis screen
but
it only takes fixed values not a cell reference.

Can this be done?

Thanks for any help

Dynamic Vertical axis in a chart
 

Thanks for your help with this one.

The excel add-in works a treat


"Andy Pope" wrote:

Hi,

It will require code to update the scale parameters based on cell values.
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NormanB" wrote in message
...
excel 2007

I am return data using microsoft query and am graphing this data.

As the ranges change I want to be able to set a vertical range for the
chart
using the min and max values in the data returned. I have calculated the
min
and max into 2 cells.

I can do this manully using the chart tool 'vertical (value) axis screen
but
it only takes fixed values not a cell reference.

Can this be done?

Thanks for any help