Heatmap

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”

Dynamic table

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”

Chart view size

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”

Border, Grid & Margin

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”

Graph layout

These types of charts work both with analyses which use time series and the ones using category series.

Legend

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”

Labels

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”

Bar chart

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”