- Choosing a Chart Type
- Understanding Date-Based Axis Versus Category-Based Axis in Trend Charts
- Communicate Effectively with Charts
- Adding an Automatic Trendline to a Chart
- Showing a Trend of Monthly Sales and Year-to-Date Sales
- Understanding the Shortcomings of Stacked Column Charts
- Shortcomings of Showing Many Trends on a Single Chart
- Next Steps
This chapter is from the book
This chapter is from the book
This chapter is from the book
Shortcomings of Showing Many Trends on a Single Chart
Instead of using a stacked column chart, you might try to show many trendlines on a single line chart, which can be confusing. For example, in the top chart in Figure 3.35, the sales trends of five companies create a very confusing chart.
)
Figure 3.35. Instead of using a single chart with five confusing lines, compare your company to each other competitor in smaller charts.
If the goal is to compare the sales results of your company against those of each major competitor, consider using four individual charts instead, as shown at the bottom of Figure 3.35. In these charts, the reader can easily see that your company is about to overtake the long-time industry leader MegaCo, but that quick growth from NewCo might still cause you to stay in the second position next year.