Displaying and Formatting Data in Charts


After completing this lesson, you will be able to:

  • Present and format data in charts


Your report is the gateway to insights and actionable information. Using the right charts means that your audience interprets data the right way and gets the right insights without any confusion. We broke them down into groups so you can identify the one that is most relevant depending on what you are trying to demonstrate.

You want to ask yourself a few questions before picking visualizations. These are examples that help you know why you might need a specific chart. Are you trying to compare values or analyze trends? Do you want to demonstrate the composition of a process or understand how your data is distributed? Do you want to highlight the relationship between several data subsets?

Charts are grouped by intentions and the type of analysis you want to run.

We broke them down in multiple groups to help you decide which ones are the most relevant to your needs.


Trellis is a new category of charts that display multiple sub-charts, one for each value of a set of dimensions.

Geographical database

The 100 000-inhabitant cities limit for other countries than United States of America has been removed and this geographical database contains about 10 times more cities.

The geo-mapping by name process has also been optimized and is faster, even if the database contains more cities.

Insert a chart

Creating a chart with the Insert menu is always available:

Chart format

You can format your report and report elements in order to present the report with a company style.

Select a chart and the Format tab to view formatting settings.

The table lists the Display settings:

The table lists the Appearance settings:

The table lists the Style settings:

The table lists the Layout settings:

Log in to track your progress & complete quizzes