2007 formating for charts

**JimmyA** · 03-17-2009, 07:07 PM

Hi There.

I am trying to find out how to change the formatting on the new 2007 charts. I am not too good with VBA but have figured out how to select the data series, I just can't work out how to change the properties.

I have tried recording a macro to copy some of the code, however, it only records me selecting the series but doesn't do anything else.

I am interested in the "bevel" and "shadow" properties. If anyone can point me in the right direction that would be great.

Thanks in advance.

Jim

**Andy Pope** · 03-18-2009, 08:19 AM

The code would be

Please Login or Register  to view this content.

Although I would advise against adding fancy formatting to a chart without very good reason.

**JimmyA** · 03-18-2009, 01:42 PM

Thanks very much for your reply this looks like just what I need.

Is this just something you happen to know or do you use some sort of reference? I just found this really difficult to find any information on.

I would normally agree with you about the fancy formatting but the charts are being placed into a document that should not look like the graphs and charts have come from Excel.

Thanks again.

Jim

**Andy Pope** · 03-19-2009, 05:23 AM

I use intellisense and object browser.

Discovery of new chart/shape methods and properties is not easy due to poor documentation and incomplete object model.