Диаграммы
To add a chart, use the Вставка Диаграмма menu option to add a new chart sheet. Then use the Формат Диаграмма menu option to display the dialog box that contains the following formatting options:
ТипThe program currently supports the following chart types:
| Гистограмма | Displays vertical columns whose heights correspond to the data values. |
| Линейчатая диаграмма | Displays horizontal bars whose lengths correspond to the data values. |
| График | Displays a line through points whose vertical positions correspond to the data values, the horizontal positions are evenly spaced. |
| Круговая диаграмма | Displays a circle divided up into regions whose relative sizes correspond to the data values. |
| Кольцевая | Like the Круговая chart but displays one or more series. |
| Точечная диаграмма | Displays a line through points whose x and y coordinates are given by the data values. |
| Диаграмма с областями | Like the line chart, but the area below the line is filled in, and the series values are stacked. |
| Лепестковая | Displays a line through points whose distances from a central point correspond to the data values. |
This allows you to specify the data values to be used for each series. To add a new series, press the Создать... button. To change an existing series, select it in the list box and then press the Правка... button. To remove an existing series, select it in the list box and press the Удалить button.
Note that for Круговая диаграмма charts, only the first series will be displayed.
When entering or changing a series, you are prompted for the following information:
| Данные | Имя | An optional name that is used to identify the series in the list box. It defaults to 'Series1', etc. |
| Значения Y | A reference to the cells that contain the data to be charted. You can specify more than one reference, separating them with commas, but they must all be from the same sheet. Alternatively you can specify this as an array of values. | |
| Метки по X | For Гистограмма, Линейчатая диаграмма, Круговая диаграмма, График and Диаграмма с областями charts, you can specify a reference or array of values that will be used to label the categories. As there is only one set of labels, this must be the same for all the series on one chart. For Точечная диаграмма charts, this item is labelled Значения X and you must enter a reference or array of values to be used as the x co-ordinates of the line. | |
| Узоры | Тип линии | Allows you to choose a solid, dashed or dotted line. |
| Цвет линии | Allows you to specify the color of the line. | |
| Маркер | For График, Точечная диаграмма and Лепестковая charts, allows you to choose a marker for the data points. | |
| Цвет маркер | For График, Точечная диаграмма and Лепестковая charts, allows you to choose the foreground and background colors for the marker. | |
| Цвет фона | For Гистограмма, Линейчатая диаграмма, Круговая диаграмма, Кольцевая and Диаграмма с областями charts, allows you to specify the colour that will be used to fill the interior. | |
| Подписи | Тип подписи | Allows you to display the x or y values next to the data points, and for Круговая диаграмма and Кольцевая charts the percentages. |
This allows you to specify the titles that will be used to label the chart itself and the x and y axes. Note that axis titles do not apply to Круговая диаграмма charts.
This allows you to specify the formatting of the x and y axes. The actual options that are available will depend on the currently selected chart type.
| Ось | Specifies whether the axis line will be drawn. |
| Сетка: | Specifies whether the guidelines will be drawn. |
| Деления | Specifies whether the axis tick marks will be drawn. |
| Значения | Specifies whether the axis values will be displayed. |
| Логарифмическая | Specifies whether a linear or logarithmic scale is required. |
| Минимум | Specifies the minimum value to be used on the scale. |
| Максимум | Specifies the maximum value to be used on the scale. |
| Шаг | Specifies the interval between the values on the scale. |
This allows you to specify the whether and where to display the names that identify each series with its line and/or area color. For Pie charts, the information displayed will be the category names (from the 'X labels' entry in the series formatting dialog box), for other chart types it will be the Series names from the chart series list box.