Linking axes scale values to cells

  • Thread starter Thread starter Gene
  • Start date Start date
G

Gene

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
 
Back
Top