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  

Styles for chart



 
 
Thread Tools Display Modes
  #1  
Old September 19th, 2003, 02:25 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Styles for chart

You could create a user-defined Custom Chart Type, and make it the
default chart, or you can record a macro that formats the completed
chart exactly the way you'd like it.

To create a custom chart type:

1. Select a chart that's formatted the way you'd like other charts
to look. Note that any Titles in the chart will be included in
the format (including the Title text).
2. From the Chart menu, choose Chart Type
3. Click on the tab - Custom Types.
4. At the bottom left, select User Defined.
5. Click the Add button.
6. Type a name for your new chart style, and (optional) a description.
7. Click OK
8. To make this the default chart type, click the Set as default chart
button, click Yes to confirm the change when prompted.
9. Click OK.

To create a chart based on a your new style:
If you made the chart the default style, you can select the data and
labels, then press the F11 key to create a new chart in that style.
OR
1. Select the data and labels for the chart.
2. Click the Chart Wizard button on the toolbar.
3. Click the Custom Types tab, and select User Defined.
4. Select your chart type, then click Next.
5. Continue through the wizard, then click Finish.



gomirage wrote:
Hello every one,
I am wondering if it is possible to create style for chats.
For example i want to create styles so for each chart i can apply
directly the style (say TitleStyle for titles, Axisstyle for axis,
legendstyle for legends and so forth).
Or is there another way to make charts consistents instead of doing it
manually.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #2  
Old October 3rd, 2003, 12:27 PM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default Styles for chart

Start with a chart with required format
Right click on chart, open Chart Type
Locate "...Default.." (working from memory so cannot recall exact words.)
and check box
Open the Custom tab, check User Defined and make your chart a user defined
one. Give it a name - MyChart
Ready for new chart.
Slect data sereis, in step 1 open Custom tab, check user defined, click on
MyChart

Bernard
gomirage" wrote in message
...
Hello every one,
I am wondering if it is possible to create style for chats.
For example i want to create styles so for each chart i can apply
directly the style (say TitleStyle for titles, Axisstyle for axis,
legendstyle for legends and so forth).
Or is there another way to make charts consistents instead of doing it
manually.

Thank you in advance for the support



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.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


All times are GMT +1. The time now is 11:59 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.