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