AOO410/main/helpcontent2/source/text/schart/01/type_column_line.xhp - openoffice - Git at Google

 <?xml version="1.0" encoding="UTF-8"?>


 <!--***********************************************************
  *
  * Licensed to the Apache Software Foundation (ASF) under one
  * or more contributor license agreements.  See the NOTICE file
  * distributed with this work for additional information
  * regarding copyright ownership.  The ASF licenses this file
  * to you under the Apache License, Version 2.0 (the
  * "License"); you may not use this file except in compliance
  * with the License.  You may obtain a copy of the License at
  *
  *   http://www.apache.org/licenses/LICENSE-2.0
  *
  * Unless required by applicable law or agreed to in writing,
  * software distributed under the License is distributed on an
  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  * KIND, either express or implied.  See the License for the
  * specific language governing permissions and limitations
  * under the 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>
	<?xml version="1.0" encoding="UTF-8"?>



	<!--***********************************************************
	*
	* Licensed to the Apache Software Foundation (ASF) under one
	* or more contributor license agreements. See the NOTICE file
	* distributed with this work for additional information
	* regarding copyright ownership. The ASF licenses this file
	* to you under the Apache License, Version 2.0 (the
	* "License"); you may not use this file except in compliance
	* with the License. You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing,
	* software distributed under the License is distributed on an
	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
	* KIND, either express or implied. See the License for the
	* specific language governing permissions and limitations
	* under the 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>