Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simultaneously Formatting Charts
In Excel 2002 is it possible to format more than one chart at a time or do
they have to each be formatted individually? Is it possible to format one chart and apply the formatting to other existing charts? I have a series of charts that need the same formatting and I'm looking for a ay to only do it once and thus save a lot of time. Thanks! |
#2
|
|||
|
|||
You can format one chart
Select that chart, and copy it Select another chart, anc choose EditPaste Special Select Formats, click OK Select another chart, and press the F4 key, to repeat the previous action. Artsy wrote: In Excel 2002 is it possible to format more than one chart at a time or do they have to each be formatted individually? Is it possible to format one chart and apply the formatting to other existing charts? I have a series of charts that need the same formatting and I'm looking for a ay to only do it once and thus save a lot of time. Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Keep in mind that Excel includes the text of the chart and axis titles in the
formatting. When you paste formatting, the target chart's titles are overwritten by the source chart's. Aggravating, but I've learned to paste formats first, and write the titles later. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Debra Dalgleish wrote: You can format one chart Select that chart, and copy it Select another chart, anc choose EditPaste Special Select Formats, click OK Select another chart, and press the F4 key, to repeat the previous action. Artsy wrote: In Excel 2002 is it possible to format more than one chart at a time or do they have to each be formatted individually? Is it possible to format one chart and apply the formatting to other existing charts? I have a series of charts that need the same formatting and I'm looking for a ay to only do it once and thus save a lot of time. Thanks! |
#4
|
|||
|
|||
Personally, I'd record a macro while formatting the first chart. Then,
select each subsequent chart and run the macro. That way you work around undesired changes to elements that XL considers part of a chart's format but most normal people would not. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... In Excel 2002 is it possible to format more than one chart at a time or do they have to each be formatted individually? Is it possible to format one chart and apply the formatting to other existing charts? I have a series of charts that need the same formatting and I'm looking for a ay to only do it once and thus save a lot of time. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Conditional formatting in Charts? | Charts and Charting in Excel | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |