ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Conditionally color candles? (https://www.excelbanter.com/charts-charting-excel/54071-conditionally-color-candles.html)

SamD

Conditionally color candles?
 
I would like to be able to control the color of individual candles in my
stock charts. Is this possible?

Jon Peltier

Conditionally color candles?
 
Aside from the plus/minus colors of a candle, you have no flexibility.
However, you could lay a floating column chart showing open/close data
over a high-low line chart showing high/low data. These columns can be
individually formatted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


SamD wrote:

I would like to be able to control the color of individual candles in my
stock charts. Is this possible?



All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com