ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Linking axes scale values to cells (https://www.excelbanter.com/charts-charting-excel/154655-linking-axes-scale-values-cells.html)

Gene[_3_]

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


Andy Pope

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