Help required to draw XlLine chart in excel

[drguruji]

Hi Experts,


I need your help to draw xline chart in Excel.I am not proffessional expert eiether in excel or Vb .I am a doctor(told you to understand my knowledge on these VB or Excel)


I want to draw Xline chart with


X-axis having dates


Other 2 variables are Nifty closing price (which is in range of 7900 to 9000)


Volatality which is in range of (10-50)


When I try that with simple charts only one will be plotted.
Then I came to know that through VB it is possible.


SO dear experts please help me by writing source code for the same & how to instal that.
Thank you so much for your guidance in advance.

 

[oldbrewer]

you need a custom chart with two y axes

jon peltier website or barbara dalgleish website are really helpful

 

[drguruji]

It is possible with VB as I have some VB code. Bt problem it is mixure of other calculations, SO I dont know where the chart code starts

you need a custom chart with two y axes

jon peltier website or barbara dalgleish website are really helpful

 

[oldbrewer]

date	cloprice	vol
01/04/2015	333	7
02/04/2015	337	11
03/04/2015	341	14
04/04/2015	355	12
05/04/2015	342	6
06/04/2015	342	5
07/04/2015	340	7
08/04/2015	345	10
09/04/2015	347	8
10/04/2015	348	8
	I highlighted this data
	clicked on chart icon
	clicked on custom charts
	selected lines on 2 axes
	got a perfect chart

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>