Adding sine curve in the OHLC Chart.

[Sekars]

Hello Friends

Please refer the attached excel 2010 file (insert sin curve in OHLC.xlsx).

I need to add the sin curve from -1 to +1 for Column G in the below chart.

Any suggestions invited.

thanks in advance.

[ben_hensel]

Add the sine curve as a Secondary Axis.

You're probably going to have to rebuild the stock chart as a stacked bar chart (probably with your risers using error bars) so you can put the Sine Curve as an XY chart with the smoothed line option.