Excel 2016 data labels not updating

There are a number of ways to apply custom data labels to your chart: The least sophisticated way to get your desired text into each label is to manually type it in.Click once on a label to select the series of labels.If I were to have data in excel just like the table below, and then make line charts with that data.All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data.Type the text you want to display in the label, and press the Enter key. This could get tedious, and you run the risk of typing the wrong text for the wrong label (I initially typed “alpha” for the label above, and had to redo my screenshot).One thing that makes this approach unsophisticated is that the typed labels are not dynamic. This could get tedious, but at least the labels are dynamic.

To change the label, you can change the text in the source data.

If the 'Select Data' had Minutes and Cartons set as Series they would originally go from rows 2 to 11 in their respective columns, but since I added 3 new data points, I want the chart to automatically update to graph rows 2 to 14.

How do you get excel to do that on its own, instead of me having to go into the Select Data and edit every series every time? you could create a table in a database and then insert into the table every time you have new information, then you just create a query that pulls information from the last 10 records inserted and then Graph it, I think you can graph inside of Access, I usually use SQL Server and Reporting software though. I can't test right now, but have you tried leaving the Table stationary and moving the Chart?

So lets say this is where you started: If you then insert rows (right click, insert)into the middle of your range, like so: That should add to the range.

Then you simply copy the data that was below to its proper place (in this case Round 9 and 10) and then add what you need to add (in this case 11 -16).

Leave a Reply