![]() I even simplified them by extracting the legend and placing it at the top of the charts. Just take a look at the examples below (note: I would normally use colors from the football club logos in my charts, but the red is a bit harsh and the other colors clashed, so I abandoned them. My biggest gripe with pie charts, aside from when used poorly, is that they’re space hogs. That said, recently I’ve relaxed a little and used the occasional 2 or 3 segment (max) pie chart, but in doing so it only reinforces my reasons for disliking them. If you know me then you’ll know that I’m not a fan of pies, unless they contain apple and are edible □ We’ll start with the obvious and most favored among data visualization novices the pie chart. Using football as inspiration, let’s look at our options for visualizing parts to a whole data using this standard set of football statistics: To pass the time I often find myself looking at the match statistics posted on the screen.įootball stats typically focus on possession, shots, corners, fouls and other comparisons that often bear no correlation to the outcome of the game, although I’m not complaining as they help to pass the time □ When you think of visualizing parts to a whole in Excel charts the first thing that’s likely to come to mind is the pie chart, or if you’re Homer Simpson then you might think of doughnut charts!īeing outnumbered 3:1 by football (soccer) fans in my household, I get to see my fair share of “the beautiful game” on TV. Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |