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
Style - Diagram
New styles section available since version 2.2
Section:
- We can choose a style from the list or specify it using a formula.
- Border settings:
- Using the border options, we can set its parameters (top, bottom, left, and right) by selecting the appropriate color and rounded edges.
- Adding section shadow:
- By adding a shadow to the section, we have the option to adjust its color
- By adding a shadow to the section, we have the option to adjust its color
- Content:
- We can choose a style for the chart content from the list of styles or calculate it using formulas. Additionally, we can assign a color to the content, set borders, and save the style.
- Title:
- We can assign a selected style from the list to the chart name or calculate it using formulas. There is an option to set the style from the formatting bar and save the selected style.
- Axes (Values):
- Style options can be specified similarly to the chart name.
- Axes (titles):
- Style options can be specified similarly to the chart name.
- Legend:
- Style options can be specified similarly to the chart name.
Next to each style property, there is an icon thet allows you to:
- reset the applied style
-save the selected style
0 Comments