Linking axes scale values to cells

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
 

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

Similar Threads

Vertical line in stock chart 1
Matching the min & max values for Primary and Secondary axes 2
Help with forcing chart axes scale 1
Change Axes Scale Dynamically 3
Avoid plotting unwanted values 3
Link chart axes' scale values to cells 3
How to dynamically set the lower and upper limits of the axes scaleson a MS Access xy-chart 3
XY Chart Improvements For Scientific Data 3

Top