A
ash
Hi,
I am automating MSGraph charts in PowerPoint 2007 and am getting an error
getting the X axis ticklabels (in order to format them), but only if the
series plotted on Y2 is a different chart type to Y1. The exact error is
"unable to get the TickLabels property of the axis class", and this only
occurs whilst getting a ref to the x axis ticklabels.
For example, if Y1 and Y2 both have one series each plotted as lines, the X
axis ticklabels reference is OK. However, if Y1 is a line and Y2 is a
column, I get the error. But if both Y1 and Y2 are columns, everything is
once again fine. Interestingly, if Y1 is a column but Y2 is a line, it does
work.
The code works absolutely fine in Office 2003, it is just in PowerPoint 2007
that I have the error.
Stumped.
I am automating MSGraph charts in PowerPoint 2007 and am getting an error
getting the X axis ticklabels (in order to format them), but only if the
series plotted on Y2 is a different chart type to Y1. The exact error is
"unable to get the TickLabels property of the axis class", and this only
occurs whilst getting a ref to the x axis ticklabels.
For example, if Y1 and Y2 both have one series each plotted as lines, the X
axis ticklabels reference is OK. However, if Y1 is a line and Y2 is a
column, I get the error. But if both Y1 and Y2 are columns, everything is
once again fine. Interestingly, if Y1 is a column but Y2 is a line, it does
work.
The code works absolutely fine in Office 2003, it is just in PowerPoint 2007
that I have the error.
Stumped.