Advanced Edition only

Area charts are useful when you want to show how something is changing and how much it is contributing to a total.

An Area chart can display a maximum of 10,000 data points (per facet, if Faceted). E.g. 10 Y columns x 1,000 rows or 1 Y column x 10,000 rows.

The series are drawn in left to right order of the Y axis columns. You can change the column order using a Reorder Cols transform before the chart.

Configure tab

The X axis data can be numeric or text. Set the As drop-down list depending on how you want X axis data to be interpreted:

•Automatic to intelligently work out if the X column data is numeric or text.

•Numeric to treat all the X column data as numeric values.

•Text to treat all the X column data as text/label/category values.

The Y axis data must be numeric. The Y axis columns are in order drawn left to right. So the data for a column can be obscured by data from columns to the right. You can change the column order using a Reorder Cols transform before the chart.

When numeric data is expected, any non-numeric data is ignored (including empty values). Numeric data is interpreted according to the selected Locale.

The Chart layout can be Grouped, Stacked or Faceted if you select multiple columns for Y axis data. It is generally not recommend to set Chart layout to Grouped, unless Opacity is less than 100%, as this may obscure some of the data.

General tab

Set the Theme drop-down to choose a palette of colors.

Set Text to modify the chart title text and visibility. If you set Title to Custom the column variables $(X) and $(Y) will be replaced with the names of the X and Y columns. This is particularly useful if you have multiple facets.

Set Legend to modify the legend position and visibility.

X Axis tab

Set Scale to choose a linear or logarithmic X axis. Only available if the X axis is numeric.

Set Minimum to:

•Automatic to set the X axis minimum based on the minimum X data value.

•Custom to set the X axis minimum manually.

Only available if the X axis is numeric.

Set Maximum to:

•Automatic to set the X axis maximum based on the maximum X data value.

•Custom to set the X axis maximum manually.

Only available if the X axis is numeric.

Check use 'nice' values to set X axis values to multiples of 1x10^n, 2x10^n and 5x10^n. May expand the range of the axis. Only available if the X axis is numeric and Scale is Linear.

Check show axis to show the X axis.

Check show grid to show X axis (vertical) grid lines. Only available if show axis is checked.

Check show labels to show X axis labels. If the values are text, the label text is interpreted as HTML.  Only available if show axis is checked.

Set Label format to set the format of numeric format of X axis labels:

•Automatic=set automatically

•e=exponent e.g.: 1.230e+06, Precision is the number of digits after the decimal point

•E=exponent, e.g.: 1.230E+06, Precision is the number of digits after the decimal point

•f=floating point, e.g.: 1230000.000, Precision is the number of digits after the decimal point

•g=most concise of e or f, Precision is the maximum number of significant digits (trailing zeros are omitted)

•G=most concise of E or f, Precision is the maximum number of significant digits (trailing zeros are omitted)

•i=integer, e.g. 1230000 (will truncate non-integer values)

Only available if the X axis is numeric.

Set Label angle to set angle of the X axis data labels in degrees (0=horizontal). Only available if show axis and show labels are checked.

Set Title to modify the X axis title text and visibility. If you set Title to Custom the column variable $(X) will be replaced with the name of the X column.

Y Axis tab

Set Scale to choose a linear or logarithmic Y axis.

Set Minimum to:

•Automatic to set the Y axis minimum based on the minimum Y data value.

•Custom to set the Y axis minimum manually.

Set Maximum to:

•Automatic to set the Y axis maximum based on the maximum Y data value.

•Custom to set the Y axis maximum manually.

Check same range all facets if you want every facet to have the same axis minimum and maximum, for easy comparison. Only available if Chart layout is Faceted and Minimum or Maximum is Automatic.

Check use 'nice' values to set Y axis values to multiples of 1x10^n, 2x10^n and 5x10^n. May expand the range of the axis. Only available if Scale is Linear.

Check show axis to show the Y axis.

Check show grid to show Y axis (horizontal) grid lines. Only available if show axis is checked.

Check show labels to show Y axis labels. Only available if show axis is checked.

Set Label angle to set angle of the Y axis data labels in degrees (0=horizontal). Only available if show axis and show labels are checked.

Set Label format to set the format of numeric format of Y axis labels:

•Automatic=set automatically

•e=exponent e.g.: 1.230e+06, Precision is the number of digits after the decimal point

•E=exponent, e.g.: 1.230E+06, Precision is the number of digits after the decimal point

•f=floating point, e.g.: 1230000.000, Precision is the number of digits after the decimal point

•g=most concise of e or f, Precision is the maximum number of significant digits (trailing zeros are omitted)

•G=most concise of E or f, Precision is the maximum number of significant digits (trailing zeros are omitted)

•i=integer, e.g. 1230000 (will truncate non-integer values)

Set Title to modify the Y axis title text and visibility. If you set Title to Custom the column variable $(Y) will be replaced with the name of the Y column(s).

Series tab

Set Opacity to change how opaque lines are (90% opacity = 10% transparency).

Output tab

See Chart data.