← Dashboards & charts

Which chart types are available and how can I use them?

DataLion offers around 50 chart types, from a simple bar to a conjoint analysis. This article lists them in the groups they appear in in the chart-type menu, says what each type is good for, and notes how it exports to PowerPoint. For newer types such as box plot, histogram and NPS, it explains the main settings.

NPS chart for a customer survey with an NPS score of −24 and the shares of detractors, passives and promoters

Requirements

  • An account that can edit charts.
  • Box plot, histogram and clustered columns are available from DataLion 2026.2.192 and 2026.2.193, the NPS chart from 2026.2.196, the wave slider on maps from 2026.2.197, and cluster analysis, TURF and the percentile table from 2026.3.200.

Change the chart type

  1. Click the gear in the top right of the chart (Chart settings).
  2. In the Appearance section, open Chart type.
  3. Pick a type from one of the five groups. The chart redraws right away.

Your administrator can limit the available types per project. Types that don’t fit the question, such as a histogram for a question without numeric values, show a message instead of a chart.

Bar / Column

The first choice for frequencies and comparisons.

  • Bar and Column: shares or means per answer. Bars suit long answer texts. PowerPoint: native.
  • Stacked bar and Stacked columns, each also as (100%): scales and item batteries at a glance, see Stacked chart with multiple items. PowerPoint: native.
  • Clustered bar and Clustered columns: several items or groups side by side instead of stacked
  • Mean: means of several items as bars. PowerPoint: native.
  • Waterfall: shows which contributions move a value from one level to the next
  • Calculation: results of an SQL calculation. PowerPoint: native.

Pie / Donut

For shares of a whole with few categories.

  • Pie and Donut: work well up to about five categories. PowerPoint: native.
  • Radial: shares as arcs. PowerPoint: image.
  • Aster: values as segments of different lengths
  • Multiring and Multiring (100%): several rings, for example for groups. PowerPoint: image.
  • Depending on the instance, also Funnel (horizontal and vertical, PowerPoint: image) and Pyramid.

Line / Timeline

For developments over time and relationships between numbers.

  • Line: simple trends. PowerPoint: native.
  • Timeline: values over date or waves, with an adjustable interval. PowerPoint: native. See below.
  • Area: a trend as a filled area
  • Radar: several items on axes around a center. PowerPoint: native.
  • Scatterplot: two numeric values against each other, with a regression line. PowerPoint: native, without the regression equation and line.
  • Bubble and XY bubble: like a scatterplot, with size as a third dimension. PowerPoint: native as a bar chart.

Table / Number / Polarity

  • Table, Table (nested) and Table (calculations): crosstabs with significance tests, see Tables in DataLion. PowerPoint: native.
  • Number: a single value, such as a case count. PowerPoint: editable text.
  • KPI: a key figure as a tile. Under Chart style…, on the Layout tab, switch on Show previous value and Show change.
  • Polarity and Polarity (auto): profiles across opposite terms or scales. PowerPoint: native.
  • Text: open answers as a list. PowerPoint: native.
  • Images: images instead of values, such as product photos

Other

  • Box Plot: the distribution of a numeric variable with median, quartiles and outliers. With a breakdown, DataLion draws one box per group.
  • Histogram: the frequency distribution of a numeric variable. Set the number of classes in the chart menu under Bins: Auto, 5, 10, 15, 20 or 30.
  • NPS: the Net Promoter Score of a 0-to-10 question, see below
  • Map: values by region, with a wave slider, see below
  • Heatmap, Treemap, Chord and Network: relationships and structures. Chord diagrams export to PowerPoint as images.
  • Wordcloud: frequent terms from open answers. PowerPoint: image.
  • Gauge: a single value on a gauge scale
  • PSM: Van Westendorp price sensitivity
  • Cluster analysis (k-means): splits respondents into segments based on a rating battery, see below
  • TURF (reach and frequency): finds the combination of items that reaches the most respondents, see below
  • Percentile table: percentiles of a numeric variable per group, see below. PowerPoint: native table.
  • Advanced statistics: regressions, analysis of variance, driver analysis and MaxDiff

Conjoint and MaxDiff questions from DataLion surveys have their own analyses, see Conjoint analysis and Analyze MaxDiff results.

Confidence band and quick ranges on timelines

On a timeline, open Chart style… and the Timeline tab:

  • Under Forecasting, Confidence band: adds a band around the line at 80, 90, 95 or 99 % confidence. The default is 95 %.
  • Show quick time ranges puts buttons above the chart: 1M, 3M, 6M, YTD, 1Y and All. Default time range: sets what applies when the chart opens.
  • Show overview strip adds a strip that lets readers pick a section.

If the project has tracker waves, choose Wave under Time interval in the chart menu.

Mean of all items on polarity and radar charts

For Polarity, Polarity (auto) and Radar, Show mean of all items (under Chart style… on the Layout tab) adds a line with the average across all items. That shows which items sit above or below average.

NPS chart

For a 0-to-10 question, the NPS chart shows the NPS score and, below it, the shares of Detractors (0 to 6), Passives (7 and 8) and Promoters (9 and 10). With several data series, each series gets its own card. DataLion uses the same layout in Excel and PowerPoint exports. How the score is calculated is explained in Calculate the Net Promoter Score.

Map with a wave slider

A Map shows values by region. If the chart has a breakdown by wave with more than one wave, a slider appears below the map:

  • The Wave slider jumps between waves, Play shows them one after another.
  • Change vs. previous wave colors regions by the difference to the previous wave, Values switches back.
  • Regions without values or with suppressed values get their own color, labelled No data in the legend.

Choose which map the chart uses under Map in the chart menu.

Cluster analysis (k-means)

Cluster analysis groups respondents by their answers to a question with numeric items, such as a rating battery. It uses the cases that answered every item.

  • Segment profiles show each segment’s mean per item. The colour shows how far a segment lies above (blue) or below (red) the total.
  • Segment sizes show how many respondents belong to each segment.
  • Under Number of segments, choose Automatic (best silhouette) or a fixed number. The Within-segment sum of squares and the Average silhouette width help you choose: take the number after which the sum of squares hardly drops any more, or the one with the highest silhouette.
  • Save segments as a variable adds segment membership as a new variable. You can then filter by the segments or break other questions down by them.

TURF (reach and frequency)

TURF finds the combination of products, channels or features that reaches the most respondents. It works on a multiple-response question or a rating battery with at least two items. For a rating scale, set under Rating items reach from value which answer counts as reaching a person.

The result shows the Single-item reach, the Best portfolios for each size with alternatives, and a Reach curve. Reach is the share of respondents reached by at least one item of the portfolio. Frequency is the average number of items per person reached. Set the maximum portfolio size under Largest portfolio. TURF uses the chart’s weight.

Percentile table

The percentile table shows the distribution of a numeric variable for each category of a breakdown, such as spending by region. By default it shows P10, P25, the median, P75 and P90. The table is weighted and gives the case count per group. If a group has too few cases, it shows a note instead of percentiles. Exports go to Excel and to PowerPoint as a native table.

Tips

  • For scales with many items, stacked bars or polarity charts are usually easier to read than many separate charts.
  • Before a PowerPoint export, check whether the type exports natively. Native charts stay editable in PowerPoint, images don’t. More in Create and apply a PowerPoint master.
  • To combine or hide answers without changing the type, use Edit chart data.