Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SamD
 
Posts: n/a
Default Conditionally color candles?

I would like to be able to control the color of individual candles in my
stock charts. Is this possible?
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert text conditionally and format John Sawyer Excel Discussion (Misc queries) 3 August 17th 05 06:51 PM
Insert comments conditionally - ajit Ajit Munj Excel Discussion (Misc queries) 3 June 10th 05 02:11 PM
Conditionally Hide Rows tamato43 Excel Discussion (Misc queries) 4 May 11th 05 04:27 PM
How do I conditionally format a chart? Michelle Excel Discussion (Misc queries) 1 April 12th 05 09:59 PM
conditionally linking to different cells redb Excel Discussion (Misc queries) 2 April 11th 05 12:29 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"