Delete Second Y Axis Via COde

[sunilpadikar77]

Hello,

i Want to delete Second Y Axis from my report template via code. Because for one report i need 2 y axis. for other report i need only one axis, so i want to delete the second axis.

i tried GraphObjDelete Command it did not work.

Please help.

Thanks

Sunil Padikar M

[Walter_Rick · Accepted solution]

Hi

Here is the script code:

Dim o2DAxisYList
Set o2DAxisYList = Report.Sheets("Page 1").Objects("2DAxis1").YAxisList
msgbox o2DAxisYList.Count
if o2DAxisYList.Count > 1 then
  o2DAxisYList.Remove(2)
end if
msgbox o2DAxisYList.Count

Greetings

Walter

[sunilpadikar77]

Hello Walter ,

Thanks for your reply. It solved my problem. 🙂