ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   set default axis values (https://www.excelbanter.com/charts-charting-excel/76952-set-default-axis-values.html)

brian thompson3001 via OfficeKB.com

set default axis values
 
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

set default axis values
 
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



brian thompson3001 via OfficeKB.com

set default axis values
 
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



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

set default axis values
 
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



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





All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com