Skip main navigation

Charts

.
In the previous step, you learned how to draw accurate reports that you can use to gain insights into how your business is doing.

You can use these reports as is or customise them for your needs. You can also use the Report Wizard to create custom reports. Another way to view your analytical data is by compiling charts.

Charts are graphical representations of data from different views of an entity. When a view is updated, so is the chart.

In Dynamics 365 there are several different types of charts available. You can use the out of the box charts or you can customise your own. Once the chart is created, it can be used from within views or added to Dashboards.

To locate chart definitions, within the solution you can find them under the entity that is the target of the chart.

Screenshot of how to locate charts

System Charts

System charts are created by users with a system administrator or system customiser security role. These charts are visible to all users in the organisation. If you customise a solution or the system, you have the chart option under each entity. These charts use system or personal views to populate the chart.

The types of system chart you can create in the system charts are column, stacked column, 100% stacked column, bar, stacked bar, 100% stacked bar, area, stacked area, 100% stacked area, line, pie, funnel, tag and doughnut.

You would need to specify the fields that you want to display on the Horizontal (Category) Axis Labels and the Legend Entries (Series). The Legend Entries (Series) axis displays data that is only a numeric value.

You can choose Avg, CountAll, Count Non-empty, Max, Min, or Sum. If you choose a non-numeric field for the series axis, you can only choose CountAll or Count Non-empty. Record

The Horizontal (Category) Axis Labels displays either numeric or non-numeric values. You can have up to two categories listed.

Charts can be exported and imported into other solutions. You can also customise charts by exporting the chart to an XML file and making the appropriate modification needed in XML.

Types of Charts

This is the menu to choose which type of chart you want to create. You can select it from the top menus or choose it under the picture of the chart.

Screenshot of types of charts

Column Chart

Example of column chart

Stacked Column Chart

Example of stacked column chart

100% Stacked Column Chart

Example of 100% stacked column chart

Bar Chart

Stacked Bar Chart

Example of stacked bar chart

100% Stacked Bar Chart

Example of 100% stacked bar chart

Area Chart

Example of area chart

Stacked Area Chart

Example of stacked area chart

100% Stacked Area Chart

Example of 100% stacked area chart

Pie Chart

Example of pie chart

Line Chart

Example of line chart

Funnel Chart

Example of funnel chart

Tag Chart

Example of tag chart

Doughnut Chart

*Example of doughnut chart

Rules

Note: Personal charts are very similar, except Tag and Doughnut charts are not available in personal charts.

Rules can be created to only show the top or bottom few records in the chart. You can select this from both the menus and while building the chart itself.

Screenshot of selecting the top and bottom rules

Viewing Charts

When displaying the chart next to your view, they are collapsed by default, but when you select Show Charts, the chart will appear on the left side of the view.

Screenshot of selecting charts to view

Once it displays, you can select a different view and the chart will refresh with the data from the new view.

Screenshot of selecting different views of charts

Drilling Down

Screenshot of how to select attributes for drilling down in a chart

Drilling down means going into the chart to see only specific data. If you are drilling down through the chart, you will be asked for certain questions regarding which area you will want to drill into. To drill down into the data further, simply click on the chart itself and you will be given the ability to make your data selections.

Screenshot of options to drill down in a chart

Personal Charts

Personal charts are available via the classic menus and are expected to be available with the interactive menus in the next release. Personal charts are very similar to system charts. Personal charts are associated with the user who created them but can be shared out with other users.

A user can export a personal chart definition and share it with an administrator who can then import it and configure it as a system chart and make it available to all users.

In the following step, we explore goals and take part in a discussion. Click on Mark as complete when you are ready to move on.

This article is from the free online

Dynamics 365: Customer Engagement for Sales

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education