Category: Charting
Fed dot plot / FOMC policy dot plot
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”
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”
Pyramid/Demography bar chart
Overview How to create a simple pyramid chart? Finding data Which analysis can I use? Displaying age pyramid Examples Questions How to adjust the gap between bars? How to change size of bar/glyph? How to edit the formatting of all the values in a text column at the same time? Overview You can create Age … Continue reading “Pyramid/Demography bar chart”
Opening charts in a separate window
This lifehack can be used to see analysis and chart side-by-side when changing settings. In the command bar of the application, you’ll see a button with a P on it – this allows you to present charts in a separate window. Besides being the first step in compiling a presentation of charts there are two … Continue reading “Opening charts in a separate window”
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”