Edit chart zoom in Excel 2003

[ChrisC]

I need help editing a macro that was created in Excel 2003 that creates a pivot table and then a chart off that pivot table. We were able to set the macro to format chart font size and style, chart background color, and a whole group of other things to our liking but anyone who uses the 2003 charts it defaults to full view (depending on your screen resolution). How can I specify the zoom size of the chart in the macro? I added the following line to the Marco to no avail:

With Selection.Border

.ColorIndex = 3

.Weight = xlMedium

.LineStyle = xlContinuous

.Zoom = 100

End With

Anyone have any thoughts?

Thanks

Chris