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 Example 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”
Editing labels & Dynamic text Observation labels Settings Label’s style Anchor Background & Border Range How to add an observation label? How to add observation labels to other points? How to add observation labels to all points? Highlighting multiple values and series Axis value labels Horizontal axis value labels Vertical axis value labels Legend labels How to … Continue reading “Labels”
Overview Settings Changing default settings Graph layout Graph style Chart size Width Height Text columns Graph columns Symbol columns Legend Conditional formatting Style sheets What analyses work with this chart type? 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 … Continue reading “Bar chart”