PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Conditionally color candles?

Reply

Conditionally color candles?

 
Thread Tools Rate Thread
Old 07-11-2005, 08:50 AM   #1
=?Utf-8?B?U2FtRA==?=
Guest
 
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?
  Reply With Quote
Old 08-11-2005, 03:42 AM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: 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 With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off