Updating excel 2016 data labels
When I recorded a macro to reset the label text as stated above so I could see what command was being placed using VBA, this is what I found.
This option won’t work unless you first set the X axis to a Text axis although you and I both wish it would!
Messing with vb doesn't seem like a durable solution to me (other people are sometimes affected in my company on different files).
I am really curious about what is the source of this to be honest.
in your chart labels and the chart should update again when your data changes.
I think in my case somehow this option was turned off.