9/19/2023 0 Comments Scatter plot in excel 2016Not always very helpful…īut… now we can tell it where to get the label from – Hurrah! Here, you can opt to show the X & Y values we’ve previously been able to show. You will now see the Format Data Labels screen Select ‘Add Chart Element à Data Labels à More Data Label Options… With your chart selected įrom the Tab Tools tab group, select the DESIGN tab Thankfully, in Excel 2013, we can finally add proper labels to scatter charts. The only label you could add was one to show the actual numeric values (83% / -1.5%) – which doesn’t help identify the ‘owner’ of those values. Until Excel 2013, adding a label to a value on a scatter chart was a pain, and involved creating a VBA scripts to add these. We can quickly see that whilst most students hit the pass mark or 84.5%, the bulk of students slipped back from their previous score – must have been a tough exam!īut, what if you want to know which students are really struggling, and perhaps who really sits at the top of the pack? ![]() ![]() In my example, I’m using a scatter charts to monitor student test results – I want to compare their latest test score against how that score has changed from their last test. Scatter charts are a great way to present the relationship between two data points
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |