Graph - combination candle and line

[Bert]

Hello,

I've a dataset with the following fields:
-Date (date-field)
-O (long)
-H (long)
-L (long)
-C (long)
-A14 (long)

Now I'm lookin for creatin a graph that:
* uses the Date-field on the X-axis (no problem)
* Creates a candle-graph based on the fields O, H, L, C (also no problem)
* AND: shows as line-graph based on the field A14

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

tia,
Bert

 

[Bert]

ok, this could be done by adding the range (a14) to the data-source of the
chart and then setting the style for that range

thanks to the Excel-charting-people and
http://www.peltiertech.com/Excel/Charts/StockChartPlus.html

Bert