Axis Labels

[Rishi]

Hi,
I want to set Category X axis lables range using vba
code (programmatically). and how to enable secondary Y
axis enabled and assign value to that secondary Y axis.

Please help me.

thanks.

 

[Jon Peltier]

Sub AssignDataToSeries()
With ActiveChart.SeriesCollection(1)
.Values = Worksheets("Sheet1").Range("F6:F9")
.XValues = Worksheets("Sheet1").Range("E6:E9")
.Name = Worksheets("Sheet1").Range("F5")
End With
End Sub

- Jon