To copy a chart’s formatting in Excel for Microsoft 365 on Windows, select the source chart and press Ctrl+C, select the destination chart, then choose Home > Paste > Paste Special > Formats. This copies the visual formatting without replacing the destination chart’s underlying data; for a quick alternative, use Home > Format Painter.
Copy formatting with Paste Special
Paste Special is useful when you want to keep the destination chart and its data but give it the source chart’s appearance. First, make sure you select the chart object itself, not a cell in the worksheet or only one data point.
- Click the outer edge of the source chart so the whole chart is selected. You should see a border and handles around the chart.
- Press Ctrl+C.
- Click the outer edge of the destination chart to select that chart.
- On the ribbon, choose Home > Paste > Paste Special. In the dialog, choose Formats and confirm.
The destination chart should retain its own plotted data while taking on formatting from the source. If the Paste Special command is unavailable, confirm that the source chart was copied and the destination chart object is selected. You can also use Format Painter, described below.
For example, suppose one chart shows monthly revenue as blue columns with a gray plot area, and another shows monthly expenses as orange columns. Copying formats can make the expense chart use the source chart’s visual styling, while the expense values and category labels remain its own. Check the result, particularly the series colors, because a style that works for one chart may not communicate the other chart’s meaning as clearly.
What chart formatting includes
A chart’s appearance is built from separate elements. Depending on the chart and the formatting applied, copied formatting can affect such things as the chart area, plot area, border, fill, text, gridlines, legend, data labels, axes, and individual data series. A chart’s selected element matters: formatting the whole chart is not the same as formatting only its title or one series.
Excel also distinguishes a chart’s appearance from its data and structure. The source chart’s cell range and plotted values are not the goal of a formats-only paste; the destination is meant to keep its own data. The chart type, axis setup, and series organization are also separate considerations. Do not assume that matching the appearance makes two charts equivalent or appropriate for the same comparison.
For the most consistent result, select the whole source chart before copying, then select the whole destination chart before pasting. If you select an axis title or data series instead, Excel may apply formatting to that selected element rather than to the chart as a whole.
Use Format Painter for a quick copy
Format Painter is convenient when you want to apply formatting once and do not need Paste Special’s options. Select the source chart, go to Home > Format Painter, and then click the destination chart. If the pointer changes to a paintbrush, click the chart object you want to format.
Format Painter works best for a straightforward chart-to-chart transfer. If it changes only part of the destination or the result is not what you expect, undo the change with Ctrl+Z and try Paste Special instead. Avoid double-clicking a chart element before using the painter: that can leave an individual title, axis, or series selected instead of the entire chart.
Format Painter is also useful for copying the appearance of a chart element, rather than the whole chart. For instance, you can select a title and use the painter on another title. Be deliberate about selecting the same kind of element in both charts, since applying title formatting to an axis label may produce an unexpected result.
Save a chart template for repeated use
If several charts need the same design, save the formatted chart as a chart template rather than repeating the copy-and-paste process. Right-click the chart that has the desired appearance and choose Save as Template. Excel saves a chart template that you can apply to other charts.
To apply a saved template, select the destination chart and choose Chart Design > Change Chart Type. In the dialog, open All Charts and select Templates, then choose the template you saved. A template is helpful for a report that gets refreshed regularly or for a workbook with many similarly designed charts.
Templates are not simply a shortcut for copying colors. They can include chart-type and layout choices as well as visual formatting. Before applying one, consider whether its chart type suits the destination data. For example, a line-chart template may not be suitable for a chart whose categories should be compared as columns. Review the result and adjust elements such as the axis scale, labels, and legend as needed.
Choose the method that fits the task
Use the method that matches how often you need to repeat the change and how much control you want:
- Paste Special > Formats: A good choice for transferring the appearance from one existing chart to another while keeping the destination chart’s data.
- Format Painter: A fast choice for a one-off transfer, or for applying formatting to a selected chart element.
- Chart template: The practical choice when you want to reuse a design across multiple charts or workbooks.
- Manual formatting: Best when the charts have different purposes and should share only selected details, such as font, border, or title style.
For example, a sales chart and a profit-margin chart might both belong in the same report, but identical axis formatting may be misleading because the units and scales differ. You could copy the font and chart-area colors, then set each vertical axis and data label format separately.
Why the result may look different
Copying formatting does not guarantee a pixel-for-pixel match. Charts can have different numbers of series, different category labels, different values, or different chart types. Excel may therefore display a copied style differently in the destination. A color assigned to one series, for example, may appear on a different series if the charts organize their data differently.
Some visual choices also depend on chart-specific settings rather than a general style. A date axis, a secondary axis, data labels, or a trendline can behave differently from the corresponding element in another chart. A copied font or border may transfer cleanly, while the placement or usefulness of labels still depends on the destination chart’s data.
After copying, inspect the chart rather than assuming it is finished. Check the title, legend, axis labels, number formats, series colors, and any data labels. If the charts are intended to be compared, also confirm that their units and axis scales make the comparison fair. Matching appearances alone do not make different scales comparable.
Common problems and fixes
- Paste Special is disabled: Re-copy the source chart, then select the destination chart’s outside border. If you selected a cell or text inside the chart instead, the chart-level paste option may not be available.
- Only one part changes: Undo, then select the whole source and destination chart objects. If you intended to copy just the title or axis style, select that same element in both charts instead.
- Series colors seem misplaced: The charts may have different series orders or counts. Set the important series colors manually and make sure the legend still identifies them correctly.
- The destination looks crowded: The source may have labels or a legend that do not fit the destination’s data. Remove or reposition those elements rather than forcing the source layout to fit.
- The chart type changed after using a template: Templates can include chart-type choices. Apply a suitable template, or change the destination back to the desired type with Chart Design > Change Chart Type.
Undo is useful immediately after a mistaken paste or paint operation: press Ctrl+Z on Windows. It is usually quicker and safer than trying to repair multiple unintended formatting changes one by one.
Windows, Mac, and Excel for the web
These steps describe Excel for Microsoft 365 on Windows. On a Mac, use Command+C to copy instead of Ctrl+C; the ribbon’s Home, Paste Special, and Format Painter options may be arranged or labeled somewhat differently depending on the Excel build. Look for the same Paste Special choice for formats, or use Format Painter if the chart-specific paste option is not offered.
Excel for the web can have a more limited set of chart-editing and paste options than the desktop app, and available commands can depend on the current release. If you cannot find chart Paste Special or chart-template controls in the browser, open the workbook in the Excel desktop app to use the Windows or Mac steps above. Do not use Ctrl+Shift+C or Ctrl+Shift+V as if they were Excel’s standard chart-format copy and paste commands; use the ribbon commands or the regular copy shortcut instead.
Frequently Asked Questions
Can I copy a chart’s format without copying its data?
Yes. Select the source chart, copy it, select the destination chart, and use Paste Special > Formats. This is intended to transfer formatting rather than replace the destination’s data range.
Does Format Painter copy the chart type?
Format Painter is for formatting, not for choosing a different chart type. To change the type, select the chart and use Chart Design > Change Chart Type. A chart template can include chart-type choices, so check the type after applying one.
Can I copy formatting between different chart types?
You can try Paste Special or Format Painter, but the result may not be identical or suitable. A line chart and a column chart use some elements differently, and axes, labels, or series colors may need manual adjustment.
How do I apply the same chart style to several charts?
For repeated use, save the formatted chart with Save as Template, then apply it through Chart Design > Change Chart Type > All Charts > Templates. Check each destination because its data and chart type may require adjustments.
Why did the chart colors change in an unexpected way?
The source and destination may have different series counts or orders, so a copied series style can map differently. Confirm which data series each color represents, then set essential series colors manually if needed.
Related
- Combine Excel Files into One: Methods and Best Practices
- How to Combine Excel Files: Methods and Common Issues
- Combine Multiple XML Files Into One Excel Workbook
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- ALS DPS Chart in Google Sheets: How to Find or Build OneIf “ALS” means Anime Last Stand, you can use a Google Sheets DPS chart to compare units, but…
- Excel Pivot Table Not Showing All Data? Causes and FixesIf an Excel PivotTable is missing data, first check that its source range includes every record, then refresh…
- Excel Waterfall Chart: How to Set the Last Bar as a TotalTo make the last bar in an Excel waterfall chart show the final total, right-click that bar and…
- Excel Not Generating Charts? Fix the Common CausesIf Excel is not generating a chart, first select a clean range that includes the labels and values,…
- Excel Pivot Table Weighted Average: Methods That WorkExcel PivotTables do not have a built-in Weighted Average summary option. The dependable approach is to add a…
- Excel Radar Chart Radial Lines: Show, Hide, and FormatIn an Excel radar chart, the lines radiating from the center are category-axis lines, often called spokes; the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.