O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Copying Formats from One Chart to Another

Most of this chapter is devoted to procedures for changing the appearance of particular chart elements. However, if you've already got one chart set up just the way you want it, you can use that chart as a model for others.

To transfer the formats of one chart to another:

  1. Select the chart area of the chart whose formats you want to copy.

  2. Choose Edit, Copy. If the Copy command is unavailable, you haven't selected the chart area of the source chart.

  3. Select the other chart.

  4. Choose Edit, Paste Special, and select the Formats option.

Note that when you copy formats from one chart to another, you copy all formatting decisions, including any scaling choices you made. If your second chart plots values in a different ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required