motion

Comparing Entities in Excel 2007:-

Here our focus is on demonstrating the differences between entities. For example, you could use Excel charts to compare each sales region versus the others or your company versus the competitors.

When you want to compare the differences among a handful of entities, a bar chart is the perfect choice. The reader can easily see the differences between the entities. The only time you should use a pie chart is when you want to show how components add up to a whole entity. Pie charts are vastly overused, and many guidelines contraindicate their use. You should often instead consider 100% stacked column charts, bar of pie charts, or pie of pie charts. These last charts are a bit tricky to master but have some amazingly cool flexibility.

Finally, in this chapter you will learn how to use some more Excel trickery to build a waterfall chart. This type of chart is perfect for telling the story of how a whole entity breaks down into components.