excel chart keep formatting. Then change the chart's source. As suggested by @erikf, this page shows how it can be done, i.e., by clicking file > options > advanced > chart > deselect both.
excel chart keep formatting As suggested by @erikf, this page shows how it can be done, i.e., by clicking file > options > advanced > chart > deselect both. Then change the chart's source. Co to file > options > advanced, scroll down the the charts section, and uncheck properties follow chart data point for current workbook.
As Suggested By @Erikf, This Page Shows How It Can Be Done, I.e., By Clicking File > Options > Advanced > Chart > Deselect Both.
Select any cell in your pivot table, and right click. Bar charts and pie charts. There are a few things you can do to prevent excel from changing the chart formatting when you change the data.
Then Change The Chart's Source.
To keep the formatting when you refresh your pivot table, do with following steps: Co to file > options > advanced, scroll down the the charts section, and uncheck properties follow chart data point for current workbook. I have created a couple different charts.
I Have Changed The Font Color And Size About A Million Times.
Excel loves include annoying, bland and boring defaults to upset your work.