As Andy and I have said, it's in the Object Browser and in IntelliSense.
Make a dummy chart with some dummy series, and just keep poking around.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"TroyLee" wrote in message
...


"Jon Peltier" wrote:

It's not clear? Can't you speak Microsoftese?

This bothered me a great deal while I tried for months to make sense of
the
new model for formatting. Here is what you need to keep in mind:

Format is read-only. Format contains objects which are not read-only.

Andy has had the patience to do a lot of experimentation with the new
object
model, using dummy charts and the Object Browser in the VB Editor. He
probably has tried to rely on the help files, but they are pretty
unhelpful,
even by Microsoft's standards.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"TroyLee" wrote in message
...


activechart.SeriesCollection(1).format.line.weight =3

Cheers
Andy


Ok Andy. Now I'm really confused. I looked at the SeriesCollections and
the
Series object. Only under the Series object does Format appear and it
says
that it is Read only. Additionally, there are no properties associated
with
the Format property according to the MSDN site. So, while the above may
work
(as I'll find it out in a moment), how is that you knew the syntax
especially
considering the macro recorder does not write this code?

Thanks for the immediate help.

TL


Jon,
Thanks for the insight. Where can one find these hidden, mystical
properties
if not in the Language Reference Manual? Does your website cover the
properties/objects of the Format property?

Thanks.

Troy