General setting Language for automatic titles Time, Scatter & Category charts Bar & Pie charts General setting By default your charts is set to use your Windows’ language settings. You can change this under Presentation properties > Format > Language: Language for automatic titles This feature is available in Macrobond 1.29 and later. We have … Continue reading “Language on chart”
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”
Sometimes you want custom label on x-axis. You can this with a little workaround described below. Add Vertical line Go to Chart annotations > Annotations and add vertical line anywhere on the chart. Modify the line Click on this line and: Set Position (for Time chart – date, for Category chart – #0, #1, #2 … Continue reading “Workaround – Covering labels on x-axis”
This feature is available in Macrobond 1.28 and later. Overview Color and style settings Tooltip on charts on SVG files Overview This feature is available in Macrobond 1.28 and later. Tooltip appears when you hover over any point. They contain information about point-in-time, description, value and (optional) title. Color and style settings All the colors … Continue reading “Tooltip”
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”
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 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”
If you have ever seen Wingdings fonts you know that in text fields you can also add pictures/glyphs. In Macrobond files you can also copy-paste monochromatic Unicode symbols and pictograms. How to add a pictogram to chart? Find a webpage or even pdf file with Unicode pictograms. For example see UTF8icons.com or unicode.com charts section … Continue reading “Pictograms”
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”