
Active Member

January 5, 2022

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

Active Member

January 5, 2022

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
The following users say thank you to Graham Gibbons for this useful post:
Mynda Treacy1 Guest(s)
