Jon Peltier has instructions on his web site:

http://www.peltiertech.com/Excel/Cha....html#OHLCplus

Bert wrote:
Hello,

I've this columns:
-Date
-Open
-High
-Low
-Close
-Avg14

Now I'm lookin for creatin a chart that:
* uses the Date-field on the X-axis (no problem)
* Creates a candle-graph based on the fields Open, High, Low, Close (also no
problem)
* AND: shows as line-graph based on the field Avg14

The last one is the problem. Does anyone have an idea?

tia,
Bert







--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html