Calc:创建图表

出自OOo 中文指南手册翻译

目录 1 选择图表类型 Choosing a chart type (12) 2 改变数据范围和坐标轴标签 Changing data ranges and axes labels (20) 3 选择数据系列 Selecting data series (27) 4 添加或更改标题、图例和网格 Adding or changing titles, legend, and grids (34) 5 相关链接

为了演示Calc中制作图表和图形的过程，我们将使用下面的小数据表。 To demonstrate the process of making charts and graphs in Calc, we will use the small table of data below. (1)

要创建图表，首先突显（选中）将要包括在图表中的数据。选中的内容并不需要在一个块中，如下图所示。您也可以选择单个的单元格或单元格组（列或行）。见第1章（Calc介绍）有关选择单元格和单元格区域的更多信息。 To create a chart, first highlight (select) the data to be included in the chart. The selection does not need to be in a single block, as shown below; you can also choose individual cells or groups of cells (columns or rows). See Chapter 1 (Introducing Calc) for more about selecting cells and ranges of cells. (3)

接下来，使用下面两种方法之一打开图表向导对话框。 Next, open the Chart Wizard dialog using one of two methods. (5)

• 从菜单栏选择插入 > 图表。 Select Insert > Chart from the menu bar. (6)

• 或者点击工具栏上的图表图标。 Or, click the Chart icon on the main toolbar.

每种方法都在工作表中插入一个示例图表、打开格式工具栏、并打开图表向导，如下面一节中所示。 Either method inserts a sample chart on the worksheet, opens the Formatting toolbar, and opens the Chart Wizard, as shown in the section below. (10)

[编辑] 选择图表类型 Choosing a chart type (12)

图表向导包括一个使用你所工作的数据的示例图表。此示例图表及时更新以反映您在图表向导中进行的更改。 The Chart Wizard includes a sample chart with your data all ready to work with. This sample chart updates to reflect the changes you make in the Chart Wizard. (13)

图表向导有三个主要部分：建立图表所需的步骤列表、图表类型的列表、以及每个图表类型的选项。任何时候，你都可以回到上一步，改变选择。 The Chart Wizard has three main parts: a list of the steps involved in setting up the chart, the list of chart types, and the options for each chart type. At any time you can go back to a previous step and change selections. (14)

Calc提供了9种基本图表类型，每个图表类型有几种选择，结合起来可以有多达30种图表选择。不同的图表类型有其自己的一套适当的选项。 Calc offers a choice of 9 basic chart types, with a few options for each type of chart, giving you a choice of up to 30 charts. Different chart types have their own set of appropriate options. (15)

选择的第一个层次是二维（2D）图表，以及那些只适合3D（柱状图、棒图、饼图和区域）、给你一个三维外观的选项选择。 The first tier of choice is for two-dimensional (2D) charts, with only those types which are suitable for 3D (Column, Bar, Pie, and Area) giving you an option to select a 3D look. (16)

在图表类型选择页，点击其图标选择其中之一。每次您选择不同类型的图表时预览自动更新，提供一个最终图表的大致样子。 On the Choose a chart type page, select one by clicking on its icon. The preview updates every time you select a different type of chart, and provides a good idea of what the finished chart will look like. (17)

在选择图表类型页，目前的选择是突出显示的（周围显示边框）。图表的名称显示图标的下方。目前，我们将使用柱形图，再次点击下一步。 The current selection is highlighted (shown with a surrounding box) on the Choose a chart type page. The chart’s name is shown just below the icons. For the moment, we will stick with the Column chart and click on Next again. (18)

[编辑] 改变数据范围和坐标轴标签 Changing data ranges and axes labels (20)

第2步是数据范围，您可以手动纠正数据选择的错误。 In Step 2, Data Range, you can manually correct any mistakes you have made in selecting the data. (21)

