A chart is a graphical representation of data that makes it easier to understand and analyze. The chart widget allows you to present data from a database or spreadsheet in graphical form.
General properties of charts
Properties of charts
Chart subtype - specifies a particular type of chart that affects how the data is presented.
Chart title - the title that will be displayed above the chart
Stacking - series of data are displayed one above the other, instead of overlapping. For a more detailed discussion of this property, see the articles on layered charts and progression.
Inverted - the option changes the layout of the chart, the X axis becomes vertical and the Y axis becomes horizontal.
X axis title - the name the X axis will have.
Axis type:
- Linear - units are equally spaced
- Logarithmic - values increase exponentially, that is, each successive unit is a multiple of the previous one
- Categories - text labels are displayed instead of numbers
Axis parts: elements of the axis that will be visible on the axis:
- None - the axis is not visible
- Units - only unit values are displayed
- Units and axis line - both units and the axis itself are visible
- Units and grid lines - in addition to units, gridlines are displayed to make it easier to read the data
- Units, axis and grid lines - full set of axis elements
Min - the lower limit of the X axis. If it is not specified, the system will automatically adjust it to the smallest data value on the chart.
Max - the upper limit of the X axis. If not specified, it will be automatically adjusted to the largest value of data on the chart.
Step - determines the distance between successive units on the axis. If the spacing is too small and the values do not fit on the chart, it can be skipped.
Categories - are labels displayed as units on the X axis. The data are arranged according to their order. If a point does not fit into any category, it will be placed at the end of the chart.
Y axis title - the name that the Y axis will have.
Axis type:
- Linear - units are equally spaced
- Logarithmic - values increase exponentially, that is, each successive unit is a multiple of the previous one
Axis parts: elements of the axis that will be visible on the axis:
- None - the axis is not visible
- Units - only unit values are displayed
- Units and axis line - both units and the axis itself are visible
- Units and grid lines - in addition to units, gridlines are displayed to make it easier to read the data
- Units, axis and grid lines - full set of axis elements
Min - the lower limit of the Y axis. If it is not specified, the system will automatically adjust it to the smallest data value on the chart.
Max - the upper limit of the Y axis. If not specified, it will be automatically adjusted to the largest value of data on the chart.
Step - determines the distance between successive units on the axis. If the spacing is too small and the values do not fit on the chart, it can be skipped.
Legend - determines the position of the chart description:
- Bottom
- Left
- Right
- None
Separate colors in series - allows you to define a different color for each point in the series
Bar overlapping - determines how bars from different series that have compatible X values are arranged relative to each other. For a more detailed discussion of this property, see the articles on bar charts.
Initial sum - the value of the sum column, displayed before the first series of the cascade chart. For a more detailed discussion of this property, see the articles on waterfall charts.
Band 1 - the upper limit of the first interval on the chart. A more detailed discussion of this property can be found in the article - bullet chart.
Band 2 - the upper limit of the second interval on the chart. A more detailed discussion of this property can be found in the article - bullet chart.
Data series
Name - the name displayed in the legend and in the labels that appear when you hover over a point on the chart.
Data - if the data comes from an external table or list, use a lookup formula to get the correct records. If the data is typed directly into the field or given as a cell address, you can leave the field empty.
X - if the data is retrieved using the lookup function, indicate the column from the associated record. Otherwise, you can specify a range of cells or an array of values. If X values are not specified, the points on the X axis will be assigned to consecutive natural numbers or categories.
Y - if the data is retrieved using the lookup function, specify a column from the associated record. Otherwise, you can specify a range of cells or an array of values.
Y2 -the second Y axis displayed on the right side of the graph
Z - for bubble charts, the Z parameter specifies the size of the bubble. You can read more about this parameter in the point chart article.
Data bullet - determines the shape of the points on the chart.
Data labels - labels that help the user read the values on the chart:
- Tooltip - When you hover over a point on the axis, its value will be displayed
- Fixed - values are displayed directly on the chart
- None - labels will not be displayed
Show sum - an additional column that displays the sum of the values in the series. For a more detailed discussion of this property, see the article - waterfall chart.
Target - the position of the marker marked on the chart. A more detailed discussion of this property can be found in the article - progress chart.
Styles
Section
- You can select a style from a list or specify it using a formula.
- You can give a background color to the chart section
- You can add a section border by defining its parameters for the top, bottom, left and right edges
- You can customize the section shadow by selecting its color
Contents
- You can select a style from a list or specify it using a formula.
- You can add rounding of the edges of the chart content
- Give the background color of the chart content
Chart title
- You can select a style from a list or specify it using a formula.
- Specify the style from the formatting bar, including: assigning font, font size, text color, bold, italic, underline, and strikethrough.
Axes (titles)
- You can select a style from a list or specify it using a formula.
- Specify the style from the formatting bar, including: assigning font, font size, text color, bold, italic, underline and strike-through.
Axes (values)
- You can select a style from a list or specify it using a formula.
- Specify the style from the formatting bar, including: assigning font, font size, text color, bold, italic, underline and strike-through.
Grid
- You can select a style from a list or specify it using a formula.
- You can also assign a color to the grid.
There is an icon next to each style property:
- reset the set style
- save the selected style
Note: Depending on the type of chart, some properties may vary. For more information, please refer to the corresponding article
0 Comments