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](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/07/Apply-Chart-Format-1.png)
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](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/07/Apply-Chart-Format-2.png)
Click here to download the Practice file-