reset charting default format within a workbook
I am currently developing 3-4 workbooks and each has between 10-15
worksheets. Each worksheet has 2-3 charts representing the data. Each time I start a new chart I have to reformat it that means 20-30 reformating per workbook. Very tedious! I cannot find anything were by I can replicate the formating from one chart to the other. any suggestions? |
reset charting default format within a workbook
compliance data wrote: I am currently developing 3-4 workbooks and each has between 10-15 worksheets. Each worksheet has 2-3 charts representing the data. Each time I start a new chart I have to reformat it that means 20-30 reformating per workbook. Very tedious! I cannot find anything were by I can replicate the formating from one chart to the other. any suggestions? Create your first chart as usual, then save the chart as a custom type by clicking: Chart-Chart Type-Custom Types (Tab)-User Defined-Add Give the new type a name and description and click OK-OK. For the next chart: Insert-Chart-Custom Types-User Defined-[Select the type you previously named]-Next Select Series or Data Range to define the new data location and finish the rest of the wizard to change titles and labels, etc. |
reset charting default format within a workbook
Select a formatted chart you like then ChartChart TypeUser Defined.
Your selected Chart will be shown. Click Add and make this the default Chart. It will be saved into a file named XLUSRGAL.xls and be the default for all new charts. Gord Dibben MS Excel MVP On Mon, 18 Dec 2006 07:33:00 -0800, compliance data wrote: I am currently developing 3-4 workbooks and each has between 10-15 worksheets. Each worksheet has 2-3 charts representing the data. Each time I start a new chart I have to reformat it that means 20-30 reformating per workbook. Very tedious! I cannot find anything were by I can replicate the formating from one chart to the other. any suggestions? |
All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com