Thread: 2007 formating for charts

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

The code would be

    Dim objSeries As Series
    
    Set objSeries = ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1)
    
    objSeries.Format.ThreeD.BevelTopType = msoBevelDivot
    objSeries.Format.ThreeD.BevelTopDepth = 10
    objSeries.Format.ThreeD.BevelTopInset = 15
    
    objSeries.Format.Shadow.Type = msoShadow1

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

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.