Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
brian thompson3001 via OfficeKB.com
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.charting
brian thompson3001 via OfficeKB.com
 
Posts: n/a
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
3rd Y Axis caridgway Charts and Charting in Excel 1 December 27th 05 02:15 PM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM
How do I change x axis values in a line chart? Elizabeth Charts and Charting in Excel 1 March 29th 05 11:05 AM
How do I eliminate duplicate values on y axis of an Excel chart? Paul Charts and Charting in Excel 1 March 24th 05 04:26 AM


All times are GMT +1. The time now is 03:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"