Summary

This chapter has been a fairly long one, as we have covered all 19 chart types you will come across in modern Excel versions. It is a commendable feat to master all 19 charts but it is not recommended to use them all in your report creation. The first four charts we covered are going to be your go-to charts: column chart, bar chart, line chart, and pie chart. They are versatile and easy to interpret by all classes of users. Then, a few charts are great to try out occasionally: filled map chart, sunburst chart, area chart, waterfall chart, treemap chart, and funnel chart. The rest must be used, if ever, with a great deal of caution as they can prove unreadable for untrained audiences.

The biggest takeaway we want you to have from this chapter is that charts are extremely important in modern-day reports and dashboard creation. You have to be good at selecting the right charts and ensuring the design looks good.

In the next chapter, we will cover non-chart visuals. You will...