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.

Starting Graph to Copy and Paste Graph in Excel

 

Copy your Graph

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

Copy Graph Format to Paste Format in Excel

 

Paste Graph Format

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

Paste Special Format Graph Chart as Excel

 

5. Select Formats

Paste Special as Format Graph Chart Excel

 

 

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.

Starting Graph to Copy and Paste Format as Google Sheets

 

Copy your Graph

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

Copy Graph Format to Paste Special Format as Graph in Google Sheets

 

Paste Graph Format

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

Paste Special Format as Graph in Google Sheets