Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart - Missing Text on Vertical Axis | Excel Discussion (Misc queries) | |||
Column Chart with multiple vertical axis | Charts and Charting in Excel | |||
make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
Add vertical lines to a line chart (already has 2 Y axis) | Charts and Charting in Excel | |||
Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) |