A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

set default axis values



 
 
Thread Tools Display Modes
  #1  
Old March 13th, 2006, 03:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old March 13th, 2006, 04:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old March 13th, 2006, 04:35 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old March 13th, 2006, 04:48 PM posted to microsoft.public.excel.charting
external usenet poster
 
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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Default values from one table, entered values in another laser02910 Using Forms 2 June 21st, 2005 10:01 PM
Chart X axis values are wrong! Sorin Setting Up & Running Reports 0 December 17th, 2004 10:05 PM
catergory on the X axis; values on the Y axis 100green Charts and Charting 1 December 15th, 2004 07:06 PM
Non-Numeric values in X axis of a scatter chart penasm General Discussion 1 October 28th, 2004 05:44 PM
Default placement for data values in Charts Ellen Powerpoint 2 July 14th, 2004 03:56 PM


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


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