Animated charts

This feature was first introduced in Macrobond 1.28 and later. Major improvements were added in 1.29. Overview How to create animated charts? Preview on chart Elements of animation Animation formats How to show it to others? Copy special (SVG) File > Export image or video (SVG, GIF, MP4) LinkedIn Animation in version 1.28 Style sheet … Continue reading “Animated charts”

Radial bar chart

Overview How to create a Radial bar chart? Examples Overview There is no dedicated chart type but with formulas and Cross sampling you can create one with Category Scatter chart. How to create a Radial bar chart? Prepare series. Prepare position’s values – in Formula analysis use a hundred series of each of below formulas … Continue reading “Radial bar chart”

Distribution stack chart

Overview How to create a Distribution stack chart? Examples Overview Dates are represented by cells stacked on each other which create a distribution chart. Whole chart can be then colored by specific rules. How to create a Distribution stack chart? Add Formula analysis: Create brackets with if() formulas e.g.; if(fx:s1<0, year(), null()) if(fx:s1>=0 & fx:s1<20, … Continue reading “Distribution stack chart”

Radar chart/Spider chart

Overview How to create a Radar chart? Adding more lines Examples Overview There is no dedicated chart type but with formulas and Cross sampling you can create one with Category Scatter chart. How to create a Radar chart? Prepare series – one of the methods would be to use  PercentRank(series1, series1) formulas: PercentRank() returns the … Continue reading “Radar chart/Spider chart”

Dashboard

Overview How to create a Dashboard? Examples Overview Dashboard can be created from Bar chart using combination of Text, Graph, Symbol columns and Rules applied to them. How to create a Dashboard? Add series and perform calculations. Add Bar chart and open Graph layout (Ctrl+L). Arrange series the way you want. Each section in Graph … Continue reading “Dashboard”

Bubbles on string chart

Overview How to create Bubbles on string chart? Example Overview Bubble chart can be also modified for specific use, for example when you want to compare series showing values as weights. How to create Bubbles on string chart? Add series on a List. Perform calculations and/or analyses. Add Formula analysis with values from 1 to … Continue reading “Bubbles on string chart”

Quadrant chart

Overview How to create a Quadrant chart? Setting background colors Examples Overview Shaded Quadrant chart is helpful when you want to show in an instance positions or proportions of points in each arbitrary fixed quadrant. How to create a Quadrant chart? Add series and perform needed analyses. Add Scatter chart or Category scatter chart. On … Continue reading “Quadrant chart”

Fan chart

Overview How to create a Fan chart? Examples Overview Using Forecast analysis on multiple same series you can create a Fan chart from Time chart and show uncertainty associated with forecasts. How to create a Fan chart? Add same series on Series list – as many times as you have predicted variants – plus one … Continue reading “Fan chart”

Dumbbell chart

Overview How to create a Dumbbell chart? Adjusting chart elements Background graphic elements Examples Overview There is no dedicated chart type for Dumbbell charts. However, with Scalar/Cross sampling analyses  you can create it out of Bar chart. How to create a Dumbbell chart? Use Scalar (or Cross sampling) with ‘Calculations: Value at’ for two points in time. Add … Continue reading “Dumbbell chart”