Excel has lots of charting options. Line charts, bar charts, scatter plots, pie charts and oh, so much more. But it doesn’t have this chart.
This is a nice chart for showing two values for many different variables. It’s easy to read with the labels listed vertically and it fills a page nicely without being overwhelming.
First, put together the three columns of data – the labels, the first score, the second score. Second, copy out the equation that you see in the Excel menu bar
REPT: Excel will repeat a value a certain number of times
“g”: The value Excel is going to repeat. Notice that the font I’m using in that particular cell is webdings. You might have to use a different font to generate the same result but you’re looking for any character in any font that is a really wide fat box.
D5*2: This is how many times Excel is going to repeat the value. In the case of the highlighted cell, Excel is going to duplicate the g value 4.4 times 2. If you find your bar is too long, instead of multiplying by 2, trying dividing by 2.
Now, align right the first column and align left the second column. To remind your reader of what’s going on, colour in green the column that reflects the good thing and colour in red the column that reflects the bad thing. Well, now that I look at it, perhaps the yum column ought to be in green!
At this point, you can either copy paste the cells directly into powerpoint or word, or create a screencapped image and paste it anywhere. Enjoy!