Chart Type Column and Line

Pirmajā Diagrammu vedņa lappusē jūs varat izvēlēties diagrammas tipu.

Lai piekļūtu Ŕai komandai...

Choose Insert - Chart...

Icon

Insert Chart


Kolonnu un līniju

A Column and Line chart is a combination of a Column chart with a Line chart.

Select one of the variants

You can insert a second y-axis with Insert - Axes after you finish the wizard.

To specify a data range

The leftmost columns (or the top rows) of the selected data range provide the data that are shown as Columns objects. The other columns or rows of the data range provide the data for the Lines objects. You can change this assignment in the Data Series dialog.

  1. Atlasiet datu diapazonu.

  2. Click one of the options for data series in rows or in columns.

  3. Check whether the data range has labels in the first row or in the first column or both.

Datu sēriju organizÄ“Å”ana

In the Data Series list box you see a list of all data series in the current chart.

The column data series are positioned at the top of the list, the line data series at the bottom of the list.

Datu sēriju rediģēŔana

  1. Click an entry in the list to view and edit the properties for that entry.

    In the Data Ranges list box you see the role names and cell ranges of the data series components.

  2. Click an entry, then edit the contents in the text box below.

    The label next to the text box states the currently selected role.

  3. Enter the range or click Select data range to minimize the dialog and select the range with the mouse.

The range for a data role, like Y-Values, must not include a label cell.

Editing categories or data labels

The values in the Categories range will be shown as labels on the x axis.

Diagrammu elementu ievietoŔana

Use the Chart Elements page of the Chart Wizard to insert any of the following elements:

For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements:

To set different data labels for each data series, use the properties dialog of the data series.

Please support us!