Data labels (depending on 3rd variable) of newly added data points do not show

[Janvandenbossche]

Hi guys,

First post on this forum

.


I have a table with a list of initiatives

- First column: the number of the initiatives
- Second: Description of initiative
- Third: Type of initiative (3 different types: digital tool, IT change, Process change)
- Fourth: Impact score (0-5)
- Fifth: Feasibility score (0-5)

I made a scatter plot with: Impact score on X-Axis and Feasibility score on Y-Axis. The color of the data point on the scatter plot depends on the type of initiative (This I did by creating different series of the depending score (see last 3 columns of table)) and the value of the data label depends on the number of the initiative. This I simply did by selecting 'label contains value from cells' in the label options.

Now the problem is that when I add a new initiative in my table, everything updates (new data point on chart in right position with the right color) but it does not show the data label (which depends on the number of the initiative). If you look on the chart the point with the biggest impact does not contain a data label and this is an initiative I created after making my graph. I tried a lot of things but I am not able to fix this. Hopefully you guys can help me with this!

Thanks a lot!

Jan

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially regarding cross-posting, and then add links here to your related post(s) in other forums. Thanks.

 

[Janvandenbossche]

Welcome to the forum.

Please take a minute to read the forum rules, especially regarding cross-posting, and then add links here to your related post(s) in other forums. Thanks.

Hi RoryA,

I am sorry, I did not know cross-posting would be an issue, but indeed I posted the exact same post on another forum hoping to raise my chances of solving my issue . I edited my original post containing the link to the other forum.

 

[Janvandenbossche]

Edit: I posted this as well on another forum: https://www.excelforum.com/excel-ch...e-of-newly-added-data-points-do-not-show.html