Calc:编辑图表

出自OOo 中文指南手册翻译

在创建一个图表之后，你可能会想改变其中的有些内容。通过插入和格式菜单、右击弹出式(上下文)菜单、和图表工具栏，Calc提供了工具用以改变图表类型、图表元素、数据范围、字体、颜色、以及许多其他的选择。 After you have created a chart, you may find things you would like to change. Calc provides tools for changing the chart type, chart elements, data ranges, fonts, colors, and many other options, through the Insert and Format menus, the right-click (context) menu, and the Chart toolbar. (1)

目录 1 更改图表类型 Changing the chart type (2) 2 添加或删除图表元素 Adding or removing chart elements (10) 2.1 数据标签 2.2 趋势线 Trend lines (43) 2.3 均值线 Mean value lines (56) 3 相关链接

[编辑] 更改图表类型 Changing the chart type (2)

您可以在任何时候更改图表类型。方法如下： You can change the chart type at any time. To do so: (3)

1. 首先双击图表选择它。图表现在应该被灰色的边界包围着。 First select the chart by double-clicking on it. The chart should now be surrounded by a gray border. (4)
2. 然后执行下列操作之一： Then do one of the following: (5)
   • 从菜单栏选择格式 > 图表类型。 Choose Format > Chart Type from the menu bar. (6)
   • 单击格式工具栏上的图表类型图标。 Click the chart type icon on the Formatting toolbar. (7)
   • 右键单击该图表，然后选择图表类型。 Right-click on the chart and choose Chart Type. (8)

在每种情况下，一个类似于选择图表类型中所示的对话框打开。 In each case, a dialog similar to the one in Choosing a chart type opens. (9)

[编辑] 添加或删除图表元素 Adding or removing chart elements (10)

下列图形显示了2D和3D图表的元素。 The figures below show the elements of 2D and 3D charts. (11)

默认的二维图只包括这些元素中的两个： The default 2D chart includes only two of these elements: (12)

• 图表背景墙包含显示数据的图表之图形。 Chart wall contains the graphic of the chart displaying the data. (13)

• 图表区是图表图形周围的区域。 图表标题（可选）和图例（图例项标）是在图表区。 Chart area is the area surrounding the chart graphic. The (optional) chart title and the legend (key) are in the chart area. (14)

默认的3D图表还包括图表基底，2D图表没有该元素。 The default 3D chart also has the chart floor, which is not available in 2D charts. (15)

使用插入菜单您可以添加其他元素。不同的选择打开相应的对话框，在其中您可以指定相关的细节。 You can add other elements using the Insert menu. The various choices open dialogs in which you can specify details. (18)

首先双击图表选择它。 First select the chart by double-clicking on it. (19)

标题、坐标轴、网格的对话框的内容，不言自明。其他则比较复杂一点，因此我们来看一看它们。 The dialogs for Title, Axes, Grids, and Legend are self-explanatory. The others are a bit more complicated, so we’ll take a look at them here. (21)

[编辑] 数据标签

数据标签，将每个数据点的信息放在图表上。他们对于提供详细资料是非常有用的，但你必须小心，不要让图表过于混乱而难以阅读。 Data labels put information about each data point on the chart. They can be very useful for presenting detailed information, but you need to be careful to not create a chart that is too cluttered to read. (23)

数据标签对话框上的选项如下。 The options on the Data Labels dialog are as follows. (25)

显示数字值 Show value as number (26)

显示数据点的数值。当选择此选项后数字格式按钮激活。 Displays the numeric values of the data points. When selected, this option activates the Number format button. (27)

数字格式 Number format (28)

打开数字格式对话框，在这里您可以选择数字格式。这个对话框与格式化单元格数字的对话框非常相似，见第2章所述（输入、编辑与格式化数据）。 Opens the Number Format dialog, where you can select the number format. This dialog is very similar to the one for formatting numbers in cells, described in Chapter 2 (Entering, Editing, and Formatting Data). (29)

显示百分比值 Show value as percentage (30)

显示每列中数据点的百分比值。当选择此选项后百分比格式按钮激活。 Displays the percentage value of the data points in each column. When selected, this option activates the Percentage format button. (31)

百分比格式 Percentage format (32)

打开数字格式对话框，在这里您可以选择百分比格式。 Opens the Number Format dialog, where you can select the percentage format. (33)

显示类别 Show category (34)

显示数据点的文字标签。 Shows the data point text labels. (35)

显示图例项标 Show legend key (36)

每个数据点标签的旁边显示图例图标。 Displays the legend icons next to each data point label. (37)

分隔符 Separator (38)

选择同一对象多个文本字符串之间的分隔符。 Selects the separator between multiple text strings for the same object. (39)

放置 Placement (40)

选择数据标签相对于对象的位置。 Selects the placement of data labels relative to the objects. (41)

本节显示了文本值（既不是选择显示数字值也不是选择显示百分比值）和百分比值的的例子，以及数据值用以替代图例或与之连接起来。 This section shows examples of values as text (neither Show value as number nor Show value as percentage selected) and values as percentages, as well as when data values are used as substitutes for legends or in conjunction with them. (42)

