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”
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”
Overview Settings Changing default settings Graph layout Graph properties Style sheet Examples Overview Symbol charts in a form of mini pie charts are a feature available within Bar chart. They are designed to show the proportions of two series or magnitude of one value on a scale 0-100. Settings When you click on any element … Continue reading “Symbol chart from bar chart (mini pie charts)”
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”
Overview How to create a Fed dot plot? Examples Overview There is no dedicated chart type for this, but it’s possible to use Time chart with a bit of formulas and get a proper Fed dot plot. How to create a Fed dot plot? Set whole chart to Weekly frequency. Add on Series list: All … Continue reading “Fed dot plot / FOMC policy dot plot”
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”
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”
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”
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”