Datalabels are missing in dynamic chart

microsoft-excel charts office365 microsoft-excel-2019

Solution 1:

The chart is treating the three columns as different series.

Use a formula to copy the data for the selected column into a single column that doesn't change. I have put this formula in G1:

=RIGHT($G$10,1)

And this formula in G2:

=OFFSET(A2:A4,0,G1)

I have list data validation in cell G10, similar to you:

enter image description here

Here, the chart is always using the same range for the data, so it treats it as a single series. As you have added the labels to that series, they are not lost when the data changes.

Related

Using cmd/Batch, how to determine whether or not you are connected to a WiFi network?
Windows 10: how to select multiple disks (in order to to eject them all at once)?
Run this line by line, or as a whole
What's the purpose of the PCIE_PWR header on my motherboard?
In furthering or to furthering [duplicate]
polite request: We would ask
What is the meaning of 'The institution of marriage was established, although symbols of primitive practices survived. '? [closed]
What is the term in linguistics when a word comes to have a new meaning over time, e.g 'wicked' is commonly used to demonstrate this
What is it called when the majority moves and leaves behind a small group of people effectively exiling those people but without forcing them to move
what does 'presume away' mean? [closed]
Is *raises the need for* a valid and meaningful phrase?
The mirror in which we "see" our wretchedness?