Dynamic Vertical axis in a chart

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top