[编辑] 趋势线 Trend lines (43)

当在一个图中有分散的分组点，您可能希望显示点之间的关系。趋势线就是您需要的。Calc具有很好的您可以用于趋势线的回归类型的选择：线性、对数、指数和冪。选择趋势线最接近所有点的类型。 When you have a scattered grouping of points in a graph, you may want to show the relationship of the points. A trend line is what you need. Calc has a good selection of regression types you can use for trend lines: linear, logarithm, exponential, and power. Choose the type that comes closest to passing through all of the points. (44)

要为所有数据系列插入趋势线，双击图表进入编辑模式。选择插入 > 趋势线，然后选择趋势线的类型：无、线性、对数、指数、或幂。 To insert trend lines for all data series, double-click the chart to enter edit mode. Choose Insert > Trend Lines, then select the type of trend line from None, Linear, Logarithmic, Exponential, or Power. (45)

要为单个数据系列插入一个趋势线，在图表中选择数据系列，右击打开上下文菜单，并选择插入 > 趋势线。 To insert a trend line for a single data series, select the data series in the chart, right-click to open the context menu, and choose Insert > Trend Line. (46)

若要删除单个的趋势线或平均值线，单击该线，然后按删除键。 To delete a single trend line or mean value line, click the line, then press the Del key. (47)

要删除所有趋势线，选择插入 > 趋势线，然后选择无。 To delete all trend lines, choose Insert > Trend Lines, then select None. (48)

趋势线自动显示在图例中。 A trend line is shown in the legend automatically. (49)

如果您在一个使用类别的图表中插入类型趋势线，例如线条图或柱状图，那么数字1、2、3、...用作计算趋势线的x值。 If you insert a trend line on a chart type that uses categories, such as Line or Column, then the numbers 1, 2, 3, ... are used as x-values to calculate the trend line. (51)

趋势线与相应的数据系列具有相同的颜色。要更改线的属性，选择相应的趋势线，选择格式 > 对象属性 > 线。 The trend line has the same color as the corresponding data series. To change the line properties, select the trend line and choose Format > Object Properties > Line. (52)

要显示趋势线的方程，选择图表中的趋势线，右击打开上下文菜单，并选择插入趋势线方程。 To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose Insert Trend Line Equation. (53)

当图表处于编辑模式时，OpenOffice.org为您提供趋势线的方程和相关的系数。点击趋势线在状态栏中查看相关的信息。要显示方程和相关系数，选择相应的回归曲线，并选择格式 > 对象属性 > 方程。 When the chart is in edit mode, OpenOffice.org gives you the equation of the trend line and the correlation coefficient. Click on the trend line to see the information in the status bar. To show the equation and the correlation coefficient, select the regression curve and choose Format > Object Properties > Equation. (54)

欲了解回归方程的详细信息，见帮助文档主题图标趋势线。 For more detail on the regression equations, see the topic Trend lines in charts in the Help. (55)

[编辑] 均值线 Mean value lines (56)

如果您选择了平均值线，Calc计算出每个选定数据系列的平均值，并在图表中正确的位置绘制彩色的线。 If you select mean value lines, Calc calculates the average of each selected data series and places a colored line at the correct level in the chart. (57)

如果已知处理的数据有可能有误差，如使用特定的抽样方法进行的社会调查，或者您想显示您所用工具的测量精度，您可能希望在图表上显示误差线。 If you are presenting data which has a known possibility of error, such as social surveys using a particular sampling method, or you want to show the measuring accuracy of the tool you used, you may wish to show error bars on the chart. (59)

在Y误差线对话框中提供了几种选项。您只能一次选择一个选项。您还可以选择误差指示器同时显示正误差和负误差、或只显示正误差、或只显示负误差。 Several options are provided on the Y Error Bars dialog. You can only choose one option at a time. You can also choose whether the error indicator shows both positive and negative errors, or only positive or only negative. (60)

• 常数 - 你可以有分离的正值和负值。 Constant value – you can have separate positive and negative values. (62)
• 百分比 - 选择误差为数据点的百分比。 Percentage – choose the error as a percentage of the data points. (63)
• 在下拉列表中： In the drop-down list: (64)
  • 标准误差 Standard error (65)
  • 方差 - 显示的误差的计算基于最大和最小数据点的大小。 Variance – shows an error calculated on the size of the biggest and smallest data points. (66)
  • 标准偏差 - 所显示的误差的计算基于标准偏差。 Standard deviation – shows error calculated on standard deviation. (67)
  • 边际错误 - 您指定的错误 Error margin – you designate the error (68)
• 单元格区域 - 误差的计算基于选择的单元格区域。在该对话框底部的参数部分变为允许选择单元格区域。 Cell range – calculates the error based on cell ranges you select. The Parameters section at the bottom of the dialog changes to allow selection of the cell ranges. (69)

[编辑] 相关链接

本文原文