Source Data

Select the sheet with source data in the drop-down list.

Specify the cell range that contains chart data.

A cell range may be set as a combined or rectangular area. When several ranges are used, chart series are displayed in the order of ranges selection.

Specify the cell range that contains series names. The specified names appear in the legend. If the range of names is set as an open range (entire column or row), the value of the cell located at intersection of the data range and the series names range is used as the series name. If multiple ranges are used to build a chart, the ranges of series names should be specified in the same order as the data selection.

NOTE. For waterfall charts, the legend displays predefined names: Increase, Decrease, and Totals.

On setting a cell range with legend entries (series), consider the following:

• Chart legend is not shown if at least one value is omitted in the specified range of series names.

Specify the cell range that contains point names. The specified names will be displayed on horizontal chart axis if there is any. If a names range is specified as an open range (entire column or row), the value of the cell located at the intersection of data range and point names range is selected as a point name.

When setting a cell range with point names, consider the following:

• Point label is not shown in the chart if the corresponding cell in the point names range does not contain any value (is empty).

• When waterfall chart is used, the Point Names box is used to specify the columns that are located on the category axis (X).

To set up displaying of point labels, click the Set Up button. The Show Labels panel opens:

NOTE. The Set Up button is available if the Point Names invalid cell range is entered.

The list on the panel contains point names accounting for the parameters specified in the Source Data group of parameters.

Select point names, which must be displayed on the category axis. To select all, click the Select All button, after which the button becomes selected. To deselect all, deselect the Select All button.

One can set up tooltips and data labels for selected point names.

To quickly search for a point, enter part of its name or a full name to the search string at the top of the Show Labels panel.

Select a slice to use as the chart data source in the drop-down list.

Indicate how to interpret numeric series for the specified data area.

Select the Series In Rows checkbox for creation of value array for data series on the chart by rows. On deselecting the checkbox, an array is created from values by columns.

For example, let us plot a chart to illustrate the use of the Series in Rows checkbox. As a data source use Volume of Production by Regions, mln. RUB:

Histogram appearance if series are located in rows:

Histogram appearance if series are located in columns:

When the Show Hidden Data checkbox is selected, the chart can show all data area values, including data contained in hidden rows or columns and data of the rows or columns with zero height or width. If the checkbox is deselected, the chart is built using only the visible part of the data area. The checkbox is selected by default. The checkbox is not available if a slice is used as the chart source.

Below is the example of a data area chart with some of the rows hidden with the checkbox selected (left) and deselected (right):

If the Substitute Empty Values with Zeros checkbox is selected, empty values are automatically substituted with zeros. If the checkbox is deselected, the intervals containing empty values are displayed as a dashed line and connect two nearest present values.