Labels in Scatterplot broken

[radicaloptimist]

Hello,

I created a table in that other people will not enter information in Sheet1 and this information will then be shown on Sheet 2 in ranking. Part of the ranking is a scatterplot where the data points are shown. The scatterplot should have labels, so it shows the name of the item.
My problem is, when new data lines are entered in Sheet 1, they data points appear in Sheet 2 and the scatterplot, but the new points appear without labels.

Are there some settings that I can apply to automatically apply the Label settings for the complete range (model built for 300 lines).

I hope the description is clear. I'm happy for any help.

Thanks!
radicaloptimist

 

[thisoldman]

You're using Excel 2013 or later? I'm on 2016.
You're using a structured table, correct?
The labels are in a column in the table?
We'll call the table "Table1". The labels are in the table column "Names"

From the formatting pane, Format Data Labels. Under "Label Options", under "Label Options" (yes, it's repeated), check the box next to "Value from Cells" then click on "Select Range...".

In the pop-up, in the box labeled "Select Label Data Range", type:
Table1[Names]
and click OK.

The text chart I constructed updated the chart labels as new entries were added to the table. After I edited the table, Excel would pop up the message "Excel found a problem with one or more formulas ...", but the labels still updated correctly.