Overview What this type of chart needs? How Graph layout works? Example For elements not mentioned here see Elements of the chart. Overview Line chart is the default type of graph which is displayed in all Macrobond documents. It shows data points connected with a continuous line. It is possible to turn on Markers and … Continue reading “Line chart”
Overview Column Stacked column What this type of chart needs? How Graph layout works? Example For elements not mentioned here see Elements of the chart. Overview Column and Stacked column charts display data as vertical bars. Categories are applied depending on analysis used before. In most cases output can be a time series but after … Continue reading “Column & Stacked column 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”
How to create a dynamic table? Shortcut from panel Build it How to copy a dynamic table? Example You can create tables as reports, using Bar Charts presentations. The table is created using a bar chart with text columns. Below is an example of what the end result might look like. How to create a … Continue reading “Dynamic table”
How to: set custom size to a chart? Size settings after version 1.29 change unit in Chart view size? save custom size for future use? set size for Style sheet? How to set custom size to a chart? Select a chart and open the Chart view size tab in the command bar. Tick the ‘Fixed … Continue reading “Chart view size”
How to: remove the borders from a chart? remove the grid lines from a chart? remove the margin around a chart? How to remove the borders from a chart? Click the background of the graph area. In the Border group under the Presentation properties tab, you can adjust settings for the chart border. To remove the border, set the width … Continue reading “Border, Grid & Margin”
It is possible to edit almost any text in Macrobond, to do this you need to double-click on an element you want to edit. How to: edit the title of chart? edit the source text on a chart? How to edit the title of chart? There are two main ways to add title for chart/graph: … Continue reading “Editing text parts of chart”
These types of charts work both with analyses which use time series and the ones using category series.
Overview Adding Rules Rules settings Range Condition Rank Average Examples Overview Conditional formatting is used to set colors and text properties based on the values defined by a set of rules. This can be used to create Heatmaps, show negative values, highlight largest smallest value and outliers. Adding Rules You set up rules in the … Continue reading “Bar chart conditional formatting rules”
Settings Graphics Removing second (forecast) line Changing length of line or sample size Text Editing the text Editing / removing ‘lhs’ and ‘rhs’ Hiding all legend’s texts Hiding a particular legend’s text Hiding analysis texts Hiding list descriptions Legend Changing position Reversing the order Legend text per chart pane The legend lists which series were … Continue reading “Legend”