Excel® 2013 Charts and Graphs

4. Creating Charts That Show Differences

In This Chapter

Comparing Entities

Using Bar Charts to Illustrate Item Comparisons

Showing Component Comparisons

Using a Waterfall Chart to Tell the Story of Component Decomposition

Next Steps

Comparing Entities

Whereas Chapter 3, “Creating Charts That Show Trends,” was concerned with the progression of a trend over time, this chapter focuses on demonstrating the differences between entities. For example, you can use Excel charts to compare each sales region versus the others or your company versus the competitors. In addition, when you want to compare the differences among a handful of entities, a bar chart is the perfect choice because the reader can clearly see the differences between the entities. ...