How to Unify the Format and Type of Your Excel Charts through Paste Special Function

In Excel, the chart is an indispensable tool for data analysis. And now in this article, we will discuss about unify the chart format and type through paste special in Excel.

In an Excel workbook or worksheet, you will certainly create several charts. And for each chart, you will probably set the different format. Sometimes, you need to unify the format. And sometimes, you even want to make all the charts into the same type. So you need to set the format for each chart manually. This is surely a tough task. Therefore, you can use the feature of paste special to realize this task.

Unify the Format

In this image, you can see that there are two column charts.The Example for Paste Special

But the first one is much better than the second one. So unify the format is necessary. And the following are the steps to change and unify the format.

  1. Click the first chart.
  2. Then right click your mouse.
  3. In the new menu, choose the option “Copy”.Click Copy
  4. Now click the target chart. Here we click the second chart in the worksheet.
  5. Then click the small arrow under the button “Paste”.Click Small Arrow
  6. And then you will see a new drop-down menu. Now click the button of “Paste Special”.Click Paste Special
  7. In the new pop-up window, choose the second option “Formats”.Choose Formats
  8. And then click “OK”.

And after all the previous steps, you can see that the format of the second chart also changes.The Second Chart Changes

Therefore, instead of changing the format manually, this feature is more convenient.

Change the Type

Except for the format, you can also use this feature to change the type of chart. In this image, there are two charts with different types.Two Different Types

And if you want to change the second chart into line chart, you can also use the paste special feature. Repeat the 8 steps in the previous part and then you can get the result.The Type Change

So, if you want to change the type of the second chart, you can also use this paste special feature. But you need to notice that the format of the second chart also changes. So if you only want to change the type, this feature is not available for you.

Dealing with a Suspicious Excel File

Excel may get corrupt due to various reasons. And the result may be disastrous. Therefore, once you find a suspicious Excel file, you should take actions as soon as possible. And the third party tool can be very helpful to fix Excel. This software can help you retrieve almost all the data and information in the damaged file.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit

Comments are closed.