set default axis values

  • Thread starter Thread starter brian thompson3001 via OfficeKB.com
  • Start date Start date
B

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
 
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

(e-mail address removed)
 
thanks it works !
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

(e-mail address removed)
have set default after formatting chart through chart / chart types/set as
default setting
Click to expand...
[quoted text clipped - 10 lines]
brian
Click to expand...
Click to expand...
 
Appreciate the reply. It's good to know that response was received and that
it worked.


brian thompson3001 via OfficeKB.com said:
thanks it works !
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

(e-mail address removed)
have set default after formatting chart through chart / chart types/set
as
default setting
Click to expand...
[quoted text clipped - 10 lines]
brian
Click to expand...
Click to expand...
Click to expand...
 
Back
Top