Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Axes, same scale wanted | Charts and Charting in Excel | |||
Linking Axes Max & Mins to source chart | Charts and Charting in Excel | |||
How do I scale excel chart axes from vb? | Charts and Charting in Excel | |||
Locking gridlines to be square - axes to same scale ? | Charts and Charting in Excel | |||
Change Axes Scale Dynamically | Charts and Charting in Excel |