At times, you may want to batch apply the format of one chart to all the others in an Excel worksheet. In this article, we will expose 2 quick methods to you.
Perhaps you have created a lot of charts in an Excel worksheet and these charts may be in different formats. For instance, some are pie charts, some are column charts and some are line charts. Now, you may want to unify the formats of all the charts. You wish to copy the format of a chart to all the other charts in the sheet. In general, most users will utilize the following Method 1 to manually do it one by one. Yet, if there are many charts to be processed, you’d better use the latter way.
Method 1: Copy Chart Format One by One
- First off, open the Excel worksheet that you want.
- Then, pitch on the model chart and right click on it.
- From the context menu, select “Copy” option.
- Then, select another chart.
- Next, click “Paste” button and select “Paste Special” in “Clipboard” group.
- In the popup dialog box, select “Formats” and click “OK”.
- At once, the selected chart’s format has been modified.
- Now, in this way, you can copy the source chart’s formats to the other charts one by one.
Method 2: Batch Apply with Excel VBA
- To begin with, launch Excel VBA editor according to “How to Run VBA Code in Your Excel“.
- Then, put the following code into a module.
Sub CopyChartFormatToOtherCharts() Dim objChart As ChartObject ActiveChart.ChartArea.Copy For Each objChart In ActiveSheet.ChartObjects objChart.Activate ActiveSheet.PasteSpecial Format:=2 Next objChart End Sub
- After that, add this macro to ribbon or Quick Access Toolbar.
- Eventually, you can have a try.
- At first, select the sample chart.
- Then, hit the newly added macro button.
- Immediately, the other charts’ formats have been changed to the source one, like the following screenshot.
|Method 1||Easy to operate||Unable to process many charts in bulk|
|Method 2||Far faster and more effective to process multiple charts in batches||Users have to keep cautious of external malicious macros.|
Fix Compromised Excel Files
At times, Excel files can be corrupted or lost due to miscellaneous factors, such as human errors, like accidental deletion, or Excel crashes and so on. Therefore, it is necessary to get hold of a powerful xlsx repair utility, such as DataNumen Excel Repair. It’s earned a lot of kudos due to its effectiveness and high Excel recovery rate.
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf fix and outlook repair software products. For more information visit www.datanumen.com