Secondary axis title set up

[gwandalf]

Hi!!! I would like to know how to set the secondary axis title to my chart. But it is giving my problems. Like this is telling me that
Method ?Axes'_Chart' failed and I dont know why


ActiveSheet.ChartObjects(chartName(2)).Activate
ActiveChart.Axes(xlValue, xlSecondary).Select
ActiveChart.SetElement (msoElementSecondaryValueAxisTitleRotated)
ActiveChart.seriesCollection.NewSeries
ActiveChart.seriesCollection(1).Name = "Hv"
ActiveChart.seriesCollection(1).XValues = simNo
ActiveChart.seriesCollection(1).Values = Hvdata
ActiveChart.seriesCollection.NewSeries
ActiveChart.seriesCollection(2).Name = "Freq"
ActiveChart.seriesCollection(2).AxisGroup = 2
ActiveChart.seriesCollection(2).Values = Fdata

Thanks in advance

 

[Jon Peltier]

And the second line was highlighted? (Important information, remember to include it.)

Does the chart have a secondary value axis? It looks like it isn't added until the second to last line of code.

 

[gwandalf]

Yes, the second line was highlighted (Thanks for the advice )

The chart has a secondary vertical axis, yes. But I dont know what you meanthat I should add it before. Sorry I am a begginer in VBA. COuld you explain me how did you do that?

Thanks in advance

 

[gwandalf]

And the second line was highlighted? (Important information, remember to include it.)

Does the chart have a secondary value axis? It looks like it isn't added until the second to last line of code.

Yes, the second line was highlighted (Thanks for the advice )

The chart has a secondary vertical axis, yes. But I dont know what you meanthat I should add it before. Sorry I am a begginer in VBA. COuld you explain me how did you do that?

Thanks in advance

 

[Jon Peltier]

I mean, at that point in the code, does the chart have a secondary value axis? You can't add/format the axis title if there is no corresponding axis.

If it didn't have the secondary axis at the beginning of the code, it doesn't get one until you assign a series to the secondary axis (AxisGroup=2).

Move the code that formats this axis after the part that formats the series in the chart.