I am having a problem with the format of data labels for a stacked column chart.
Having formatted the data labels to my liking, if another series added then the label format of the new series reverts to the default. Custom formatting does not persist when there is dynamic data.
I can create a Chart Template but not a Chart Style!
You cannot select all the data labels!
I can use VB to loop through and format all the labels!
But does anyone know of a way to set the underlying data label format?
I attach a spreadsheet to illustrate my problem. I am currently using Excel 365 on Windows 10.
Graham
Hi Graham,
Welcome to our forum!
Each series' data labels are independently formatted, so there's no default way to ensure the series name is always included. You'll need to use VBA to fix it.
Mynda
Thanks Mynda,
I suspected that was the answer having scoured the internet. So you should be careful using charts with independent series with dynamic data. It seems that it is something the MS Excel team should consider for a future update.
Have written the VBA so will just use that to update the charts.
Graham
