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 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 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”
Purpose Creating calculated in-house Adding calculated in-house to a chart Sharing calculated in-house Editing calculated in-house Adding another calculated in-house in same file Changing calculated in-house’s location Deleting calculated in-house Questions Can I connect my calculated in-house series to original file? Can i download in-house series through other Macrobond API (i.e., Python)? Why can’t I … Continue reading “Calculated in-house series – saving your own calculation”
Overview How to create a category scatter chart? Settings Graph settings Graph layout Chart settings What analyses work with this chart type? Examples Questions How to change connected line to dots? How to highlight an observation? How to show only one date/value in label? For elements not mentioned here see Elements of the chart. Overview … Continue reading “Category scatter chart”
Overview Settings Properties for Table Table layout Additional options Copying the data What analyses work with this chart type? Example Overview When you want to take a close look at individual values in your data, you can view your series in a table. When the series you’re viewing are category series, this will be a … Continue reading “Category table”
Overview How to create a category chart? Settings Category axis settings Value axis settings Chart settings What analyses work with this chart type? Example For elements not mentioned here see Elements of the chart. Overview A Category chart displays category series in columns, which are usually created by analyses such as Cross sampling, Scalar and … Continue reading “Category chart”