COPY FORMATTING FROM ONE CHART TO ANOTHER

With Excel's Chart Wizard, your users can quickly create a chart or graph. But if they don't like the default formatting used by the wizard, you can show them how to add their own design touches manually.

Some Excel users spend five or 10 minutes formatting a chart until it's "just right," and then they spend five or 10 more minutes applying the same formatting options to another chart.

Fortunately, there's an easier way: Copy the attributes from one chart to another. When you click a chart, you'll notice that the Standard toolbar's Format Painter tool is grayed out and unavailable. But you can still copy the chart's formatting.

Follow these steps:

1. Click the chart you formatted once to select it. (Be sure to select

the entire chart--not the individual chart components.)

2. Press [Ctrl]C or go to Edit | Copy.

3. Select the chart that you want to format.

4. Go to Edit | Paste Special.

5. Select the Formats option and click OK.