Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Charts
Hi Is there a way to format a chart autommatically? I have a sheet with 10 charts and I want to aplly each one the same format as in chart 1. Thank you Paulo Guerra -- pmguerra ------------------------------------------------------------------------ pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986 View this thread: http://www.excelforum.com/showthread...hreadid=391870 |
#2
|
|||
|
|||
At the end of his Chart Types article:
http://pubs.logicalexpressions.com/P...cle.asp?ID=299 Jon Peltier discusses Custom Chart types, and copying formats from charts. Another option is to record a macro as you format the first chart, then select each of the remaining charts, and run the macro. pmguerra wrote: Hi Is there a way to format a chart autommatically? I have a sheet with 10 charts and I want to aplly each one the same format as in chart 1. Thank you Paulo Guerra -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting in Charts? | Charts and Charting in Excel | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) |