Alan -

The problem with your hoped for approach is that the properties are not just
properties of the chart. The chart has elements, and each element has its
properties, and subelements have their properties, etc. You can't just find them
the way you can recursively read files from a directory tree, or if you can, I don't
know how.

The ones you really need to be worried about can easily enough be done individually
through code. You could also automate the process of applying a user defined chart
type, or copying a good chart and using paste special-formats on a bad chart, but
both of these replace existing chart and axis titles with whatever is in the copied
chart.

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

Alan wrote:
"Jon Peltier" wrote in message
...

I think you could get away with locking in the font size, and
defining the plot area dimensions. The plot area is good to fix
anyway, because of the excessive white space around it.

With ActiveChart.PlotArea
.Left = 10
.Top = 25
.Width = 215
.Height = 170
End With

Of course, you need to adjust these sizes for labels, chart area
size, etc.

- Jon


Okay - thanks Jon, much appreciated.

Just out of interest, would it be conceptually possible to do what I
was trying before ...) or
is that just impossible?

Thanks again,

Alan.