access the axis of the graph

  • Thread starter Thread starter smith.mariya
  • Start date Start date
S

smith.mariya

hi,
i am mariya. i am working on vb.net. i have created the powerpoint
addin. i have inserted the chart on the slide through vb.net code.
now, i want to remove the gridlines on the chart and want to remove
the y axis. i am not able to get the exact object and properties of
the axis . can u plz tell me, what should i do?
the code is as,

Private oChart As Microsoft.Office.Interop.Graph.Chart
Private oaxis As Microsoft.Office.Interop.Graph.Axis

oaxis = CType(oChart.Axes(XlAxisType.xlValue, XlAxisGroup.xlPrimary),
Microsoft.Office.Interop.Graph.Axis)
oaxis.TickLabels.Orientation =
XlTickLabelOrientation.xlTickLabelOrientationUpward

on the last line i am getting the error, "unable to access the
XlTickLabel property of the axis class"
what should i do? plz tell me as soon as possible.
 
Have you tried using MacroRecord and seeing what the generated code looks
like?

Robin S.








- Show quoted text -
Click to expand...

hi,
thanks for ur reply.
but i tried with macro also. it doesnt show any related things.
i am using office 2005. and my chart object is of MSGraph.chart
is any other ref. is required?
plz tell me if u know . its urgent!!!
Thanks !!!
 
Back
Top