I can make a presentation in minutes if only i could keep formatting on my
charts and graphs. As it is, it takes me about 4 hours because i have to
change fonts, colors, bars, etc...

In Excel help there is a topic entitled:
"Create, share, or delete your own chart types"

Does that help?
--
David Biddulph

"jalooney" wrote in message
...
I can make a presentation in minutes if only i could keep formatting on my
charts and graphs. As it is, it takes me about 4 hours because i have to
change fonts, colors, bars, etc...

In EXCEL 2007:-

- click on graph to highlight it

- Chart Tools becomes available in Title Bar

- select Design

- then choose from Chart Styles

Takes about 2 minutes.

If my comments have helped please hit Yes.

"jalooney" wrote:

I can make a presentation in minutes if only i could keep formatting on my
charts and graphs. As it is, it takes me about 4 hours because i have to
change fonts, colors, bars, etc...

Maybe what you want to do is to save a chart template

- click on graph to highlight it

- Chart Tools becomes available in Title Bar

- select Design

- then choose from "save as a template"

Then when you have another chart, choose Change Chart type
and templates




*- click on graph to highlight it

*- Chart Tools becomes available in Title Bar

*- select Design

*- then choose from Chart Styles

Takes about 2 minutes.

If my comments have helped please hit Yes.

"jalooney" wrote:
I can make a presentation in minutes if only i could keep formatting on my
charts and graphs. *As it is, it takes me about 4 hours because i have to
change fonts, colors, bars, etc...