Dashboard can be created from Bar chart using combination of Text, Graph, Symbol columns and Rules applied to them.

How to create a Dashboard?

  1. Add series and perform calculations.
  2. Add Bar chart and open Graph layout (Ctrl+L).
  3. Arrange series the way you want. Each section in Graph layout is a new column:
    • Note that those transparent yellow and blue colors do not appear in the application.
  4. Rename columns and titles.
    • If you need to add a dynamic date - add to Series list: Month() and Year(), and as another Group in Cross sampling. When editing column's title use those series in i.e.,: Data for {s s7.Value}/{s s6.Value}.
  5. Add Rules - see Bar chart conditional formatting rules and the example below.
    • If you want to highlight whole column in one color - set rule that will always be true, for example 'Greater than -1' (for a series that cannot go below 0).
  6. Set width for each section - click on a cell in column and go to Column properties > Column.
    • Note that this is made for 'Expanding' mode. You can change the mode under Chart properties > Width
  7. Add separator between sections - click on a column and go to Column properties > Separator left/right, select Color and Width.
  8. Add general border - go to Graph area properties > Border, select Color and Width.
  9. Add notes - go to Chart properties > Notes, select one of them and type in text. 


Dashboard - Tourists expenditures

In this example we compare average expenditures from past years to latest month values.

Dashboard - Land use

In this example we compare land area (forest and agricultural) of different countries.