To copy a graph’s appearance in Excel for Microsoft 365 on Windows, select the source chart, choose Home > Format Painter, and click the target chart. This transfers formatting without replacing the target chart’s data. For a reusable design—especially when chart types differ—save the source as a chart template and apply it to the other chart. The steps below explain both options and what to check afterward.
What You’ll Need
- An Excel workbook with a formatted source chart and the chart you want to restyle. They can be on the same worksheet or different worksheets.
- For best results with Format Painter, use charts with the same chart type and similar chart elements, such as matching axes, titles, and legends.
- If you use the template method, Excel desktop for Windows or Mac. The steps and available options can differ in Excel for the web.
Step-by-Step
- Prepare both charts. Open the workbook and check that the source chart has the appearance you want: for example, the colors, fonts, borders, gridlines, and legend placement. Confirm that the target chart already contains the data it should display. Formatting a chart does not move or copy its underlying worksheet data. If you have not created the target yet, select its data and use Insert to create the appropriate chart first.
- Select the entire source chart. Click near the chart’s outer edge until the whole chart is selected, rather than clicking a title, data series, axis, or legend inside it. A border and sizing handles around the full chart indicate that the chart object is selected. This matters because Excel can format individual chart elements separately; selecting one element may copy only that element’s formatting.
- Start Format Painter. On the ribbon, choose Home > Clipboard > Format Painter. The pointer changes to indicate that the formatting is ready to apply. If you cannot see the Clipboard group, widen the Excel window or look for the compact ribbon controls; the command is on the Home tab.
- Apply the formatting to the target. Click the outer edge of the target chart. Excel applies the available chart formatting to it while retaining the target chart’s data. Avoid clicking a single item inside the target, such as a bar or its title, because that can select only one chart element. Click once on the chart’s frame so the whole chart is the destination.
- Review the result. Check the target’s chart area, plot area, text, axes, legend, and data series. Some elements only appear if the target contains them. For example, formatting cannot create a legend if the target has no legend, and a source’s horizontal-axis settings may not make sense for a target with different categories. Adjust any missing or unsuitable elements individually.
- Use Format Painter for more than one chart, if needed. To apply the same formatting to several charts, select the source chart and double-click Home > Format Painter. Click each target chart in turn, then press Esc to turn the painter off. If you click Format Painter only once, it normally turns off after you apply the formatting to one target.
- Save the source chart as a template for repeat use. If you expect to reuse the design, right-click the outer edge of the source chart and choose Save as Template. Enter a recognizable file name and save the template. Excel stores the chart design as a .crtx template; this is useful when you want a repeatable look rather than copying formatting just once.
- Apply the template to another chart. Select the target chart, then choose Chart Design > Change Chart Type. In the dialog, select Templates, choose the saved chart template, and select OK. Check the target after applying it: a chart template can apply chart type as well as formatting, so confirm that Excel has not changed the chart type in a way that makes the data harder to read.
- Save and compare. Save the workbook, then compare the two charts at the same zoom level. Look at the chart’s readability as well as whether its colors match. The goal is a consistent presentation, not necessarily a pixel-for-pixel match when the charts show different data or use different axes.
Mac and web note: In Excel for Mac, the Format Painter is also on the Home tab, and the chart template workflow is available through the chart design and chart-type controls, though dialog labels or layout can vary slightly by release. Excel for the web has fewer chart-formatting and template options. If you do not see the template commands or cannot get the result you need in a browser, open the workbook in the desktop Excel app.
Common Mistakes
- Selecting an element instead of the chart. Clicking a title, plot area, axis, or individual data point before using Format Painter may copy only that element’s appearance. Select the outside border of the full chart when you mean to format the chart as a whole.
- Expecting formatting to copy the data. Format Painter changes appearance; it does not replace the target’s source range, labels, or values. If the target is displaying the wrong information, edit its data separately using Chart Design > Select Data.
- Assuming every chart detail will match. A chart with two axes, a trendline, or several series may have features that do not exist in the target. Excel cannot transfer a meaningful setting for a chart component that the destination does not have. Add or edit the component on the target if it is needed.
- Applying a template without checking chart type. Templates can include chart-type settings as well as visual styling. A template made from a line chart may not be suitable for a target that needs to remain a column chart. Confirm the chart type and, if needed, choose a template based on a chart of the same type.
- Trying to format charts with very different layouts in one pass. A design optimized for a compact chart with three series might not work well on a wide chart with ten series. The colors may transfer, but labels can overlap or become difficult to distinguish. Check each target and adjust it for its own data.
Tips
- Choose the method based on your goal. Use Format Painter to quickly copy formatting to one or a few existing charts. Use a chart template when you want to keep a design for reuse or apply it repeatedly.
- Start from a clean source chart. Remove unwanted titles, adjust the legend, and set readable fonts before copying. It is easier to correct the source once than to repair the same problem on several targets.
- Use similar charts for the closest match. Copying between charts of the same type and with comparable numbers of series usually gives a more coherent result. When the chart types differ, apply only the visual ideas that suit both rather than assuming every setting will carry over.
- Keep the chart’s purpose in view. A color scheme or axis range that works for one data set might mislead or obscure another. After styling, make sure series remain distinguishable and that axis labels and data labels are still legible.
- Keep a clean original. If the source chart is your standard design, duplicate it or save a template before experimenting. A saved template is also easier to reuse later than trying to remember each font, border, and fill setting.
- Use Format Chart Area for selective changes. If the target should share only a few choices, such as a font or background color, select the relevant chart element and use the Format pane instead of applying all available chart formatting. This reduces unintended changes to axes, series, or labels.
Troubleshooting
Format Painter does nothing: Make sure the source chart itself is selected, not a worksheet cell near it. Start Format Painter again, then click the outer border of the target chart. If the target is on a different sheet, activate that sheet after starting the painter and click the chart. If the painter has switched off, select the source and repeat the process.
Only one part of the chart changes: The source or destination selection was probably an individual chart element. Press Esc, click outside the chart, then select its outer edge so handles surround the full object. Start Format Painter again and click the target’s outer edge. If you want only one component changed, such as the legend, selecting that component intentionally is appropriate.
The template is not listed: Confirm that you saved it with right-click > Save as Template and that you are opening Chart Design > Change Chart Type > Templates on the same computer and in desktop Excel. Check whether the template was saved under a different name. If you are using Excel for the web, open the file in the desktop app and look for the template controls there. Templates are files, so if you move to another computer, you may need to make the .crtx file available to that Excel installation.
The target changed to an unsuitable chart type: Applying a template may change more than colors and fonts. Select the target, open Chart Design > Change Chart Type, and choose the chart type that best represents its data. Then review the series, axes, and labels. If preserving the target’s chart type is essential, use Format Painter or manually apply the visual settings instead.
Text or labels look crowded: The target may have longer category names, more series, or a different chart size. Widen or enlarge the chart, reposition the legend, reduce unnecessary labels, or adjust font size and axis settings. Do not shrink text until it becomes difficult to read just to imitate the source exactly.
Frequently Asked Questions
Does copying a chart’s format copy its data?
No. Format Painter and chart templates are intended to transfer chart appearance and, depending on the method and template, chart settings. The target continues to use its own data unless you separately change its data source.
Can I copy a graph format without changing the target chart type?
Use Format Painter for a quick formatting transfer, then inspect the result. A chart template may also apply a chart type, so use one based on the target’s type or correct the type afterward through Chart Design > Change Chart Type.
Can I copy formatting between different workbooks?
Yes. Format Painter can be used when both workbooks are open in desktop Excel. For repeated use, save a chart template and make its .crtx file available to the other Excel installation. Check that the destination chart remains suitable for its data.
Can I copy only the colors or font?
For selective formatting, choose the relevant chart element and change its options in the Format pane. Format Painter may copy more formatting than you intend, so applying individual fill, line, or text settings is often clearer when only one detail should change.
Why does my chart look different even after copying the format?
Chart elements depend on the target’s data and layout. Different series counts, category labels, axes, or chart types can affect how formatting appears. Compare the charts and adjust the target’s labels, legend, axes, or dimensions for readability.
Related
- How to Close an Excel Sheet with a Keyboard Shortcut
- How to Close an Excel Sheet With a Keyboard Shortcut
- How to Close Editing Mode in Excel Without Losing Work
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Rename a Trendline in Excel: Steps, Labels, and FixesTo rename a trendline in Excel for Microsoft 365 on Windows, select the trendline, open its formatting pane,…
- Packed Bubble Chart in Excel: Options and AlternativesExcel for Microsoft 365 does not include a native packed bubble chart. You can make a standard bubble…
- Excel Histogram Tool: Create, Read, and Customize ChartsIn Excel for Microsoft 365 on Windows, select a column of numeric data and choose Insert > Insert…
- Excel Pivot Table: Sort Months ChronologicallyYes. To sort months chronologically in an Excel PivotTable, use a real date field and group it by…
- How to Make Org Chart Lines in PowerPoint and Align ThemTo make org chart lines in PowerPoint, insert a SmartArt organization chart and add positions with SmartArt Design…
- Creating a Power Pivot in Excel: Steps and TipsTo create a Power Pivot in Excel for Microsoft 365 on Windows, enable the Power Pivot add-in if…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.