chart formatting changes when changing data. As i created a pivot chart, i applied format to the chart, such as changing color of some series. To do this, i select both data series and plot onto the chart required (scatterplot).
chart formatting changes when changing data I format each data series to my desire (colours, axes, etc.). It explains that excel actually stores formatting data in a cache with all the other chart properties. As i created a pivot chart, i applied format to the chart, such as changing color of some series.
As I Created A Pivot Chart, I Applied Format To The Chart, Such As Changing Color Of Some Series.
When selecting the appropriate data to update the charts, if not in consecutive cells, the formatting is lost and reverts back to either. I format each data series to my desire (colours, axes, etc.). This means that it remembers the exact formatting.
To Do This, I Select Both Data Series And Plot Onto The Chart Required (Scatterplot).
Learn how to stop excel from changing chart formatting when you change data. It explains that excel actually stores formatting data in a cache with all the other chart properties. However, in excel 2013 when i change the series data (in either the formula bar or select data window) it changes the original.
This Common Problem Can Be Easily Fixed By.
As suggested by @erikf, this page shows how it can be done, i.e., by clicking file > options > advanced > chart > deselect both.