Hi, I need to create several charts with identical formatting but with different data. In Excel 2011, I created and formatted one chart, which I then duplicated.
I used 'select data' to select new data. The selection of new data did not affect the formatting. In Excel 2016 selection of new data resets the formatting of the chart. I wonder if it is possible to prevent Excel from resetting the formatting.
I found that exactly the same problem had been reported for Excel 2013 for Windows. (Unfortunately, the suggested solution (unchecking of: OptionsAdvanced ChartProperties follow chart data point for current workbook) is not available in Excel 2016 for Mac. The only workaround that I could come by is to: 1. Format a chart 2. Duplicate the chart 3. Select new data (which resets the formatting) 4.
![Mac Mac](/uploads/1/2/5/6/125648492/459544258.png)
![Format Format](https://erc.barnard.edu/sites/default/files/styles/wysiwyg_largest/public/screen_shot_2013-10-24_at_12.55.35_pm.png?itok=NjUw6J5j)
Oct 12, 2012 - Learn 10 cool techniques that will make your Excel charts way sexier. On the Mac, you'll choose Charts > Chart Layout > Labels > Chart Title. This will save your chart as a.crtx file in a chart templates folder.
Copy the formatted chart and paste special the formatting to the duplicated chart. This is not very efficient compared to what could be done in Excel 2011. Creating a template each time I want to duplicate a chart is not a good solution either.
I thought maybe some of you have stumbled on the same problem and found a better way to handle it. Your help will be much appreciated.