Diagram widget - allows you to present data from spreadsheets, from database, and static data in the form of graphical diagrams.

Diagrams are highly customizable, almost all options can be set as formulas.

Diagram customization options:

- Diagram title - main diagram title - optional
- X axis and Y axis (1, 2 on screenshot)
- Title - axis title, optional
- Min - axis min value, if left empty will be set automatically
- Max - axis max value, if left empty will be set automatically
- Step - axis step value, if left empty will be set automatically
- Categories - axis categories. If categories are present for the axis, names are used instead of numbers for that axis (for example, instead numbers from 1 to 12, you can use January - December)

- Series - one or more series can be presented on diagram (3 on screenshot)
- Name - series name, name of series is displayed below a diagram, series can be toggled by clicking on series name
- Data formula - formula that returns series data values
- Series type - series type, currently following series type are available:
**line**,**spline**,**area**,**areaspline**,**bar**,**column**,**pie**,**scatter**,**gauge** - Split data - splits array series to multiple scalar series
- Color - defines color of series, color name and RGB code are supported (for example: red, blue, #12FF12)

Series **Data formula** - series accepts: scalar, array of numbers, array of numbers with categories (result of lookup)

Data formula examples:

=15 - scalar

=MAX(section1.B) - max value from column B in Table section

=section1.B - array of values, column B in Table section

=section1.A1:A17 - array of values, range of cells from spreadsheet section

=lookup(PRODUCT, price) - array of prices from all products

=lookup(PRODUCT, MAX(price)) - scalar max price from all products

=lookup(PRODUCT, price > 100 and country = ‘USA’, price) - array of prices from all products that meet query

=lookup(PRODUCT, name, price) - array of prices and names from all products, names will be used as categories

=lookup(PRODUCT, country, MAX(price)) - array of MAX prices per country and country from all products, names will be used as categories

*Diagram definition*

*Diagram made from this definition*

## 0 Comments