在此页面您也可以改变正在绘制的图表使用行数据，而非列数据为数据系列。如果您使用诸如圆环图或饼图来显示您的数据，这是有用的。 On this page you can also change the way you are plotting the data by using the rows—rather than the columns—as data series. This is useful if you use a style of chart such as Donut or Pie to display your data. (22)

最后，您可以选择是否使用第一行或第一列，或两者兼选，作为图表的坐标轴标签。 Lastly, you can choose whether to use the first row or first column, or both, as labels on the axes of the chart. (23)

您可以点击完成按钮，接受迄今所进行的设置，或单击下一步继续改变图表的一些细节。 You can accept what you have done so far by clicking the Finish button, or click Next to change some more details of the chart. (24)

我们会按下一步，看看使用图表向导的其他页，我们能对图标再做些什么设置。 We will click Next to see what we can do to our chart using the other pages of the Wizard. (25)

[编辑] 选择数据系列 Selecting data series (27)

在数据系列页上，您可以微调要包含在图表中的数据。也许你已经决定，不希望包括独木舟的数据。如果是这样，在数据系列框中突出显示独木舟然后点击删除。每个命名的数据系列有其范围和单独的y坐标数值列表。如果你对图表中的数据有非常特定的要求，这是有用的，您可以包括或剔除这些区域。 On the Data Series page, you can fine tune the data that you want to include in the chart. Perhaps you have decided that you do not want to include the data for canoes. If so, highlight Canoes in the Data series box and click on Remove. Each named data series has its ranges and its individual Y-values listed. This is useful if you have very specific requirements for data in your chart, as you can include or leave out these ranges. (28)

另一种用来绘制没有连接起来的任意数据列的方法，是选择第一个数据系列，然后按住Ctrl键选择下一系列。或者您可以在文本框中输入数据列。这些列之间必须用分号隔开。因此，为了绘制B3:B11'和 G3：G11 的图表,输入选择范围：B3:B11;G3:G11。 Another way to plot any unconnected columns of data is to select the first data series and then select the next series while holding down the Ctrl key. Or you can type the columns in the text boxes. The columns must be separated by semi-colons. Thus, to plot B3:B11 against G3:G11, type the selection range as B3:B11;G3:G11. (31)

您选择的两个数据系列，必须位于独立的列或行中。否则，Calc将假定您添加的是相同的数据系列。 The two data series you are selecting must be in separate columns or rows. Otherwise Calc will assume that you are adding to the same data series. (32)

点击下一步处理标题、网格、和图例。 Click Next to deal with titles, grids, and legends. (33)

[编辑] 添加或更改标题、图例和网格 Adding or changing titles, legend, and grids (34)

在图表元素页面，您可以给您的图表添加标题，以及如果需要的话，添加一个副标题。使用标题，吸引读者注意到图表的宗旨：你希望他们看到什么。例如，这个图表的比较好的标题可能是'汽车和其他租用船只的性能。 On the Chart Elements page, you can give your chart a title and, if desired, a subtitle. Use a title that draws the viewers’ attention to the purpose of the chart: what you want them to see. For example, a better title for this chart might be The Performance of Motor and Other Rental Boats. (35)

为X轴或Y轴添加标签可能是有益的。这是给人们关于数据比例的信息。例如，如果我们在我们的图表中Y轴标签以千计，它完全改变图表的范围。为了便于估计数据，通过选择显示网格选项，您还可以显示X或Y轴的网格。 It may be of benefit to have labels for the x axis or the y axis. This is where you give people an idea as to the proportion of your data. For example, if we put Thousands in the y axis label of our graph, it changes the scope of the chart entirely. For ease of estimating data you can also display the x or y axis grids by selecting the Display grids options. (36)

您可以不要图例或者将它包含在左侧、右侧、顶部或底部。 You can leave out the legend or include it and place it to the left, right, top or bottom. (37)

要完成图表，单击完成。 To finish the chart, click Finish. (38)

[编辑] 相关链接

本文原文