![]() This is probably the simplest way to add the desired text to the data points. Add specific text to the data points: a colleague introduced me to “XY Chart Labels”. Then, goto marker fill and select a color for that category/series. Make the data points square and colored: Right click on a data point and select “Format Data Series…”, Go to marker options, select the ‘built-in’ radio button and the square from the type dropdown menu. Once you have your quadrants figured out, the finishing touch is the data point formatting. Since I am no expert in excel, I looked up how to create the 4 quadrant graph and the link below was extremely helpful and detailed – Format the graph to look like the above ppt graph In order to get this graph in excel, there are two major steps that need to be followed:Ģ. The number in the data label has a legend attached to it which details the items being mapped. ![]() These kind of graphs (in my short experience) are typically used to rank a list of items categorized into different buckets.Īs can be seen in the picture above, there are 4 categories of items and the ranking can be deduced from the quadrant they fall in. The target graph was to look like the below picture. I recently tried to replicate a graph, I have often made in powerpoint, in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |