set default axis values

[brian thompson3001 via OfficeKB.com]

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

[Kelly O'Day]

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

[email protected]



"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

[brian thompson3001 via OfficeKB.com]

thanks it works !

Kelly O'Day wrote:
>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
>
>[email protected]
>
>> have set default after formatting chart through chart / chart types/set as
>> default setting
>[quoted text clipped - 10 lines]
>>
>> brian

--
bnt

Message posted via http://www.officekb.com

[Kelly O'Day]

Appreciate the reply. It's good to know that response was received and that
it worked.


"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5d33662a0e583@uwe...
> thanks it works !
>
> Kelly O'Day wrote:
>>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
>>
>>[email protected]
>>
>>> have set default after formatting chart through chart / chart types/set
>>> as
>>> default setting
>>[quoted text clipped - 10 lines]
>>>
>>> brian
>
> --
> bnt
>
> Message posted via http://www.officekb.com

[Kelly O'Day]

Appreciate the reply. It's good to know that response was received and that
it worked.


"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5d33662a0e583@uwe...
> thanks it works !
>
> Kelly O'Day wrote:
>>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
>>
>>[email protected]
>>
>>> have set default after formatting chart through chart / chart types/set
>>> as
>>> default setting
>>[quoted text clipped - 10 lines]
>>>
>>> brian
>
> --
> bnt
>
> Message posted via http://www.officekb.com

[Kelly O'Day]

Appreciate the reply. It's good to know that response was received and that
it worked.


"brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
news:5d33662a0e583@uwe...
> thanks it works !
>
> Kelly O'Day wrote:
>>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
>>
>>[email protected]
>>
>>> have set default after formatting chart through chart / chart types/set
>>> as
>>> default setting
>>[quoted text clipped - 10 lines]
>>>
>>> brian
>
> --
> bnt
>
> Message posted via http://www.officekb.com