Linking axes scale values to cells
For almost any type of chart the auto scale functions work fine. For OHLC
stock charts however the auto scale always sets the minimum scale value to zero. If plotting a high priced stock, the chart is compressed into a small area at the top of the chart rendering it useless. If fixed values are used they must be constently reset as the stock price changes in order to avoid having the bars walk off the chart area. I can search the data with MAX(range) and MIN(range) in order to pick out the upper and lower limits dynamically. IS THERE ANY WAY TO LINK THE AXES SCALE VALUES TO THE CELLS THAT CONTAIN THE LIMITS??? I have been stumbling over this issue for a long time. Any help will be greately appreciated. Thanks. Gene D P |
Linking axes scale values to cells
Hi,
Only way is with VBA coding. http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gene" wrote in message ... For almost any type of chart the auto scale functions work fine. For OHLC stock charts however the auto scale always sets the minimum scale value to zero. If plotting a high priced stock, the chart is compressed into a small area at the top of the chart rendering it useless. If fixed values are used they must be constently reset as the stock price changes in order to avoid having the bars walk off the chart area. I can search the data with MAX(range) and MIN(range) in order to pick out the upper and lower limits dynamically. IS THERE ANY WAY TO LINK THE AXES SCALE VALUES TO THE CELLS THAT CONTAIN THE LIMITS??? I have been stumbling over this issue for a long time. Any help will be greately appreciated. Thanks. Gene D P |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com