Excel chart

[rishi_375]

Hi,
I want to set X axis labels using programmticaly. I attach here file.
when u select chart and right click on that and select source data option. It will show source data window. In the Series tab it will shown Category X-axis labels. There i want put range like B2:B10.
I write following code

dim objChart as object
Set objChart = objWorkSheet.ChartObjects.Add(50, 20, 500, 300).Chart

objChart.SeriesCollection.Add Source:=objWorkSheet.Range("E1:E10")
objChart.SeriesCollection.Add Source:=objWorkSheet.Range("F1:F10")

now i want to set X axis lable but i'm not success.


If anyone know please help me.

Thanx.