change the excel chart Axes TickLabels font size

J

Jane

I am running the excel automation from client side code. Openning excel and
adding chart. Everything works fine.
When I try to change the ticklalels font size using client side script, I
get error message like:
Unable to get the Axes property of the chart class.

my code like:
wb.ActiveChart.Axes(0).TickLabels.Font.size = 8

I can change the lengend font without any problem.
wb.ActiveChart.Legend.Font.size = 8


Is my code wrong or the property accessing through the script has
limitation? Is there any side I can reference to see which propery are
supported by vbscript.

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
VBA to set the font size for the axes of a bar chart 1
Chart label alignment 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Align x axis labels at 45 degrees using vba, please help! 0
Changing the setting of X,Y axes 0
Manipulating embedded excel charts in Word 0
Manipulating embedded excel charts in Word 0

Top