Basic Chart Formatting..

[s170609]

Hello,

I am trying to apply formatting to a chart selected by the user. There could be several charts on one worksheet so I only want to apply formatting to the particular chart that is active; without using specific chart numbers or names.

I'm just trying to add a black borderline around the chart, some colour fill and fix up the axis etc...

Any help would be appreciated.

Thanks in advance.

[Sindhus]

Hi,

For formatting the chart you can try the following code.

Please Login or Register  to view this content.

And for adjusting the axes, go through this link http://www.excelforum.com/excel-gene...using-vba.html

Regards,
Sindhu

[s170609]

Thanks Sindhu,

Thats just what I'm after. I was trying things like ".LineFormat" and ".Shapes" but couldn't get it to work.

Kind regards, Peter.