Summary

In this chapter, you have learned how to use conditional formatting, shapes, SmartArt, sparklines, images, and symbols as visualization tools. They are all important tools in a competent dashboard builder’s toolbox, and you will see your reports look more professional as you put them to use.

This chapter on non-chart visuals brings us closer to the end of this book on Building Interactive Dashboards in M365 Excel & Excel 2021. We have covered all the technical pieces that go into a dashboard in Excel. In the next and last three chapters, we will combine all we have learned so far to set up a dashboard layout, perfect the data model behind the dashboard, and complete a company-wide dashboard for a retail company. Exciting, right?

In the next chapter, we will begin the end of our journey by going through how to set up a dashboard layout. See you in the next chapter!