On 2002-05-08 15:08, rdionne wrote:
Because they interact quite a bit with each other, and the order that you assign the attributes is also important. I tried the VBA route, but it turned out to be a frustrating experience. Too bad there isn't a utility that takes a chart and displays all of the attributes. I guess I can add two hidden worksheets containing the two custom chart types I use to my excel app., and then define the custom chart types from those:
Application.AddChartAutoFormat Chart:=ActiveChart, Name:="Test", _
Description:="Test Chart"