Excel 2007 VBA Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I record macros with VBA, I do not get information for formatting on
charts. Is there an update to fix this?

If not, is there a simple reference to the properties for the
seriescollection(index) that you can use to change the formats? I have found
some of the properties, including the .border.linestyle and .border.weight,
but I cannot find all the options available in the UI.

Any help is much appreciated!
 
You can try this approach:

Sub test()
Dim sC As Series
Set sC = ActiveChart.SeriesCollection(1)
Stop
End Sub

When the stop halts activity, display the locals window (View, Locals
Window) and expand the sC variable to see properties. Some will setable and
some will not.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Thanks! I've got a whole bunch of properties to play with now. That was a
lot better than trying to use the F1 help, which doesn't seem to be indexed
as well as it used to be.
 
Back
Top