Certain analyses produce category series – which by design do not keep any time parameters. With below workaround you can pass time information through analyses and show it in Bar chart. Add formulas We have formulas which output time parameters, add needed ones to Series list: week() month() quarter() year() From their output you will … Continue reading “Workaround – Dynamic dates in 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”
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”
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”
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”
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”
Macrobond R API is available for users with Data+ and Legacy license (the latter without searching and revision history functions). Examples were tested on Macrobond version 1.28, Macrobond API for R version 1.2-8 and R 4.4.0. The first method uses ‘search by concept’ to find whole data set based on one series. Example is presented … Continue reading “Circular bar chart (incl. automated search)”
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”
Overview How to create a heatmap? Shortcut from panel from panel Build it Choosing color ranges Two colors Three colors Applying rules to chart Multiple rules Value series Using other series for formatting Examples Questions Can I format within a row instead of a column? Overview You can create a Heatmap by modifying Bar chart … Continue reading “Heatmap”