I always recommend starting with the recorder. Then looking at the code and
deciding what needs to be generalized. This can be pretty complex.

I would make the recording on the most complex chart I have to modify and
then work from there.

I would also recommend that you check out Jon Peltier website since he has
lots of code and examples http://PeltierTech.com.

--
Cheers,
Shane Devenshire


"Fredrik E. Nilsen" wrote:

On Sun, 17 Dec 2006 16:15:00 -0800, ShaneDevenshire
wrote:

If you want to apply these on a chart by chart basis then the real approach
is to develop code for all the changes you want - line thickness, axis,
colors and so on. Run that code from an xla just as described earlier. This
is safer than applying a user defined chart because of the problems I
mentioned. You code will require that the user select the chart and then
execute the code. As for color, if the color is from the default pallete,
you might as well include it in the macro rather than changing the pallete.
When you change the pallete you effect everything that uses it not just all
charts.

Thanks again, I really appreciate the time you take to explain it in
an understandable way. :)

Do you have any pointers regarding coding all the changes? I'm in a
bit over my head here but I have basic knowledge about VB. In "real"
english it would be something like:

On the selected chart (no matter what type of chart it is):
Change all lines to... (thickness, markings etc)
Change all columns to... (no border etc)
Set textsize to...
Set legend placement to...
Set colours to...
etc....

The colour issue is not really a problem in this particular case,
though I see your point. But: If I pull the colours from chart fill
and chart line colours in xlusrgal.xls, that won't affect the standard
colours? I see that it will affect the last 16 colours of the palettes
but thats not a problem, it's a bonus feature. :)

The users in this case are financial analysts and they make huge
reports in Word every day. They pull charts from Excel in to Word and
want to achieve consistant formatting throughout all the charts.

--
Fredrik E. Nilsen