New Shortcuts Learnt in This Section

[Alt] F1 Inserts the default chart type on the same sheet

F11 Inserts the default chart type on a separate (chart) tab

[Shift] & draw - Hold down shift while drawing a line to get a straight line

Chart Productivity Tips

Adjust the Default Chart Type

If youd like to change your default chart from column to another type, e.g., Line chart: Go to Insert Chart dialog box, right-mouse click on the chart type you want and select Set as Default Chart.

Turn your Source Data to an Excel Table

If youd like your chart to automatically include new values, turn your source data into an Excel table.

Add Your Own Axis to Sparklines

To make it easier to spot which data point belongs to which category, create a manual axis directly under the sparklines.

This works for fixed data points otherwise youll have to think of ways to make it dynamic with formulas.

Group Different Charts Together

If you create a set of charts that need to stay together, make sure you group them. Select the charts by holding down Ctrl, right-mouse click & Group.


Remember: Your downloadable course notes cover the most important points. Make sure you keep them handy.

Here's how far you've come

Keep Going!