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
|
<?xml version="1.0" encoding="UTF-8"?>
<!--***********************************************************************
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: chart_insert.xhp,v $
*
* $Revision: 1.7 $
*
* last change: $Author: obo $ $Date: 2006-03-28 13:29:20 $
*
* The Contents of this file are made available subject to
* the terms of GNU Lesser General Public License Version 2.1.
*
*
* GNU Lesser General Public License Version 2.1
* =============================================
* Copyright 2005 by Sun Microsystems, Inc.
* 901 San Antonio Road, Palo Alto, CA 94303, USA
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library 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 for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
************************************************************************-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedguidechart_insertxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Inserting Charts</title>
<filename>/text/shared/guide/chart_insert.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
<lastedited date="2005-01-11T10:56:14">FPE: Removed screenshots. Cleaned a bit. Needs update!
DEDR: reviewed
YJ: checked new bits</lastedited>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153910"><bookmark_value>charts; inserting</bookmark_value>
<bookmark_value>plotting data as charts</bookmark_value>
<bookmark_value>inserting; charts</bookmark_value>
<bookmark_value>spreadsheets; inserting charts</bookmark_value>
<bookmark_value>charts; editing data</bookmark_value>
<bookmark_value>editing; chart data</bookmark_value>
<bookmark_value>data; in columns</bookmark_value>
<bookmark_value>columns; putting data in</bookmark_value>
<bookmark_value>rows; putting data in</bookmark_value>
<bookmark_value>data; putting in rows</bookmark_value>
<bookmark_value>charts; marking</bookmark_value>
<bookmark_value>ordering; data series</bookmark_value>
<bookmark_value>data series; changing order of</bookmark_value>
<bookmark_value>values; changing in charts</bookmark_value>
<bookmark_value>numbers; changing in a chart</bookmark_value>
<bookmark_value>charts; selecting and changing types</bookmark_value>
<bookmark_value>2D charts selection</bookmark_value>
<bookmark_value>3D charts; selecting</bookmark_value>
<bookmark_value>types of charts</bookmark_value>
<bookmark_value>XY charts</bookmark_value>
<bookmark_value>stock charts</bookmark_value>
<bookmark_value>line charts</bookmark_value>
<bookmark_value>pie charts</bookmark_value>
<bookmark_value>circle charts selection</bookmark_value>
<bookmark_value>combination charts</bookmark_value>
<bookmark_value>bar charts</bookmark_value>
<bookmark_value>charts; variants</bookmark_value>
<bookmark_value>3D charts;inserting</bookmark_value>
<bookmark_value>statistics; charts</bookmark_value>
<bookmark_value>charts; statistics</bookmark_value>
<bookmark_value>selecting;XY charts</bookmark_value>
<bookmark_value>error indicators in charts</bookmark_value>
<bookmark_value>error bars in charts</bookmark_value>
<bookmark_value>logarithmic axes in charts</bookmark_value>
<bookmark_value>averages in charts</bookmark_value>
<bookmark_value>showing; statistics in a 2D chart</bookmark_value>
<bookmark_value>variances in charts</bookmark_value>
<bookmark_value>standard deviation in charts</bookmark_value>
<bookmark_value>regression curves in charts</bookmark_value>
<bookmark_value>trend lines in charts</bookmark_value>
</bookmark>
<paragraph role="heading" id="hd_id3153910" xml-lang="en-US" level="1" l10n="U" oldref="34"><variable id="chart_insert"><link href="text/shared/guide/chart_insert.xhp" name="Inserting Charts">Inserting Charts</link>
</variable></paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id3153662" xml-lang="en-US" l10n="U" oldref="3">Open a spreadsheet and enter some data with row and column headings.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id3150275" xml-lang="en-US" l10n="U" oldref="4">Select the cells that contain the data that you want to present in your chart.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id7211218" xml-lang="en-US" l10n="CHG">Click the <emph>Insert Chart</emph> icon on the <emph>Standard</emph> toolbar.</paragraph>
<paragraph role="paragraph" id="par_idN109C9" xml-lang="en-US" l10n="NEW">The mouse pointer changes to a cross-hair symbol with a small chart symbol.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id3147303" xml-lang="en-US" l10n="U" oldref="6">Click in the spreadsheet and drag open a rectangle where you want to display the chart.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id3145419" xml-lang="en-US" l10n="U" oldref="7">Follow the instructions in the dialog that opens to create the chart. </paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id3149562" xml-lang="en-US" l10n="CHG" oldref="9">If you want to exchange the horizontal and the vertical axes of a chart, double-click the chart, and then click <emph>Data in Columns</emph> or <emph>Data in Rows</emph> icon on the <emph>Formatting</emph> bar.</paragraph>
<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U" oldref="30">Suppose you placed the chart in your $[officename] Calc spreadsheet in the background, and now you are wondering how to select it for further editing. </paragraph>
<paragraph role="paragraph" id="par_id3152376" xml-lang="en-US" l10n="CHG" oldref="55">Open the <emph>Drawing </emph>toolbar and click the <emph>Select</emph> arrow
<image id="img_id3155415" src="res/commandimagelist/sc_selectobject.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155415" xml-lang="en-US">Icon</alt>
</image>. Now you can click on the chart to select it.</paragraph>
<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="31">In a Calc chart, you can move a data series forward or backward. You can arrange the series in such a way that the lowest 3D bars are placed in the foreground and the higher ones in the background. To change the arrangement in the chart, use a command in the context menu of a data series or choose <emph>Format - Arrangement</emph>. The corresponding cell ranges in the $[officename] Calc spreadsheet will not be rearranged.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="listitem" id="par_id3155066" xml-lang="en-US" l10n="U" oldref="32">In $[officename] Writer documents, you can insert a chart obtained from the data of a Writer table. If you have not selected any data in a Writer table, choosing <emph>Insert - Object - Chart</emph> inserts a chart containing sample data.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3152960" xml-lang="en-US" l10n="U" oldref="29">You can change the sample data values by double-clicking on the chart and then choosing <link href="text/schart/01/03010000.xhp" name="Edit - Chart Data"><emph>Edit - Chart Data</emph></link>. If you want to change the values of a chart obtained from selected cells, you have to change the values in the table cells. If the chart is in a text document, press F9 to update the chart.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3153714" xml-lang="en-US" l10n="U" oldref="47">An easy method to change the numbers in a chart is <emph>drag-and-drop</emph>: select any table cell range, then drag and drop them at the chart. The chart updates with the new values.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150042" xml-lang="en-US" l10n="U" oldref="23">Modification of chart data is also possible if you, for example, have copied a chart from a Calc document into a Writer document and now double-click the chart in the $[officename] Writer document. Remember, however, you are only editing the copy and not the original document.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id3163726" xml-lang="en-US" l10n="U" oldref="11">You can change the type of chart any time. When you double-click on the chart and choose <emph>Format - Chart Type</emph>, a dialog appears, presenting you with various types to choose from.</paragraph>
<paragraph role="paragraph" id="par_id3146314" xml-lang="en-US" l10n="U" oldref="12">Try out the different options in the <emph>Chart Type</emph> dialog. You can also switch between 2D and 3D representation. With the <emph>Columns</emph> chart type you can select a <emph>Combination Chart</emph> of lines and columns.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="listitem" id="par_id3149032" xml-lang="en-US" l10n="U" oldref="20">3D charts can be rotated and tilted with the mouse for an optimal point of view.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3151346" xml-lang="en-US" l10n="U" oldref="33">In Line Charts you can use the data series symbols that are applied automatically by $[officename] Chart. You can also select symbols yourself from graphic files or from the Gallery.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id3166428" xml-lang="en-US" l10n="CHG" oldref="35"><link href="text/shared/01/04160100.xhp" name="AutoPilot Chart">AutoFormat Chart</link></paragraph>
<embed href="text/shared/guide/chart_axis.xhp#chart_axis"/>
<embed href="text/shared/guide/chart_legend.xhp#chart_legend"/>
<embed href="text/shared/guide/chart_title.xhp#chart_title"/>
<embed href="text/shared/guide/chart_barformat.xhp#chart_barformat"/>
</section>
</body>
</helpdocument>
|
