Visualizing Data in Excel

Lessons in this section

1. Creating Charts

   Choose and insert column, bar, line, and pie charts, update their data, change their type, and remove them.

2. Chart Formatting

   Add chart titles, data labels, legends, and axis titles, and change chart styles and colors.

3. Conditional Formatting

   Highlight values greater or less than a limit, mark duplicates, and add data bars, color scales, and icon sets. Then build a sales dashboard in the Chapter 7 project.