Waterfall chart

Overview How to create a Waterfall chart? Examples Overview With a little bit of arranging series you can show series as a Waterfall chart on a Category chart. How to create a Waterfall chart? On Series list add series and same amount of ‘0’ as series. Decide the order of the series on chart – … Continue reading “Waterfall chart”

Spaghetti chart

Overview How to create a Spaghetti chart? Example Overview Spaghetti-like chart can be created on a Scatter chart with Show direction function. How to create a Spaghetti chart? Add Scatter chart. On Graph layout (Ctrl+L) add two series under Line chart graph type – first series will be on x-axis, second on y-axis. Click on … Continue reading “Spaghetti chart”

Lollipop chart

Overview How to create a Lollipop chart? Example Overview There is no dedicated chart type for Lollipop charts. However, with a little help of two additional analyses and graph types, you can create lollipops on Category chart. How to create a Lollipop chart? Use Scalar to perform calculations. If needed, add Sorting analysis too. Add … Continue reading “Lollipop chart”

Box plot

Overview How to create a Box plot? Example Overview There is no dedicated chart type for classic Boxplot, but you can make something very similar with Category chart. Unfortunately, there is no possibility to show outliers. How to create a Box plot? Use Scalar analysis. Add Calculations: High, Low, Percentile 25, Percentile 75 and Median. … Continue reading “Box plot”

Graph layout

How to access? Adjusting graph Graph styles Alternate scale Order of series Deleting series Uniform pane size Margins How to show series on more than one chart? Adding/removing chart panes Adding series to Series list is first step. If Series list is like a basket, then Graph layout is command center for your chart. How … Continue reading “Graph layout”

Charting – overview

Point&click approach Various charts Working with chart Alternate scale Date range Annotations Graph layout Fill range Style of the chart When it comes to charting, two things are important to our users: the first is being able to clearly and persuasively present data, and the second is being able to create these presentations quickly. Some … Continue reading “Charting – overview”