I like to make mine fairly large so they are easy to see and change the colors individually to be color-blind safe or to match up with the College’s official colors. Now let’s edit the markets (the dots of the scatterplot). If you aren’t comfortable using this feature, double clicking on different areas of the scatterplot will take you to the correct (or generally correct) formatting area box. That little down arrow (see highlighted) allows me to navigate the areas of the chart I want to reformat. The Format Area box is my favorite to be honest. Now let’s turn the Y-axis label horizontal (double click to edit in the Format box).
Let’s add in Axes Titles, a Chart Title, Data Labels and remove the vertical Gridline.
#Award excel scatter plot labels series#
Go ahead and click “Add” under the Legend Entries (Series) area.Īs you can see above, I label my series name with the Year, plotting the Performance scores on the X axis, and the Importance scores on the Y axis. For me, the control I get by adding in series points myself is worth the extra minute.
If you know of a better way to select everything at once – go for it. Whenever I attempt to select a table as a whole, it never puts anything where I want it to. Now let’s just go ahead and insert a blank scatter plot and then hit “select data” under Chart Tools -> Design Ignore the “frequency” column – I originally wanted to show frequency of use of College resources but decided it was too much at once. Let’s pretend that the community rated the College on how it preforms (5-point Likert scale) and how important it is to them (also 5-point Likert scale). This is supposed to be a tutorial though so…uhh…deal.įirst of all, this is the data I was dealing with. I apologize in advance for the picture-heavy post.
#Award excel scatter plot labels how to#
So, I’m going to show you how to create a scatterplot in Excel, and then an alternative to that figure. The easier it is to explain something, the easier it to for the higher-ups to make decisions. I’m in the institutional research game, ya see? Showing results effectively is kind of my jam right now. It got me thinking about how to show someone both how to create a scatterplot and why two line graphs side-by-side might be more effective. The question itself wasn’t necessarily HOW to create a scatterplot in Excel, but rather how to properly label the end result. I stumbled upon a thread in the Excel subreddit about creating a scatter plot that showed both the importance and the performance of something.
0 kommentar(er)
