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.
Here are the tricks of the trade. You can see everything that I've done in the image here so it's easy to follow along.
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('g',D5*2)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 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.
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!
0 komentar:
Posting Komentar