Is there a quick and easy way of applying a default format to a chart (axis
font size, background colour, title font size etc) other than using a macro?
If not, could anyone suggest a suitable portion of VBA code that i could
modify to suit my formatting needs?

Set up the default chart the way you like it to look.

Make sure the chart is active.

Menu Bar Chart Chart Type

Select Custom Types, click User Defined radio button, and click on
Add.

Give your Custom Chart a name that makes sense.

Click on Set as Default, and future charts will default to this
setting.

A word of caution, the chart title will fill in as you have in the
default, the axis scale minimum, maximum, major unit, etc will all be
set to what you set up in the default chart. Virtually all of the
settings will be set to your original chart.

Have several user defined charts, so you can select the one that fits
the situation and set it as the default for a given situation.

You can insert a button on the Standard (or Formatting) Toolbar that
will change an active chart to the current default chart type.

If you don't know how to do this, right-click on any toolbar and select
customize. Select Commands Charting and scroll down to find the
Default Chart icon. Drag it to your toolbar and close the customize
dialog box.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=468151