Hi guys,
First post on this forum .
I have a table with a list of initiatives
table excelF.PNG
- 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.
chart excelF.PNG
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
EDIT: Just read the forum rules about cross-posting. I posted the same issue on Mr.Excel but cannot show the link because I get an error saying 'You are not allowed to post any kinds of links, images or videos until you post a few times.'
Bookmarks