Format Axes VBA

[hanif]

Hi All,

I have created a chart on a userform with VBA and formatted using following code

Please Login or Register  to view this content.

As you can see in the last line I formatted the Y-axis values by thousands smaller. there is a word 'Thousands' appears on top of my Y-Axis which I want to get rid of. Do you know what code should I use to remove that. Is there something like .Axes.DisplayUnote.Title = False or something like that?

P.S. How can I change the style of the graph to a fancier style or change the background color?

Any help much appreciated.

Thanks,

[Andy Pope]

Please Login or Register  to view this content.

Have you tried using the macro recorder to help get some the syntax when doing fancier things?

Background colour could relate to chartarea or plotarea. So something along the lines of

Please Login or Register  to view this content.

[Olly]

Change your code to:

Please Login or Register  to view this content.

See additional line in red (and I've added a couple of With...End With groups for dealing with each axis more efficiently.

What do you mean by "fancier style"? Maybe attach an example of what you have, and what you would like?

[hanif]

Thank you both. Both ways work! Cheers