You are close, however, you have to take a few additional steps:

Step 1 - you need to establish a user defined custom chart type before you
can set it as your default chart:
Select your formatted chart - right click - select Chart Type, go to
Custom Types, then User Defined.

Step 2 - Add your chart in the Custom chart - User defined - Add window -
give it a name

Step 3 - Now you can set your chart as the default

F11 should now generate your custom -- user defined chart





"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote in message
news:5d32f1059ac13@uwe...
have set default after formatting chart through chart / chart types/set as
default setting

Then when highlight data and press F11, format revert back to origional
setting

any ideas to amend?

I am trying to set this so as to not keep formating each chart when the
operator selects the required data

thanks

brian

--
bnt

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200603/1