Copy Chart Format – Excel & Google Sheets

Copy Chart Format – Excel

Starting with the Graph

In this tutorial, we’ll show how to copy and paste a chart format. Below you’ll see two charts for the same information for different graphs. Let’s say you want to copy the format from the second graph to the first graph.

Copy your Graph

Click on the graph and select Copy (Ctrl + C)

Paste Graph Format

1. Click on the other graph
2. Select Home
3. Select Arrow under Paste
4. Select Paste Special

5. Select Formats

Copy Chart Format – Google Sheets

Starting with your Graph

In this scenario, we want to copy the format of the second graph and paste it to the first graph.

Copy your Graph

Click on the graph you want to copy format and click copy (Ctrl + C)

Paste Graph Format

1. Click on your Graph
2. Select Edit
3. Click Paste Special
4. Select Format Only