Excel Tips and Tricks

Apply Same Format on other Charts

In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting on this, now we want to apply same formatting on day-wise sales chart.

Month-Wise Sales Chart
Month-Wise Sales Chart

Below are the steps:

  • Just copy the month-wise sales chart
  • Select the day-wise sales
  • Go to Home tab >> Paste >> Paste special or press Alt E+S
  • Paste Special window will be opened.
  • Select Formats option and click on OK button.
  • Same format will be applied to this chart.
Paste Special Formats
Paste Special Formats


Click here to download the Practice file-


Watch the step by step video tutorial:

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.