![]() 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |