Slope chart

Overview How to create a Slope chart? Cleaning graphical elements Adding value labels on chart Example Overview There is no dedicated chart type for Slope charts. However, with Scalar/Cross sampling analyses you can create slopes out of Category chart. How to create a Slope chart? Use Scalar (or Cross sampling) with ‘Calculations: Value at’ for … Continue reading “Slope chart”

Pie chart

Overview Settings Changing default settings Chart properties Start angle Radius Offset Units Slice defaults Slice properties Label properties Inside Outside Main title properties / Legend properties Graph layout Style sheets What analyses work with this chart type? Examples Overview The Pie chart lets you display category series. It can be added only after analyses which … Continue reading “Pie chart”

Lollipop chart from bar chart

Overview How to create a lollipop chart? Example Overview You can create lollipop chart by modifying Bar chart. How to create a lollipop chart? Open Graph layout (Ctrl+L). Under ‘Bar’ leave one series. In the left panel select that series and from above choose ‘Marker’. Close Graph layout. Click on one of the bars and … Continue reading “Lollipop chart from bar chart”

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”