N
NormanB
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
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