Category: Workarounds

Lollipop chart

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?

  1. Use Scalar to perform calculations. If needed, add Sorting analysis too.
  2. Add Cross section analysis and sum series, uncheck first 2 boxes ('Include only observations...' and 'Do not include series...') - this will be needed to create lollipop.
  3. Add Arithmetic analysis and subtract 'Sum series' from itself. It will create placeholder for 0.
  4. Add Category chart. Open Graph layout (Ctrl+L) and add:
    • 'Last data set' under Column graph type
    • three data sets ('Sum series' and two '-1y series') under Open-high-low-close. It will create lollipop's stick
    • '-1y data set' under Line graph type, turn it into dot marker.

Example

Lollipop chart

In this example we calculated YoY and showed current values as columns and the one year ago values as lollipops.

Box plot

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?

  1. Use Scalar analysis.
  2. Add Calculations: High, Low, Percentile 25, Percentile 75 and Median.
  3. Add, Category chart, open Graph layout (Ctrl+L).
  4. Under Candlestick graph type add series for: Low, 25% Percentile, 75% Percentile, High (in this order).
  5. Under Line graph type add series for Median (and if you want, Last) and change them to markers.

Example

Box plot

In this example w have used GDP YoY series and calculated parameters in Scalar over the last 10-year period.