Brian -

We went through this shortly after Office 2007 went RTM. There are apparent
properties and objects in the OM, and apparent help topics, but nothing
actually gets executed in VBA. There seems to be a gap in the hierarchy, and
the chart properties are the red-headed stepchildren in all of this.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
...
Jon, You might want to check in with Steve R and Shyam on this. We can
all help each other here I am sure. See you in another NG. And maybe
you might want to show up on our monthly conf. call. Next one is Feb
13 at 1 pm EST.
Brian Reilly, MVP

On Thu, 10 Jan 2008 15:32:09 -0500, "Jon Peltier"
wrote:


Good use of color is obviously key to good visualization, and Excel 2007
uses color way better than Excel 2003. You said I could "change the
palette." Never mind that selecting colors is a skill I don't have: in
2003
I would have to, and in 2007 I don't -- so that's an improvement.

You're correct. The themes are an improvement over the earlier palettes.
So
far I've found that the themes are harder to automate, but I may get
better
as I gain understanding of the underlying methodologies. Too bad the
documentation is so vague.

"Office-wide charts." You said in 3 words what took me 30. :-)
Another
big improvement.

The lack of programmability of these objects in other applications makes
this a big step backward. If you don't care about programmability, then it
doesn't matter to you. I do care about programmability.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______