Automatic Aggregation of Data

If you’d like to aggregate the data automatically in the chart, place a checkmark for Aggregate.

This saves you from creating a separate data preparation table.

Consider Future Data

Update the chart range to include additional cells for future data.

You can either add some extra rows or remove the row reference at the end of your range. This will automatically add the last visible row number.

Useful Visualizations

Some helpful “charts” can be found at the bottom of the chart type selection.

For example:

• Map chart

• Waterfall chart

• Gauge chart

• Scorecard

• Scrolling table

• Organization chart

Sparkline

Sparklines are created with the SPARKLINE function.

Check out this link for more information.

* The syntax needed to create a Sparkline is also included in your course notes. You can print it out and keep it handy.