When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).

After adding several charts to a sheet, you might want to adjust their sizes so they're all the same. You can do so manually or by using the easy macro.