Forum Discussion
How to maintain chart formatting when altering the data range each month?
Hello,
what do you mean with "if not in consecutive cells"? Do you want to plot from a start month, then leave a gap?
When you select the chart, the data is highlighted. You can drag the sizing handles of the highlights to change what data is charted.
I know it's an old question, but it wasn't really answered.
There's an obscure and poorly documented setting in Excel called Properties Follow Chart Data Points. It means if you apply custom formatting to your chart, the custom formatting is linked to the cells containing the plotted data and not to the points and series in the charts. Confusing, I know.
If you turn off this setting, you can change the chart source data, and the customization will stick.
Go to File > Options > Advanced, and scroll halfway down to the Chart section. Then Uncheck the box for Properties Follow Chart Data Point for Current Workbook.
Then go check the box, because some things work better that way.
I wrote an article about this setting: https://peltiertech.com/properties-follow-chart-data-point/.