1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: type_column_line.xhp,v $
* $Revision: 1.5 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<helpdocument version="1.0">
<meta>
<topic id="textschart01type_column_linexhp" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Chart Type Column and Line </title>
<filename>/text/schart/01/type_column_line.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id5976744"><bookmark_value>column and line charts</bookmark_value>
<bookmark_value>chart types;column and line</bookmark_value>
<bookmark_value>combination charts</bookmark_value>
</bookmark>
<paragraph role="heading" id="hd_id8596453" xml-lang="en-US" level="1" l10n="CHG"><variable id="type_column_line"><link href="text/schart/01/type_column_line.xhp">Chart Type Column and Line</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id4818567" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
<paragraph role="heading" id="hd_id2451551" xml-lang="en-US" level="2" l10n="CHG">Column and Line</paragraph>
<paragraph role="paragraph" id="par_id3101901" xml-lang="en-US" l10n="CHG">A Column and Line chart is a combination of a <link href="text/schart/01/type_column_bar.xhp">Column chart</link> with a <link href="text/schart/01/type_line.xhp">Line chart</link>.</paragraph>
<paragraph role="paragraph" id="par_id7910397" xml-lang="en-US" l10n="NEW">Select one of the variants</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id5244300" xml-lang="en-US" l10n="NEW">Columns and Lines. The rectangles of the column data series are drawn side by side so that you can easily compare their values.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id7163609" xml-lang="en-US" l10n="NEW">Stacked Columns and Lines. The rectangles of the column data series are drawn stacked above each other, so that the height of a column visualizes the sum of the data values.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id1842097" xml-lang="en-US" l10n="NEW">You can insert a second y-axis with <link href="text/schart/01/04040000.xhp">Insert - Axes</link> after you finish the wizard.</paragraph>
<paragraph role="heading" id="hd_id8297677" xml-lang="en-US" level="2" l10n="NEW">To specify a data range</paragraph>
<paragraph role="paragraph" id="par_id8871120" xml-lang="en-US" l10n="NEW">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 <emph>Data Series</emph> dialog.</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id2952055" xml-lang="en-US" l10n="NEW">Select the data range.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id594500" xml-lang="en-US" l10n="NEW">Click one of the options for data series in rows or in columns.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id1944944" xml-lang="en-US" l10n="NEW">Check whether the data range has labels in the first row or in the first column or both.</paragraph>
</listitem>
</list>
<paragraph role="heading" id="hd_id6667683" xml-lang="en-US" level="2" l10n="NEW">Organizing data series</paragraph>
<paragraph role="paragraph" id="par_id7616809" xml-lang="en-US" l10n="NEW">In the Data Series list box you see a list of all data series in the current chart.</paragraph>
<paragraph role="paragraph" id="par_id9770195" xml-lang="en-US" l10n="NEW">The column data series are positioned at the top of the list, the line data series at the bottom of the list.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id1446272" xml-lang="en-US" l10n="NEW">To organize the data series, select an entry in the list.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id3779717" xml-lang="en-US" l10n="NEW">Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id5056611" xml-lang="en-US" l10n="NEW">Click Remove to remove the selected entry from the Data Series list.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id7786492" xml-lang="en-US" l10n="NEW">Use the Up and Down arrow buttons to move the selected entry in the list up or down. This way you can convert a Column data series to a List data series and back. This does not change the order in the data source table, but changes only the arrangement in the chart.</paragraph>
</listitem>
</list>
<paragraph role="heading" id="hd_id265816" xml-lang="en-US" level="2" l10n="NEW">Editing data series</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id6768700" xml-lang="en-US" l10n="NEW">Click an entry in the list to view and edit the properties for that entry.</paragraph>
<paragraph role="paragraph" id="par_id1924497" xml-lang="en-US" l10n="NEW">In the Data Ranges list box you see the role names and cell ranges of the data series components. </paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id5081942" xml-lang="en-US" l10n="NEW">Click an entry, then edit the contents in the text box below. </paragraph>
<paragraph role="paragraph" id="par_id2958464" xml-lang="en-US" l10n="NEW">The label next to the text box states the currently selected role. </paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id883816" xml-lang="en-US" l10n="NEW">Enter the range or click <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id5091708" xml-lang="en-US" l10n="NEW">The range for a data role, like Y-Values, must not include a label cell.</paragraph>
<paragraph role="heading" id="hd_id974456" xml-lang="en-US" level="2" l10n="NEW">Editing categories or data labels</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id2767113" xml-lang="en-US" l10n="NEW">Enter or select a cell range that will be used as text for categories or data labels. </paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id301828" xml-lang="en-US" l10n="NEW">The values in the Categories range will be shown as labels on the x axis.</paragraph>
<paragraph role="heading" id="hd_id8996246" xml-lang="en-US" level="2" l10n="NEW">Inserting chart elements</paragraph>
<paragraph role="paragraph" id="par_id5729544" xml-lang="en-US" l10n="NEW">Use the Chart Elements page of the Chart Wizard to insert any of the following elements:</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id2932828" xml-lang="en-US" l10n="NEW">Chart titles</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id9449446" xml-lang="en-US" l10n="NEW">Legend</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id8122196" xml-lang="en-US" l10n="NEW">Visible grid lines</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id9909665" xml-lang="en-US" l10n="NEW">For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements:</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id9141819" xml-lang="en-US" l10n="NEW">Secondary axes</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id6354869" xml-lang="en-US" l10n="NEW">Minor grids</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id2685323" xml-lang="en-US" l10n="NEW">Data labels</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id6042664" xml-lang="en-US" l10n="CHG">Statistics, for example mean values, y error bars and trend lines</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id7889950" xml-lang="en-US" l10n="CHG">To set different data labels for each data series, use the properties dialog of the data series.</paragraph>
<section id="relatedtopics">
<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
<embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
<embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/>
<embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/>
<embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
</section>
</body>
</helpdocument>
|
