helpcontent2/source/text/schart/main0000.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <helpdocument version="1.0">
   3
   4 <!--
   5 ***********************************************************************
   6  *
   7  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   8  *
   9  * Copyright 2008 by Sun Microsystems, Inc.
  10  *
  11  * OpenOffice.org - a multi-platform office productivity suite
  12  *
  13  * $RCSfile: soffice2xmlhelp.xsl,v $
  14  * $Revision: 1.8 $
  15  *
  16  * This file is part of OpenOffice.org.
  17  *
  18  * OpenOffice.org is free software: you can redistribute it and/or modify
  19  * it under the terms of the GNU Lesser General Public License version 3
  20  * only, as published by the Free Software Foundation.
  21  *
  22  * OpenOffice.org is distributed in the hope that it will be useful,
  23  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  24  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  25  * GNU Lesser General Public License version 3 for more details
  26  * (a copy is included in the LICENSE file that accompanied this code).
  27  *
  28  * You should have received a copy of the GNU Lesser General Public License
  29  * version 3 along with OpenOffice.org.  If not, see
  30  * <http://www.openoffice.org/license.html>
  31  * for a copy of the LGPLv3 License.
  32  *
  33  ************************************************************************
  34  -->
  35
  36
  37 <meta>
  38       <topic id="textschartmain0000xml" indexer="include" status="PUBLISH">
  39          <title xml-lang="en-US" id="tit">Charts in $[officename]</title>
  40          <filename>/text/schart/main0000.xhp</filename>
  41       </topic>
  42    </meta>
  43    <body>
  44 <bookmark xml-lang="en-US" branch="index" id="bm_id3148664"><bookmark_value>charts; overview</bookmark_value>
  45       <bookmark_value>HowTos for charts</bookmark_value>
  46 </bookmark><comment>MW added one entry</comment>
  47 <paragraph xml-lang="en-US" id="hd_id3148664" role="heading" level="1" l10n="U" oldref="1"><variable id="chart_main"><link href="text/schart/main0000.xhp" name="Charts in $[officename]">Using Charts in %PRODUCTNAME</link>
  48 </variable></paragraph>
  49       <paragraph xml-lang="en-US" id="par_id3154685" role="paragraph" l10n="CHG" oldref="2"><variable id="chart">$[officename] lets you present data graphically in a chart, so that you can visually compare data series and view trends in the data. You can insert charts into spreadsheets, text documents, drawings, and presentations.
  50 </variable></paragraph>
  51       <paragraph xml-lang="en-US" id="hd_id3153143" role="heading" level="1" l10n="CHG"
  52                  oldref="5">Chart Data</paragraph>
  53       <paragraph xml-lang="en-US" id="par_id5181432" role="paragraph" l10n="NEW">Charts can be based on the following data:</paragraph>
  54       <list type="ordered">
  55          <listitem>
  56             <paragraph xml-lang="en-US" id="par_id7787102" role="paragraph" l10n="NEW">Spreadsheet values from Calc cell ranges<comment>also Excel...</comment></paragraph>
  57          </listitem>
  58          <listitem>
  59             <paragraph xml-lang="en-US" id="par_id7929929" role="paragraph" l10n="NEW">Cell values from a Writer table</paragraph>
  60          </listitem>
  61          <listitem>
  62             <paragraph xml-lang="en-US" id="par_id4727011" role="paragraph" l10n="NEW">Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc)</paragraph>
  63          </listitem>
  64       </list><comment>command line Insert - (Object -) Chart, moved here from deleted shared/01/04160100.xhp</comment>
  65 <bookmark xml-lang="en-US" branch="hid/SID_INSERT_DIAGRAM" id="bm_id2038889" localize="false"/>
  66 <bookmark xml-lang="en-US" branch="hid/.uno:InsertObjectChart" id="bm_id3149551" localize="false"/>
  67 <bookmark xml-lang="en-US" branch="hid/SID_DRAW_CHART" id="bm_id6209730" localize="false"/>
  68 <bookmark xml-lang="en-US" branch="hid/.uno:DrawChart" id="bm_id3154688" localize="false"/>
  69 <bookmark xml-lang="en-US" branch="hid/SID_OPENDLG_CHART" id="bm_id7389470" localize="false"/>
  70 <bookmark xml-lang="en-US" branch="hid/.uno:StarChartDialog" id="bm_id3146060" localize="false"/>
  71 <bookmark xml-lang="en-US" branch="hid/HID_INSERT_CHART" id="bm_id3149532" localize="false"/>
  72 <paragraph xml-lang="en-US" id="par_id76601" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Creates a chart in the current document. To use a continuous range of cells as the data source for your chart, click inside the cell range, and then choose this command. Alternatively, select some cells and choose this command to create a chart of the selected cells.</ahelp></paragraph>
  73       <paragraph xml-lang="en-US" id="hd_id5345011" role="heading" level="1" l10n="NEW">To insert a chart</paragraph>
  74       <embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
  75       <embed href="text/schart/01/choose_chart_type.xhp#choose_chart_type"/>
  76       <paragraph xml-lang="en-US" id="hd_id5631580" role="heading" level="1" l10n="NEW">To edit a chart</paragraph>
  77       <list type="ordered">
  78          <listitem>
  79             <paragraph xml-lang="en-US" id="par_id7911008" role="paragraph" l10n="NEW">Click a chart to edit the object properties:</paragraph>
  80             <paragraph xml-lang="en-US" id="par_id9844660" role="paragraph" l10n="NEW">Size and position on the current page.</paragraph>
  81             <paragraph xml-lang="en-US" id="par_id8039796" role="paragraph" l10n="NEW">Alignment, text wrap, outer borders, and more.</paragraph>
  82          </listitem>
  83          <listitem>
  84             <paragraph xml-lang="en-US" id="par_id7986693" role="paragraph" l10n="NEW">Double-click a chart to enter the chart edit mode:</paragraph>
  85             <paragraph xml-lang="en-US" id="par_id2350840" role="paragraph" l10n="NEW">Chart data values (for charts with own data).</paragraph>
  86             <paragraph xml-lang="en-US" id="par_id3776055" role="paragraph" l10n="NEW">Chart type, axes, titles, walls, grid, and more.</paragraph>
  87          </listitem>
  88          <listitem>
  89             <paragraph xml-lang="en-US" id="par_id8442335" role="paragraph" l10n="NEW">Double-click a chart element in chart edit mode:</paragraph>
  90             <paragraph xml-lang="en-US" id="par_id4194769" role="paragraph" l10n="NEW">Double-click an axis to edit the scale, type, color, and more.</paragraph>
  91             <paragraph xml-lang="en-US" id="par_id8644672" role="paragraph" l10n="NEW">Double-click a data point, or a data series in the legend, to edit the graphical values of the data series.</paragraph>
  92             <paragraph xml-lang="en-US" id="par_id6574907" role="paragraph" l10n="NEW">With a data series selected, double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart).</paragraph>
  93             <paragraph xml-lang="en-US" id="par_id7528916" role="paragraph" l10n="NEW">Double-click any other chart element, or click the element and open the Format menu, to edit the properties.</paragraph>
  94          </listitem>
  95          <listitem>
  96             <paragraph xml-lang="en-US" id="par_id8420667" role="paragraph" l10n="NEW">Click outside the chart to leave the current edit mode.</paragraph>
  97          </listitem>
  98       </list>
  99       <paragraph xml-lang="en-US" id="par_id4923856" role="tip" l10n="NEW">To print a chart in high quality, you can export the chart to a PDF file and print that file.</paragraph>
 100       <paragraph xml-lang="en-US" id="par_id0810200912061033" role="paragraph" l10n="NEW">In chart edit mode, you see the <link href="text/schart/main0202.xhp">Formatting Bar</link> for charts. </paragraph>
 101       <paragraph xml-lang="en-US" id="par_id0810200902080452" role="paragraph" l10n="NEW">You can right-click an element of a chart to open the context menu. The context menu offers many commands to format the selected element.</paragraph>
 102 <bookmark xml-lang="en-US" branch="hid/.uno:FormatTitle" id="bm_id0810200903431839" localize="false"/>
 103 <paragraph xml-lang="en-US" id="par_id081020090354489" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the selected title.</ahelp></paragraph>
 104 <bookmark xml-lang="en-US" branch="hid/.uno:FormatChartArea" id="bm_id0810200903401642" localize="false"/>
 105 <paragraph xml-lang="en-US" id="par_id0810200903405629" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the chart area.</ahelp></paragraph>
 106 <bookmark xml-lang="en-US" branch="hid/.uno:FormatWall" id="bm_id0810200903420337" localize="false"/>
 107 <paragraph xml-lang="en-US" id="par_id0810200903544867" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the chart wall.</ahelp></paragraph>
 108 <bookmark xml-lang="en-US" branch="hid/.uno:FormatFloor" id="bm_id0810200903424458" localize="false"/>
 109 <paragraph xml-lang="en-US" id="par_id0810200903544952" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the chart floor.</ahelp></paragraph>
 110 <bookmark xml-lang="en-US" branch="hid/.uno:FormatLegend" id="bm_id0810200903440259" localize="false"/>
 111 <paragraph xml-lang="en-US" id="par_id0810200903544927" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the chart legend.</ahelp></paragraph>
 112 <bookmark xml-lang="en-US" branch="hid/.uno:FormatAxis" id="bm_id0810200903443886" localize="false"/>
 113 <paragraph xml-lang="en-US" id="par_id0810200903544949" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the selected axis.</ahelp></paragraph>
 114 <bookmark xml-lang="en-US" branch="hid/.uno:FormatDataPoint" id="bm_id081020090345395" localize="false"/>
 115 <paragraph xml-lang="en-US" id="par_id0810200903544984" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the selected data point.</ahelp></paragraph>
 116 <bookmark xml-lang="en-US" branch="hid/.uno:FormatMajorGrid" id="bm_id0810200903463111" localize="false"/>
 117 <paragraph xml-lang="en-US" id="par_id0810200903545096" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the major grid.</ahelp></paragraph>
 118 <bookmark xml-lang="en-US" branch="hid/.uno:FormatMinorGrid" id="bm_id081020090347088" localize="false"/>
 119 <paragraph xml-lang="en-US" id="par_id0810200903545057" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the minor grid.</ahelp></paragraph>
 120 <bookmark xml-lang="en-US" branch="hid/.uno:FormatDataSeries" id="bm_id0810200903475043" localize="false"/>
 121 <paragraph xml-lang="en-US" id="par_id0810200903545095" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the data series.</ahelp></paragraph>
 122 <bookmark xml-lang="en-US" branch="hid/.uno:FormatStockLoss" id="bm_id0810200903483389" localize="false"/>
 123 <paragraph xml-lang="en-US" id="par_id0810200903545094" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the stock loss indicators.</ahelp></paragraph>
 124 <bookmark xml-lang="en-US" branch="hid/.uno:FormatStockGain" id="bm_id0810200903491288" localize="false"/>
 125 <paragraph xml-lang="en-US" id="par_id0810200903545113" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the stock gain indicators.</ahelp></paragraph>
 126 <bookmark xml-lang="en-US" branch="hid/.uno:FormatDataLabels" id="bm_id0810200903510321" localize="false"/>
 127 <paragraph xml-lang="en-US" id="par_id0810200903545149" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the data lables.</ahelp></paragraph>
 128 <bookmark xml-lang="en-US" branch="hid/.uno:FormatYErrorBars" id="bm_id0810200903522796" localize="false"/>
 129 <paragraph xml-lang="en-US" id="par_id0810200903545159" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the Y error bars.</ahelp></paragraph>
 130 <bookmark xml-lang="en-US" branch="hid/.uno:FormatMeanValue" id="bm_id0810200903531785" localize="false"/>
 131 <paragraph xml-lang="en-US" id="par_id081020090354524" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the mean value line.</ahelp></paragraph>
 132 <bookmark xml-lang="en-US" branch="hid/.uno:FormatTrendline" id="bm_id0810200903541347" localize="false"/>
 133 <paragraph xml-lang="en-US" id="par_id0810200903545274" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the trendline.</ahelp></paragraph>
 134 <bookmark xml-lang="en-US" branch="hid/.uno:FormatTrendlineEquation" id="bm_id0810200903583324" localize="false"/>
 135 <paragraph xml-lang="en-US" id="par_id0810200904063285" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the trendline equation.</ahelp></paragraph>
 136 <bookmark xml-lang="en-US" branch="hid/.uno:FormatDataLabel" id="bm_id0810200903592433" localize="false"/>
 137 <paragraph xml-lang="en-US" id="par_id0810200904063252" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the selected data label.</ahelp></paragraph>
 138 <bookmark xml-lang="en-US" branch="hid/.uno:InsertTitles" id="bm_id0810200904002651" localize="false"/>
 139 <paragraph xml-lang="en-US" id="par_id0810200904063239" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a dialog to insert chart titles.</ahelp></paragraph>
 140 <bookmark xml-lang="en-US" branch="hid/.uno:InsertRemoveAxes" id="bm_id0810200904070699" localize="false"/>
 141 <paragraph xml-lang="en-US" id="par_id0810200904233047" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a dialog to insert or delete axes.</ahelp></paragraph>
 142 <bookmark xml-lang="en-US" branch="hid/.uno:InsertAxis" id="bm_id0810200904131060" localize="false"/>
 143 <paragraph xml-lang="en-US" id="par_id0810200904233058" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a dialog to insert an axis.</ahelp></paragraph>
 144 <bookmark xml-lang="en-US" branch="hid/.uno:InsertAxisTitle" id="bm_id0810200904134569" localize="false"/>
 145 <paragraph xml-lang="en-US" id="par_id0810200904233089" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a dialog to insert an axis title.</ahelp></paragraph>
 146 <bookmark xml-lang="en-US" branch="hid/.uno:InsertMajorGrid" id="bm_id081020090418240" localize="false"/>
 147 <paragraph xml-lang="en-US" id="par_id0810200904233160" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts a major grid.</ahelp></paragraph>
 148 <bookmark xml-lang="en-US" branch="hid/.uno:InsertMinorGrid" id="bm_id0810200904190029" localize="false"/>
 149 <paragraph xml-lang="en-US" id="par_id0810200904233175" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts a minor grid.</ahelp></paragraph>
 150 <bookmark xml-lang="en-US" branch="hid/.uno:InsertDataLabels" id="bm_id0810200904194557" localize="false"/>
 151 <paragraph xml-lang="en-US" id="par_id0810200904233111" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts data labels.</ahelp></paragraph>
 152 <bookmark xml-lang="en-US" branch="hid/.uno:InsertTrendlineEquationAndR2" id="bm_id0810200904204069" localize="false"/>
 153 <paragraph xml-lang="en-US" id="par_id0810200904233174" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts the trendline equation and the coefficient of determination R².</ahelp></paragraph>
 154 <bookmark xml-lang="en-US" branch="hid/.uno:InsertR2Value" id="bm_id0810200904250571" localize="false"/>
 155 <paragraph xml-lang="en-US" id="par_id0810200904265639" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts the coefficient of determination R² value.</ahelp></paragraph>
 156 <bookmark xml-lang="en-US" branch="hid/.uno:InsertDataLabel" id="bm_id081020090428246" localize="false"/>
 157 <paragraph xml-lang="en-US" id="par_id0810200904362614" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts a single data label.</ahelp></paragraph>
 158 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteLegend" id="bm_id0810200904303930" localize="false"/>
 159 <paragraph xml-lang="en-US" id="par_id0810200904362666" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the chart legend.</ahelp></paragraph>
 160 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteAxis" id="bm_id0810200904311994" localize="false"/>
 161 <paragraph xml-lang="en-US" id="par_id0810200904362777" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the selected axis.</ahelp></paragraph>
 162 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteMajorGrid" id="bm_id0810200904315530" localize="false"/>
 163 <paragraph xml-lang="en-US" id="par_id0810200904362785" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the major grid.</ahelp></paragraph>
 164 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteMinorGrid" id="bm_id0810200904322666" localize="false"/>
 165 <paragraph xml-lang="en-US" id="par_id0810200904362748" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the minor grid.</ahelp></paragraph>
 166 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteDataLabels" id="bm_id0810200904330358" localize="false"/>
 167 <paragraph xml-lang="en-US" id="par_id0810200904362778" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes all data labels.</ahelp></paragraph>
 168 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteTrendlineEquation" id="bm_id0810200904341536" localize="false"/>
 169 <paragraph xml-lang="en-US" id="par_id0810200904362893" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the trendline equation.</ahelp></paragraph>
 170 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteR2Value" id="bm_id0810200904345275" localize="false"/>
 171 <paragraph xml-lang="en-US" id="par_id0810200904362896" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the R² value.</ahelp></paragraph>
 172 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteDataLabel" id="bm_id0810200904354291" localize="false"/>
 173 <paragraph xml-lang="en-US" id="par_id0810200904362827" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the selected data label.</ahelp></paragraph>
 174 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteMeanValue" id="bm_id0810200904405280" localize="false"/>
 175 <paragraph xml-lang="en-US" id="par_id0810200904431376" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the mean value line.</ahelp></paragraph>
 176 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteYErrorBars" id="bm_id0810200904413070" localize="false"/>
 177 <paragraph xml-lang="en-US" id="par_id081020090443142" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Deletes the Y error bars.</ahelp></paragraph>
 178 <bookmark xml-lang="en-US" branch="hid/.uno:ResetDataPoint" id="bm_id081020090437598" localize="false"/>
 179 <paragraph xml-lang="en-US" id="par_id0810200904393229" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Resets the selected data point to default format.</ahelp></paragraph>
 180 <bookmark xml-lang="en-US" branch="hid/.uno:ResetAllDataPoints" id="bm_id0810200904383722" localize="false"/>
 181 <paragraph xml-lang="en-US" id="par_id0810200904393351" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Resets all data points to default format.</ahelp></paragraph><comment>how to update chart data (drag&amp;drop vs chart data dialog)</comment><embed href="text/shared/guide/chart_title.xhp#chart_title"/>
 182       <embed href="text/shared/guide/chart_axis.xhp#chart_axis"/>
 183       <embed href="text/shared/guide/chart_legend.xhp#chart_legend"/>
 184       <embed href="text/shared/guide/chart_barformat.xhp#chart_barformat"/>
 185       <embed href="text/schart/01/three_d_view.xhp#three_d_view"/>
 186    </body>
 187 </helpdocument>