Embiro BI

Documentation › Charts

Choosing a chart type

Which chart type to use for which question - trends, comparisons, shares, distributions, KPIs, tables and maps.

The right chart makes the answer obvious at a glance. Start from the question you are answering.

Question Good chart types
How is it changing over time? Line Chart, Area Chart, Bar Chart (by month), Smooth Line
What's the one number that matters? Big Number, Big Number with Trendline
How do categories compare? Bar Chart (horizontal for long names), Table
What is the share of each part? Pie Chart (up to about 6 slices), Treemap, Bar Chart (stacked, 100%)
How is it spread out? Histogram, Box Plot
How do two measures relate? Scatter Plot, Bubble Chart
Where is it happening? Country Map, World Map, Point Cluster Map. See Maps and ISO codes
How does a target compare to actual? Gauge Chart, Bullet Chart, Mixed Chart (bars and a line)
Where do things flow? Sankey Chart, Funnel Chart
What's in the detail? Table, Pivot Table
Something custom (a card, a list, a formatted message)? Handlebars. See Handlebars charts

Most-used charts

Big Number with Trendline
A headline figure with a small trend line under it and the change against the previous period. Choose the metric, the date column and the Time grain. Use Comparison Period Lag to compare with, say, 12 months earlier.
Bar Chart
Compares categories or time periods. Put a column in X-axis and one or more Metrics; add a Dimension to split bars by, say, region. Stack series in Customize stacks them.
Line Chart
Shows trends. The X-axis is a date column with a Time grain. Add a Dimension for one line per category. Use Advanced analytics for rolling averages.
Mixed Chart
Two queries in one chart, for example revenue as bars and margin % as a line on a second axis.
Table
Rows and columns, with sorting, search and pagination. Query mode: Aggregate groups rows (one row per branch with its totals). Raw records lists rows as they are. Conditional formatting colours cells by value.
Pivot Table
Cross-tabulates one measure by two dimensions (branches down, months across), with subtotals and totals.
Pie Chart
Shares of a whole. Keep it to a few slices: set Row limit to 5 or 6 and the rest are grouped as Other. A bar chart is often easier to read.

Tips

  • One message per chart. If you need to explain two things, make two charts.
  • Start the value axis at zero for bar charts, so bar lengths compare fairly.
  • Use the same colours for the same things across a dashboard: the colour scheme does this for you when the values match.
  • Write the unit in the title or axis title: Revenue (UGX, millions).

Something unclear or missing? Tell us and we'll improve this page.