Candle Stick Chart with Line Chart

Hello friends,

I am trying to plot a chart which is a combination of Japanese Candle Stick Chart with Line Chart...

I am attaching a data sheet which has the following columns:

Date
Open, High, Low, Close (for Candlestick chart)
High Line & Low Line (for line chart)

I know how to create Japanese Candle Stick Chart & Line Chart SEPARATELY but not as a combined chart.

Can someone help me please with steps on how I can make a single chart....

I am more optimistic than CK76 that you can create this as a single combination chart. The thing to recognize is that a candlestick chart is very similar to a box and whiskers chart which is essentially a stacked column chart in Excel, and it is relatively easy to create a stacked column + line combination chart. This tutorial (http://peltiertech.com/excel-box-and...ams-box-plots/ ) goes through the basic procedure for creating a box and whisker's + line combination chart, and should be easily adapted to your desired candlestick + line combination chart.