source/text/schart/01/04050100.xhp | 220 ++++++++++++++++++-------------------
source/text/schart/main0000.xhp | 217 +++++++++++++++++-------------------
2 files changed, 217 insertions(+), 220 deletions(-)
New commits:
commit 6930aa0207190cdb8113b74dbbfb61b40ddafe4b
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Aug 24 14:48:58 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Aug 24 19:51:03 2024 +0200
tdf#162607 Remove dup's in hid2file.js
+ Case of some (but not all) dup's in schart/main0000.xhp
+ refactor
Change-Id: I22e548735b5efda9b634a3c21daaf6bf1def2543
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/172360
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/schart/01/04050100.xhp
b/source/text/schart/01/04050100.xhp
index 669f09788b..2d2d62267d 100644
--- a/source/text/schart/01/04050100.xhp
+++ b/source/text/schart/01/04050100.xhp
@@ -20,189 +20,189 @@
<meta>
<topic id="textschart0104050100xml" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Trend Lines</title>
+ <title id="tit">Trend Lines</title>
<filename>/text/schart/01/04050100.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id1744743">
+<bookmark branch="index" id="bm_id1744743">
<bookmark_value>calculating;regression curves</bookmark_value>
<bookmark_value>regression curves in charts</bookmark_value>
<bookmark_value>trend lines in charts</bookmark_value>
<bookmark_value>mean value lines in charts</bookmark_value>
</bookmark>
<comment>only use trend line, not regression curve: i89823</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuTrendlines"
id="bm_id2001709" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/@@nowidget@@" id="bm_@@nowidget@@"
localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/TP_TRENDLINE" id="bm_id2001710"
localize="false"/>
+<bookmark branch="hid/.uno:InsertMenuTrendlines" id="bm_id2001709"
localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/@@nowidget@@"
id="bm_@@nowidget@@" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/TP_TRENDLINE"
id="bm_id2001710" localize="false"/>
<h1 id="hd_id5409405"> <variable id="regression"><link
href="text/schart/01/04050100.xhp">Trend Lines</link></variable></h1>
-<paragraph id="par_id7272255" role="paragraph" xml-lang="en-US"> <variable
id="trendlinestext"> <ahelp hid=".">Trend lines can be added to all 2D chart
types except for Pie and Stock charts.</ahelp> </variable> </paragraph>
+<paragraph id="par_id7272255" role="paragraph"> <variable id="trendlinestext">
<ahelp hid=".">Trend lines can be added to all 2D chart types except for Pie
and Stock charts.</ahelp> </variable> </paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#trendlines"/>
</section><comment>Linear</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/linear"
id="bm_id6944181" localize="false"/>
-<paragraph id="par_id5716727" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">A linear trend line is
shown.</ahelp></paragraph><comment>Logarithmic</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/logarithmic" id="bm_id886257"
localize="false"/>
-<paragraph id="par_id5840021" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">A logarithmic trend line is
shown.</ahelp></paragraph><comment>Exponential</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/exponential" id="bm_id8892483"
localize="false"/>
-<paragraph id="par_id9417096" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">An exponential trend line is
shown.</ahelp></paragraph><comment>Power</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/power"
id="bm_id7198400" localize="false"/>
-<paragraph id="par_id8482924" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">A power trend line is
shown.</ahelp></paragraph><comment>Polynomial</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/polynomial"
id="bm_id180820161047491735" localize="false"/>
-<paragraph id="par_id180820161052123210" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">A polynomial trend line is
shown with a given degree.</ahelp></paragraph><comment>Degree</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label3"
id="bm_id180820161152296070" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/degree"
id="bm_id180820161152296071" localize="false"/>
-<paragraph id="par_id180820161102568315" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Degree of polynomial trend
line.</ahelp></paragraph><comment>Moving average</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/movingAverage"
id="bm_id180820161104335824" localize="false"/>
-<paragraph id="par_id180820161105546053" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">A moving average trend line
is shown with a given period.</ahelp></paragraph><comment>Period</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label4"
id="bm_id180820161157368991" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/period"
id="bm_id180820161157368992" localize="false"/>
-<paragraph id="par_id180820161107537745" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Number of points to
calculate average of moving average trend
line.</ahelp></paragraph><comment>Trend line name</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label5"
id="bm_id180820161429301956" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/entry_name"
id="bm_id180820161429301957" localize="false"/>
-<paragraph id="par_id180820161112599880" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Name of trend line in
legend.</ahelp></paragraph><comment>Extrapolate forward</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label7"
id="bm_id180820161430141657" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/extrapolate_Forward"
id="bm_id180820161430141658" localize="false"/>
-<paragraph id="par_id180820161117252261" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Trend line is extrapolated
for higher x-values.</ahelp></paragraph><comment>Extrapolate backward</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label8"
id="bm_id180820161504266451" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/extrapolate_Backward"
id="bm_id180820161504266452" localize="false"/>
-<paragraph id="par_id18082016111837138" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Trend line is extrapolated
for lower x-values.</ahelp></paragraph><comment>Force intercept</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/setIntercept"
id="bm_id180820161122038174" localize="false"/>
-<paragraph id="par_id180820161124272765" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">For linear, polynomial and
exponential trend lines, intercept value is forced to a given
value.</ahelp></paragraph><comment>Intercept value</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/interceptValue"
id="bm_id180820161125169514" localize="false"/>
-<paragraph id="par_id180820161126064822" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Value of intercept if it is
forced.</ahelp></paragraph><comment>Show equation</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/showEquation" id="bm_id4724875"
localize="false"/>
-<paragraph id="par_id8962370" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Shows the trend line equation next to the trend
line.</ahelp></paragraph><comment>Show correlation coefficient (R2)</comment>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/showCorrelationCoefficient"
id="bm_id9068880" localize="false"/>
-<paragraph id="par_id6889858" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Shows the coefficient of determination next to the trend
line.</ahelp></paragraph><comment>X name</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label6"
id="bm_id180820161515523577" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/entry_Xname"
id="bm_id180820161515523578" localize="false"/>
-<paragraph id="par_id180820161133305870" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Name of X variable in trend
line equation.</ahelp></paragraph><comment>Y name</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_Trendline/label9"
id="bm_id180820161516105398" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/schart/ui/tp_Trendline/entry_Yname"
id="bm_id180820161516105399" localize="false"/>
-<paragraph id="par_id180820161134155865" role="paragraph"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Name of Y variable in trend
line equation.</ahelp></paragraph>
-<paragraph id="par_id8398998" role="note" xml-lang="en-US">If you insert a
trend line to a chart type that uses categories, like <emph>Line</emph> or
<emph>Column</emph>, then the numbers 1, 2, 3, <emph>…</emph> are used as
x-values to calculate the trend line. For such charts the XY chart type might
be more suitable.</paragraph>
-
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuMeanValues"
id="bm_id7854243" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/linear" id="bm_id6944181"
localize="false"/>
+<paragraph id="par_id5716727" role="paragraph"><ahelp hid="."
visibility="hidden">A linear trend line is
shown.</ahelp></paragraph><comment>Logarithmic</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/logarithmic"
id="bm_id886257" localize="false"/>
+<paragraph id="par_id5840021" role="paragraph"><ahelp hid="."
visibility="hidden">A logarithmic trend line is
shown.</ahelp></paragraph><comment>Exponential</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/exponential"
id="bm_id8892483" localize="false"/>
+<paragraph id="par_id9417096" role="paragraph"><ahelp hid="."
visibility="hidden">An exponential trend line is
shown.</ahelp></paragraph><comment>Power</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/power" id="bm_id7198400"
localize="false"/>
+<paragraph id="par_id8482924" role="paragraph"><ahelp hid="."
visibility="hidden">A power trend line is
shown.</ahelp></paragraph><comment>Polynomial</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/polynomial"
id="bm_id180820161047491735" localize="false"/>
+<paragraph id="par_id180820161052123210" role="paragraph"><ahelp hid="."
visibility="hidden">A polynomial trend line is shown with a given
degree.</ahelp></paragraph><comment>Degree</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label3"
id="bm_id180820161152296070" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/degree"
id="bm_id180820161152296071" localize="false"/>
+<paragraph id="par_id180820161102568315" role="paragraph"><ahelp hid="."
visibility="hidden">Degree of polynomial trend
line.</ahelp></paragraph><comment>Moving average</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/movingAverage"
id="bm_id180820161104335824" localize="false"/>
+<paragraph id="par_id180820161105546053" role="paragraph"><ahelp hid="."
visibility="hidden">A moving average trend line is shown with a given
period.</ahelp></paragraph><comment>Period</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label4"
id="bm_id180820161157368991" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/period"
id="bm_id180820161157368992" localize="false"/>
+<paragraph id="par_id180820161107537745" role="paragraph"><ahelp hid="."
visibility="hidden">Number of points to calculate average of moving average
trend line.</ahelp></paragraph><comment>Trend line name</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label5"
id="bm_id180820161429301956" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/entry_name"
id="bm_id180820161429301957" localize="false"/>
+<paragraph id="par_id180820161112599880" role="paragraph"><ahelp hid="."
visibility="hidden">Name of trend line in
legend.</ahelp></paragraph><comment>Extrapolate forward</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label7"
id="bm_id180820161430141657" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/extrapolate_Forward"
id="bm_id180820161430141658" localize="false"/>
+<paragraph id="par_id180820161117252261" role="paragraph"><ahelp hid="."
visibility="hidden">Trend line is extrapolated for higher
x-values.</ahelp></paragraph><comment>Extrapolate backward</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label8"
id="bm_id180820161504266451" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/extrapolate_Backward"
id="bm_id180820161504266452" localize="false"/>
+<paragraph id="par_id18082016111837138" role="paragraph"><ahelp hid="."
visibility="hidden">Trend line is extrapolated for lower
x-values.</ahelp></paragraph><comment>Force intercept</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/setIntercept"
id="bm_id180820161122038174" localize="false"/>
+<paragraph id="par_id180820161124272765" role="paragraph"><ahelp hid="."
visibility="hidden">For linear, polynomial and exponential trend lines,
intercept value is forced to a given
value.</ahelp></paragraph><comment>Intercept value</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/interceptValue"
id="bm_id180820161125169514" localize="false"/>
+<paragraph id="par_id180820161126064822" role="paragraph"><ahelp hid="."
visibility="hidden">Value of intercept if it is
forced.</ahelp></paragraph><comment>Show equation</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/showEquation"
id="bm_id4724875" localize="false"/>
+<paragraph id="par_id8962370" role="paragraph"><ahelp hid="."
visibility="hidden">Shows the trend line equation next to the trend
line.</ahelp></paragraph><comment>Show correlation coefficient (R2)</comment>
+<bookmark
branch="hid/modules/schart/ui/tp_Trendline/showCorrelationCoefficient"
id="bm_id9068880" localize="false"/>
+<paragraph id="par_id6889858" role="paragraph"><ahelp hid="."
visibility="hidden">Shows the coefficient of determination next to the trend
line.</ahelp></paragraph><comment>X name</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label6"
id="bm_id180820161515523577" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/entry_Xname"
id="bm_id180820161515523578" localize="false"/>
+<paragraph id="par_id180820161133305870" role="paragraph"><ahelp hid="."
visibility="hidden">Name of X variable in trend line
equation.</ahelp></paragraph><comment>Y name</comment>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/label9"
id="bm_id180820161516105398" localize="false"/>
+<bookmark branch="hid/modules/schart/ui/tp_Trendline/entry_Yname"
id="bm_id180820161516105399" localize="false"/>
+<paragraph id="par_id180820161134155865" role="paragraph"><ahelp hid="."
visibility="hidden">Name of Y variable in trend line
equation.</ahelp></paragraph>
+<note id="par_id8398998">If you insert a trend line to a chart type that uses
categories, like <emph>Line</emph> or <emph>Column</emph>, then the numbers 1,
2, 3, <emph>…</emph> are used as x-values to calculate the trend line. For such
charts the XY chart type might be more suitable.</note>
+
+<bookmark branch="hid/.uno:InsertMenuMeanValues" id="bm_id7854243"
localize="false"/>
<list type="ordered">
<listitem>
- <paragraph id="par_id4349192" role="paragraph" xml-lang="en-US">To insert
a trend line for a data series, first double-click the chart to enter edit mode
and select the data series in the chart to which a trend line is to be
created.</paragraph>
+ <paragraph id="par_id4349192" role="paragraph">To insert a trend line for
a data series, first double-click the chart to enter edit mode and select the
data series in the chart to which a trend line is to be created.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id801630627531175" role="listitem">Choose <item
type="menuitem">Insert - Trend Line</item>, or right-click the data series to
open the context menu, and choose <item type="menuitem">Insert Trend
Line</item>.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id180820161539033867" role="paragraph"
xml-lang="en-US">Mean Value Lines are special trend lines that show the mean
value. Use <item type="menuitem">Insert - Mean Value Lines</item> to insert
mean value lines for data series.</paragraph>
+ <paragraph id="par_id180820161539033867" role="paragraph">Mean Value Lines
are special trend lines that show the mean value. Use <item
type="menuitem">Insert - Mean Value Lines</item> to insert mean value lines for
data series.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id9337443" role="paragraph" xml-lang="en-US">To delete
a trend line or mean value line, click the line, then press the Del
key.</paragraph>
+ <paragraph id="par_id9337443" role="paragraph">To delete a trend line or
mean value line, click the line, then press the Del key.</paragraph>
</listitem>
</list>
<note id="par_id801630627733593">The menu item <menuitem>Insert - Trend
Line</menuitem> is only available when the chart is in edit mode. It will
appear grayed out if the chart is in edit mode but no data series is
selected.</note>
-<paragraph id="par_id9569689" role="paragraph" xml-lang="en-US">The trend line
has the same color as the corresponding data series. To change the line
properties, select the trend line and choose <item type="menuitem">Format -
Format Selection - Line</item>.</paragraph>
+<paragraph id="par_id9569689" role="paragraph">The trend line has the same
color as the corresponding data series. To change the line properties, select
the trend line and choose <item type="menuitem">Format - Format Selection -
Line</item>.</paragraph>
<note id="par_id296334">A trend line is shown in the legend automatically. Its
name can be defined in options of the trend line.</note>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertTrendlineEquationAndR2"
id="bm_id2754601" localize="false"/>
+<bookmark branch="hid/.uno:InsertTrendlineEquationAndR2" id="bm_id2754601"
localize="false"/>
<h2 id="hd_id180820161534333508">Trend Line Equation and Coefficient of
Determination</h2>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertTrendlineEquation"
id="bm_id2754600" localize="false"/>
-<paragraph id="par_id8962065" role="paragraph" xml-lang="en-US">When the chart
is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the
coefficient of determination R<sup>2</sup>, even if they are not shown: click
on the trend line to see the information in the status bar.</paragraph>
-<paragraph id="par_id846888" role="paragraph" xml-lang="en-US"><ahelp
hid=".">To show the trend line equation, select the trend line in the chart,
right-click to open the context menu, and choose <item type="menuitem">Insert
Trend Line Equation</item>.</ahelp></paragraph>
-<paragraph id="par_id8962066" role="paragraph" xml-lang="en-US">To change
format of values (use less significant digits or scientific notation), select
the equation in the chart, right-click to open the context menu, and choose
<item type="menuitem">Format Trend Line Equation - Numbers</item>.</paragraph>
-<paragraph id="par_id180820161627109994" role="paragraph"
xml-lang="en-US">Default equation uses <item type="literal">x</item> for
abscissa variable, and <item type="literal">f(x)</item> for ordinate variable.
To change these names, select the trend line, choose <item
type="menuitem">Format - Format Selection – Type</item> and enter names in
<item type="literal">X Variable Name</item> and <item type="literal">Y Variable
Name</item> edit boxes.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertR2Value" id="bm_id2754602"
localize="false"/>
-<paragraph id="par_id18082016163702791" role="paragraph" xml-lang="en-US">To
show the coefficient of determination R<sup>2</sup>, select the equation in the
chart, right-click to open the context menu, and choose <item
type="menuitem">Insert R</item><sup><item
type="menuitem">2</item></sup>.</paragraph>
-<paragraph id="par_id180820161637028632" role="note" xml-lang="en-US">If
intercept is forced, coefficient of determination R<sup>2</sup> is not
calculated in the same way as with free intercept. R<sup>2</sup> values can not
be compared with forced or free intercept.</paragraph>
+<bookmark branch="hid/.uno:InsertTrendlineEquation" id="bm_id2754600"
localize="false"/>
+<paragraph id="par_id8962065" role="paragraph">When the chart is in edit mode,
%PRODUCTNAME gives you the equation of the trend line and the coefficient of
determination R<sup>2</sup>, even if they are not shown: click on the trend
line to see the information in the status bar.</paragraph>
+<paragraph id="par_id846888" role="paragraph"><ahelp hid=".">To show the trend
line equation, select the trend line in the chart, right-click to open the
context menu, and choose <item type="menuitem">Insert Trend Line
Equation</item>.</ahelp></paragraph>
+<paragraph id="par_id8962066" role="paragraph">To change format of values (use
less significant digits or scientific notation), select the equation in the
chart, right-click to open the context menu, and choose <item
type="menuitem">Format Trend Line Equation - Numbers</item>.</paragraph>
+<paragraph id="par_id180820161627109994" role="paragraph">Default equation
uses <item type="literal">x</item> for abscissa variable, and <item
type="literal">f(x)</item> for ordinate variable. To change these names, select
the trend line, choose <item type="menuitem">Format - Format Selection –
Type</item> and enter names in <item type="literal">X Variable Name</item> and
<item type="literal">Y Variable Name</item> edit boxes.</paragraph>
+<bookmark branch="hid/.uno:InsertR2Value" id="bm_id2754602" localize="false"/>
+<paragraph id="par_id18082016163702791" role="paragraph">To show the
coefficient of determination R<sup>2</sup>, select the equation in the chart,
right-click to open the context menu, and choose <item type="menuitem">Insert
R</item><sup><item type="menuitem">2</item></sup>.</paragraph>
+<note id="par_id180820161637028632">If intercept is forced, coefficient of
determination R<sup>2</sup> is not calculated in the same way as with free
intercept. R<sup>2</sup> values can not be compared with forced or free
intercept.</note>
<h2 id="hd_id180820161534333509">Trend Lines Curve Types</h2>
-<paragraph id="par_id18082016153820777" role="paragraph" xml-lang="en-US">The
following regression types are available:</paragraph>
+<paragraph id="par_id18082016153820777" role="paragraph">The following
regression types are available:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id180820161604098009" role="paragraph"
xml-lang="en-US"><emph>Linear</emph> trend line: regression through equation
<item type="literal">y=a∙x+b</item>. Intercept <item type="literal">b</item>
can be forced.</paragraph>
+ <paragraph id="par_id180820161604098009"
role="paragraph"><emph>Linear</emph> trend line: regression through equation
<item type="literal">y=a∙x+b</item>. Intercept <item type="literal">b</item>
can be forced.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id180820161612524298" role="paragraph"
xml-lang="en-US"><emph>Polynomial</emph> trend line: regression through
equation <item type="literal">y=Σ</item><sub><item
type="literal">i</item></sub><item type="literal">(a</item><sub><item
type="literal">i</item></sub><item type="literal">∙x</item><sup><item
type="literal">i</item></sup><item type="literal">)</item>. Intercept <item
type="literal">a</item><sub><item type="literal">0</item></sub> can be forced.
Degree of polynomial must be given (at least 2).</paragraph>
+ <paragraph id="par_id180820161612524298"
role="paragraph"><emph>Polynomial</emph> trend line: regression through
equation <item type="literal">y=Σ</item><sub><item
type="literal">i</item></sub><item type="literal">(a</item><sub><item
type="literal">i</item></sub><item type="literal">∙x</item><sup><item
type="literal">i</item></sup><item type="literal">)</item>. Intercept <item
type="literal">a</item><sub><item type="literal">0</item></sub> can be forced.
Degree of polynomial must be given (at least 2).</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id180820161612525364" role="paragraph"
xml-lang="en-US"><emph>Logarithmic</emph> trend line: regression through
equation <item type="literal">y=a∙ln(x)+b</item>.</paragraph>
+ <paragraph id="par_id180820161612525364"
role="paragraph"><emph>Logarithmic</emph> trend line: regression through
equation <item type="literal">y=a∙ln(x)+b</item>.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id180820161612526680" role="paragraph"
xml-lang="en-US"><emph>Exponential</emph> trend line: regression through
equation <item type="literal">y=b∙exp(a∙x)</item>.This equation is equivalent
to <item type="literal">y=b∙m</item><sup><item type="literal">x</item></sup>
with <item type="literal">m=exp(a)</item>. Intercept <item
type="literal">b</item> can be forced.</paragraph>
+ <paragraph id="par_id180820161612526680"
role="paragraph"><emph>Exponential</emph> trend line: regression through
equation <item type="literal">y=b∙exp(a∙x)</item>.This equation is equivalent
to <item type="literal">y=b∙m</item><sup><item type="literal">x</item></sup>
with <item type="literal">m=exp(a)</item>. Intercept <item
type="literal">b</item> can be forced.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id180820161612527230" role="paragraph"
xml-lang="en-US"><emph>Power</emph> trend line: regression through equation
<item type="literal">y=b∙x</item><sup><item
type="literal">a</item></sup>.</paragraph>
+ <paragraph id="par_id180820161612527230"
role="paragraph"><emph>Power</emph> trend line: regression through equation
<item type="literal">y=b∙x</item><sup><item
type="literal">a</item></sup>.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id180820161617342768" role="paragraph"
xml-lang="en-US"><emph>Moving average</emph> trend line: simple moving average
is calculated with the <emph>n</emph> previous y-values, <emph>n</emph> being
the period. No equation is available for this trend line.</paragraph>
+ <paragraph id="par_id180820161617342768" role="paragraph"><emph>Moving
average</emph> trend line: simple moving average is calculated with the
<emph>n</emph> previous y-values, <emph>n</emph> being the period. No equation
is available for this trend line.</paragraph>
</listitem></list>
<h2 id="hd_id9204077">Constraints</h2>
-<paragraph id="par_id7393719" role="paragraph" xml-lang="en-US"> The
calculation of the trend line considers only data pairs with the following
values:</paragraph>
+<paragraph id="par_id7393719" role="paragraph"> The calculation of the trend
line considers only data pairs with the following values:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id7212744" role="paragraph"
xml-lang="en-US">Logarithmic trend line: only positive x-values are
considered.</paragraph>
+ <paragraph id="par_id7212744" role="paragraph">Logarithmic trend line:
only positive x-values are considered.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id1664479" role="paragraph"
xml-lang="en-US">Exponential trend line: only positive y-values are considered,
except if all y-values are negative: regression will then follow equation <item
type="literal">y=-b∙exp(a∙x)</item>.</paragraph>
+ <paragraph id="par_id1664479" role="paragraph">Exponential trend line:
only positive y-values are considered, except if all y-values are negative:
regression will then follow equation <item
type="literal">y=-b∙exp(a∙x)</item>.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id8734702" role="paragraph" xml-lang="en-US">Power
trend line: only positive x-values are considered; only positive y-values are
considered, except if all y-values are negative: regression will then follow
equation<item type="literal"> y=-b∙x</item><sup><item
type="literal">a</item></sup>.</paragraph>
+ <paragraph id="par_id8734702" role="paragraph">Power trend line: only
positive x-values are considered; only positive y-values are considered, except
if all y-values are negative: regression will then follow equation<item
type="literal"> y=-b∙x</item><sup><item
type="literal">a</item></sup>.</paragraph>
</listitem></list>
-<paragraph id="par_id181279" role="paragraph" xml-lang="en-US">You should
transform your data accordingly; it is best to work on a copy of the original
data and transform the copied data.</paragraph>
+<paragraph id="par_id181279" role="paragraph">You should transform your data
accordingly; it is best to work on a copy of the original data and transform
the copied data.</paragraph>
<h2 id="hd_id180820161528021520">Calculate Parameters in Calc</h2>
-<paragraph id="par_id7735221" role="paragraph" xml-lang="en-US">You can also
calculate the parameters using Calc functions as follows.</paragraph>
+<paragraph id="par_id7735221" role="paragraph">You can also calculate the
parameters using Calc functions as follows.</paragraph>
<h3 id="hd_id5744193">The linear regression equation</h3>
-<paragraph id="par_id9251991" role="paragraph" xml-lang="en-US">The
<emph>linear regression</emph> follows the equation <item
type="literal">y=m*x+b</item>.</paragraph>
-<paragraph id="par_id7951902" role="code" xml-lang="en-US">m =
SLOPE(Data_Y;Data_X) </paragraph>
-<paragraph id="par_id6637165" role="code" xml-lang="en-US">b =
INTERCEPT(Data_Y ;Data_X) </paragraph>
-<paragraph id="par_id7879268" role="paragraph" xml-lang="en-US">Calculate the
coefficient of determination by</paragraph>
-<paragraph id="par_id9244361" role="code" xml-lang="en-US">r<sup>2</sup> =
RSQ(Data_Y;Data_X) </paragraph>
-<paragraph id="par_id2083498" role="paragraph" xml-lang="en-US">Besides m, b
and r<sup>2</sup> the array function <emph>LINEST</emph> provides additional
statistics for a regression analysis.</paragraph>
+<paragraph id="par_id9251991" role="paragraph">The <emph>linear
regression</emph> follows the equation <item
type="literal">y=m*x+b</item>.</paragraph>
+<paragraph id="par_id7951902" role="code">m = SLOPE(Data_Y;Data_X) </paragraph>
+<paragraph id="par_id6637165" role="code">b = INTERCEPT(Data_Y ;Data_X)
</paragraph>
+<paragraph id="par_id7879268" role="paragraph">Calculate the coefficient of
determination by</paragraph>
+<paragraph id="par_id9244361" role="code">r<sup>2</sup> = RSQ(Data_Y;Data_X)
</paragraph>
+<paragraph id="par_id2083498" role="paragraph">Besides m, b and r<sup>2</sup>
the array function <emph>LINEST</emph> provides additional statistics for a
regression analysis.</paragraph>
<h3 id="hd_id2538834">The logarithmic regression equation</h3>
-<paragraph id="par_id394299" role="paragraph" xml-lang="en-US">The
<emph>logarithmic regression</emph> follows the equation <item
type="literal">y=a*ln(x)+b</item>.</paragraph>
-<paragraph id="par_id2134159" role="code" xml-lang="en-US">a =
SLOPE(Data_Y;LN(Data_X)) </paragraph>
-<paragraph id="par_id5946531" role="code" xml-lang="en-US">b =
INTERCEPT(Data_Y ;LN(Data_X)) </paragraph>
-<paragraph id="par_id5649281" role="code" xml-lang="en-US">r<sup>2</sup> =
RSQ(Data_Y;LN(Data_X)) </paragraph>
+<paragraph id="par_id394299" role="paragraph">The <emph>logarithmic
regression</emph> follows the equation <item
type="literal">y=a*ln(x)+b</item>.</paragraph>
+<paragraph id="par_id2134159" role="code">a = SLOPE(Data_Y;LN(Data_X))
</paragraph>
+<paragraph id="par_id5946531" role="code">b = INTERCEPT(Data_Y ;LN(Data_X))
</paragraph>
+<paragraph id="par_id5649281" role="code">r<sup>2</sup> =
RSQ(Data_Y;LN(Data_X)) </paragraph>
<h3 id="hd_id7874080">The exponential regression equation</h3>
-<paragraph id="par_id4679097" role="paragraph" xml-lang="en-US"> For
exponential trend lines a transformation to a linear model takes place. The
optimal curve fitting is related to the linear model and the results are
interpreted accordingly.</paragraph>
-<paragraph id="par_id9112216" role="paragraph" xml-lang="en-US">The
exponential regression follows the equation <item
type="literal">y=b*exp(a*x)</item> or <item
type="literal">y=b*m</item><sup><item type="literal">x</item></sup>, which is
transformed to <item type="literal">ln(y)=ln(b)+a*x</item> or <item
type="literal">ln(y)=ln(b)+ln(m)*x</item> respectively.</paragraph>
-<paragraph id="par_id4416638" role="code" xml-lang="en-US">a =
SLOPE(LN(Data_Y);Data_X) </paragraph>
-<paragraph id="par_id1039155" role="paragraph" xml-lang="en-US">The variables
for the second variation are calculated as follows:</paragraph>
-<paragraph id="par_id7184057" role="code" xml-lang="en-US">m =
EXP(SLOPE(LN(Data_Y);Data_X)) </paragraph>
-<paragraph id="par_id786767" role="code" xml-lang="en-US">b =
EXP(INTERCEPT(LN(Data_Y);Data_X)) </paragraph>
-<paragraph id="par_id7127292" role="paragraph" xml-lang="en-US">Calculate the
coefficient of determination by</paragraph>
-<paragraph id="par_id5437177" role="code" xml-lang="en-US">r<sup>2</sup> =
RSQ(LN(Data_Y);Data_X) </paragraph>
-<paragraph id="par_id6946317" role="paragraph" xml-lang="en-US">Besides m, b
and r<sup>2</sup> the array function <emph>LOGEST</emph> provides additional
statistics for a regression analysis.</paragraph>
+<paragraph id="par_id4679097" role="paragraph"> For exponential trend lines a
transformation to a linear model takes place. The optimal curve fitting is
related to the linear model and the results are interpreted
accordingly.</paragraph>
+<paragraph id="par_id9112216" role="paragraph">The exponential regression
follows the equation <item type="literal">y=b*exp(a*x)</item> or <item
type="literal">y=b*m</item><sup><item type="literal">x</item></sup>, which is
transformed to <item type="literal">ln(y)=ln(b)+a*x</item> or <item
type="literal">ln(y)=ln(b)+ln(m)*x</item> respectively.</paragraph>
+<paragraph id="par_id4416638" role="code">a = SLOPE(LN(Data_Y);Data_X)
</paragraph>
+<paragraph id="par_id1039155" role="paragraph">The variables for the second
variation are calculated as follows:</paragraph>
+<paragraph id="par_id7184057" role="code">m = EXP(SLOPE(LN(Data_Y);Data_X))
</paragraph>
+<paragraph id="par_id786767" role="code">b = EXP(INTERCEPT(LN(Data_Y);Data_X))
</paragraph>
+<paragraph id="par_id7127292" role="paragraph">Calculate the coefficient of
determination by</paragraph>
+<paragraph id="par_id5437177" role="code">r<sup>2</sup> =
RSQ(LN(Data_Y);Data_X) </paragraph>
+<paragraph id="par_id6946317" role="paragraph">Besides m, b and r<sup>2</sup>
the array function <emph>LOGEST</emph> provides additional statistics for a
regression analysis.</paragraph>
<h3 id="hd_id6349375">The power regression equation</h3>
-<paragraph id="par_id1857661" role="paragraph" xml-lang="en-US"> For
<emph>power regression</emph> curves a transformation to a linear model takes
place. The power regression follows the equation <item
type="literal">y=b*x</item><sup><item type="literal">a</item></sup>, which is
transformed to <item type="literal">ln(y)=ln(b)+a*ln(x)</item>.</paragraph>
-<paragraph id="par_id8517105" role="code" xml-lang="en-US">a =
SLOPE(LN(Data_Y);LN(Data_X)) </paragraph>
-<paragraph id="par_id9827265" role="code" xml-lang="en-US">b =
EXP(INTERCEPT(LN(Data_Y);LN(Data_X)) </paragraph>
-<paragraph id="par_id2357249" role="code" xml-lang="en-US">r<sup>2</sup> =
RSQ(LN(Data_Y);LN(Data_X)) </paragraph>
+<paragraph id="par_id1857661" role="paragraph"> For <emph>power
regression</emph> curves a transformation to a linear model takes place. The
power regression follows the equation <item
type="literal">y=b*x</item><sup><item type="literal">a</item></sup>, which is
transformed to <item type="literal">ln(y)=ln(b)+a*ln(x)</item>.</paragraph>
+<paragraph id="par_id8517105" role="code">a = SLOPE(LN(Data_Y);LN(Data_X))
</paragraph>
+<paragraph id="par_id9827265" role="code">b =
EXP(INTERCEPT(LN(Data_Y);LN(Data_X)) </paragraph>
+<paragraph id="par_id2357249" role="code">r<sup>2</sup> =
RSQ(LN(Data_Y);LN(Data_X)) </paragraph>
<h3 id="hd_id7907040">The polynomial regression equation</h3>
-<paragraph id="par_id8918729" role="paragraph" xml-lang="en-US">For
<emph>polynomial regression</emph> curves a transformation to a linear model
takes place.</paragraph>
-<paragraph id="par_id33875" role="paragraph" xml-lang="en-US">Create a table
with the columns x, x<sup>2</sup>, x<sup>3</sup>, … , x<sup>n</sup>, y up to
the desired degree n. </paragraph>
-<paragraph id="par_id8720053" role="paragraph" xml-lang="en-US">Use the
formula <item type="literal">=LINEST(Data_Y,Data_X)</item> with the complete
range x to x<sup>n</sup> (without headings) as Data_X. </paragraph>
-<paragraph id="par_id5068514" role="paragraph" xml-lang="en-US">The first row
of the <emph>LINEST</emph> output contains the coefficients of the regression
polynomial, with the coefficient of x<sup>n</sup> at the leftmost
position.</paragraph>
-<paragraph id="par_id8202154" role="paragraph" xml-lang="en-US">The first
element of the third row of the <emph>LINEST</emph> output is the value of
r<sup>2</sup>. See the <link
href="text/scalc/01/04060107.xhp#Section8"><emph>LINEST</emph></link> function
for details on proper use and an explanation of the other output
parameters.</paragraph>
+<paragraph id="par_id8918729" role="paragraph">For <emph>polynomial
regression</emph> curves a transformation to a linear model takes
place.</paragraph>
+<paragraph id="par_id33875" role="paragraph">Create a table with the columns
x, x<sup>2</sup>, x<sup>3</sup>, … , x<sup>n</sup>, y up to the desired degree
n. </paragraph>
+<paragraph id="par_id8720053" role="paragraph">Use the formula <item
type="literal">=LINEST(Data_Y,Data_X)</item> with the complete range x to
x<sup>n</sup> (without headings) as Data_X. </paragraph>
+<paragraph id="par_id5068514" role="paragraph">The first row of the
<emph>LINEST</emph> output contains the coefficients of the regression
polynomial, with the coefficient of x<sup>n</sup> at the leftmost
position.</paragraph>
+<paragraph id="par_id8202154" role="paragraph">The first element of the third
row of the <emph>LINEST</emph> output is the value of r<sup>2</sup>. See the
<link href="text/scalc/01/04060107.xhp#Section8"><emph>LINEST</emph></link>
function for details on proper use and an explanation of the other output
parameters.</paragraph>
<section id="relatedtopics">
-<paragraph id="par_id4562211" role="paragraph" xml-lang="en-US"><link
href="text/schart/01/04050000.xhp">X/Y Error Bars</link></paragraph>
-<paragraph id="par_id4562212" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060107.xhp#Section8">LINEST</link> function</paragraph>
-<paragraph id="par_id4562216" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060107.xhp#Section7">LOGEST</link> function</paragraph>
-<paragraph id="par_id4562213" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060185.xhp#slope">SLOPE</link> function</paragraph>
-<paragraph id="par_id4562214" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060181.xhp#intercept">INTERCEPT</link>
function</paragraph>
-<paragraph id="par_id4562215" role="paragraph" xml-lang="en-US"><link
href="text/scalc/01/04060181.xhp#rsq">RSQ</link> function</paragraph>
+<paragraph id="par_id4562211" role="paragraph"><link
href="text/schart/01/04050000.xhp">X/Y Error Bars</link></paragraph>
+<paragraph id="par_id4562212" role="paragraph"><link
href="text/scalc/01/04060107.xhp#Section8">LINEST</link> function</paragraph>
+<paragraph id="par_id4562216" role="paragraph"><link
href="text/scalc/01/04060107.xhp#Section7">LOGEST</link> function</paragraph>
+<paragraph id="par_id4562213" role="paragraph"><link
href="text/scalc/01/04060185.xhp#slope">SLOPE</link> function</paragraph>
+<paragraph id="par_id4562214" role="paragraph"><link
href="text/scalc/01/04060181.xhp#intercept">INTERCEPT</link>
function</paragraph>
+<paragraph id="par_id4562215" role="paragraph"><link
href="text/scalc/01/04060181.xhp#rsq">RSQ</link> function</paragraph>
</section>
</body>
diff --git a/source/text/schart/main0000.xhp b/source/text/schart/main0000.xhp
index 7d2dd18324..67634ddbb3 100644
--- a/source/text/schart/main0000.xhp
+++ b/source/text/schart/main0000.xhp
@@ -22,37 +22,36 @@
<meta>
<topic id="textschartmain0000xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Charts in $[officename]</title>
+ <title id="tit">Charts in $[officename]</title>
<filename>/text/schart/main0000.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3148664"><bookmark_value>charts; overview</bookmark_value>
+<bookmark branch="index" id="bm_id3148664"><bookmark_value>charts;
overview</bookmark_value>
<bookmark_value>HowTos for charts</bookmark_value>
</bookmark><comment>MW added one entry</comment>
-<bookmark branch="hid/CHART2_HID_SCH_WIN_DOCUMENT" id="bm_id861689726559781"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148664" role="heading"
level="1"><variable id="chart_main"><link href="text/schart/main0000.xhp">Using
Charts in %PRODUCTNAME</link>
-</variable></paragraph>
+<bookmark branch="hid/CHART2_HID_SCH_WIN_DOCUMENT" id="bm_id861689726559781"
localize="false"/>
+<h1 id="hd_id3148664"><variable id="chart_main"><link
href="text/schart/main0000.xhp">Using Charts in %PRODUCTNAME</link>
+</variable></h1>
<embed href="text/shared/06/youtubevideos.xhp#whatisit"/>
- <paragraph xml-lang="en-US" id="par_id3154685"
role="paragraph"><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.
+ <paragraph id="par_id3154685" role="paragraph"><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.
</variable></paragraph>
<h2 id="hd_id3153143">Chart Data</h2>
- <paragraph xml-lang="en-US" id="par_id5181432" role="paragraph">Charts
can be based on the following data:</paragraph>
+ <paragraph id="par_id5181432" role="paragraph">Charts can be based on
the following data:</paragraph>
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id7787102"
role="paragraph">Spreadsheet values from Calc cell ranges<comment>also
Excel...</comment></paragraph>
+ <paragraph id="par_id7787102" role="paragraph">Spreadsheet values
from Calc cell ranges<comment>also Excel...</comment></paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id7929929"
role="paragraph">Cell values from a Writer table</paragraph>
+ <paragraph id="par_id7929929" role="paragraph">Cell values from a
Writer table</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id4727011"
role="paragraph">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>
+ <paragraph id="par_id4727011" role="paragraph">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>
</listitem>
</list><comment>command line Insert - (Object -) Chart, moved here from
deleted shared/01/04160100.xhp</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertObjectChart"
id="bm_id2038889" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:DrawChart" id="bm_id6209730"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:StarChartDialog" id="bm_id3146060"
localize="false"/>
-<paragraph xml-lang="en-US" id="par_id76601" role="paragraph"><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>
+<bookmark branch="hid/.uno:DrawChart" id="bm_id6209730" localize="false"/>
+<bookmark branch="hid/.uno:StarChartDialog" id="bm_id3146060"
localize="false"/>
+<paragraph id="par_id76601" role="paragraph"><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>
<h2 id="hd_id5345011">To insert a chart</h2>
<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
<embed href="text/schart/01/choose_chart_type.xhp#choose_chart_type"/>
@@ -60,111 +59,109 @@
<section id="chartedit">
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id7911008"
role="paragraph">Click a chart to edit the object properties:</paragraph>
- <paragraph xml-lang="en-US" id="par_id9844660"
role="paragraph">Size and position on the current page.</paragraph>
- <paragraph xml-lang="en-US" id="par_id8039796"
role="paragraph">Alignment, text wrap, outer borders, and more.</paragraph>
+ <paragraph id="par_id7911008" role="paragraph">Click a chart to
edit the object properties:</paragraph>
+ <paragraph id="par_id9844660" role="paragraph">Size and position
on the current page.</paragraph>
+ <paragraph id="par_id8039796" role="paragraph">Alignment, text
wrap, outer borders, and more.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id7986693"
role="paragraph">Double-click a chart to enter the chart edit mode:</paragraph>
- <paragraph xml-lang="en-US" id="par_id2350840"
role="paragraph">Chart data values (for charts with own data).</paragraph>
- <paragraph xml-lang="en-US" id="par_id3776055"
role="paragraph">Chart type, axes, titles, walls, grid, and more.</paragraph>
+ <paragraph id="par_id7986693" role="paragraph">Double-click a
chart to enter the chart edit mode:</paragraph>
+ <paragraph id="par_id2350840" role="paragraph">Chart data values
(for charts with own data).</paragraph>
+ <paragraph id="par_id3776055" role="paragraph">Chart type, axes,
titles, walls, grid, and more.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id8442335"
role="paragraph">Double-click a chart element in chart edit mode:</paragraph>
- <paragraph xml-lang="en-US" id="par_id4194769"
role="paragraph">Double-click an axis to edit the scale, type, color, and
more.</paragraph>
- <paragraph xml-lang="en-US" id="par_id8644672"
role="paragraph">Double-click a data point to select and edit the data series
to which the data point belongs.</paragraph>
- <paragraph xml-lang="en-US" id="par_id6574907"
role="paragraph">With a data series selected, click, then double-click a single
data point to edit the properties of this data point (for example, a single bar
in a bar chart).</paragraph>
- <paragraph xml-lang="en-US" id="par_id1019200902360575"
role="paragraph">Double-click the legend to select and edit the legend. Click,
then double-click a symbol in the selected legend to edit the associated data
series.</paragraph>
- <paragraph xml-lang="en-US" id="par_id7528916"
role="paragraph">Double-click any other chart element, or click the element and
open the Format menu, to edit the properties.</paragraph>
+ <paragraph id="par_id8442335" role="paragraph">Double-click a
chart element in chart edit mode:</paragraph>
+ <paragraph id="par_id4194769" role="paragraph">Double-click an
axis to edit the scale, type, color, and more.</paragraph>
+ <paragraph id="par_id8644672" role="paragraph">Double-click a data
point to select and edit the data series to which the data point
belongs.</paragraph>
+ <paragraph id="par_id6574907" role="paragraph">With a data series
selected, click, then double-click a single data point to edit the properties
of this data point (for example, a single bar in a bar chart).</paragraph>
+ <paragraph id="par_id1019200902360575"
role="paragraph">Double-click the legend to select and edit the legend. Click,
then double-click a symbol in the selected legend to edit the associated data
series.</paragraph>
+ <paragraph id="par_id7528916" role="paragraph">Double-click any
other chart element, or click the element and open the Format menu, to edit the
properties.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id8420667"
role="paragraph">Click outside the chart to leave the current edit
mode.</paragraph>
+ <paragraph id="par_id8420667" role="paragraph">Click outside the
chart to leave the current edit mode.</paragraph>
</listitem>
</list>
- <paragraph xml-lang="en-US" id="par_id4923856" role="tip">To print a
chart in high quality, you can export the chart to a PDF file and print that
file.</paragraph>
- <paragraph xml-lang="en-US" id="par_id0810200912061033"
role="paragraph">In chart edit mode, you see the <link
href="text/schart/main0202.xhp">Formatting Bar</link> for charts near the upper
border of the document. The Drawing Bar for charts appears near the lower
border of the document. The Drawing Bar shows a subset of the icons from the
<link href="text/simpress/main0210.xhp">Drawing</link> toolbar of Draw and
Impress.</paragraph>
- <paragraph xml-lang="en-US" id="par_id0810200902080452"
role="paragraph">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>
+ <tip id="par_id4923856">To print a chart in high quality, you can export
the chart to a PDF file and print that file.</tip>
+ <paragraph id="par_id0810200912061033" role="paragraph">In chart edit
mode, you see the <link href="text/schart/main0202.xhp">Formatting Bar</link>
for charts near the upper border of the document. The Drawing Bar for charts
appears near the lower border of the document. The Drawing Bar shows a subset
of the icons from the <link href="text/simpress/main0210.xhp">Drawing</link>
toolbar of Draw and Impress.</paragraph>
+ <paragraph id="par_id0810200902080452" role="paragraph">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>
</section>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatTitle"
id="bm_id0810200903431839" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id081020090354489" role="paragraph"><ahelp
hid="." visibility="hidden">Formats the selected title.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatChartArea"
id="bm_id0810200903401642" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903405629"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart
area.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatWall"
id="bm_id0810200903420337" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903544867"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart
wall.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatFloor"
id="bm_id0810200903424458" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903544952"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart
floor.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatLegend"
id="bm_id0810200903440259" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903544927"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the chart
legend.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatAxis"
id="bm_id0810200903443886" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903544949"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected
axis.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatDataPoint"
id="bm_id081020090345395" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903544984"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected data
point.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatMajorGrid"
id="bm_id0810200903463111" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545096"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the major
grid.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatMinorGrid"
id="bm_id081020090347088" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545057"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the minor
grid.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatDataSeries"
id="bm_id0810200903475043" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545095"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the data
series.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatStockLoss"
id="bm_id0810200903483389" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545094"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the stock loss
indicators.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatStockGain"
id="bm_id0810200903491288" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545113"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the stock gain
indicators.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatDataLabels"
id="bm_id0810200903510321" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545149"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the data
labels.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatYErrorBars"
id="bm_id0810200903522796" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545159"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the Y error
bars.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatMeanValue"
id="bm_id0810200903531785" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id081020090354524" role="paragraph"><ahelp
hid="." visibility="hidden">Formats the mean value line.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatTrendline"
id="bm_id0810200903541347" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200903545274"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the
trendline.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatTrendlineEquation"
id="bm_id0810200903583324" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904063285"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the trendline
equation.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:FormatDataLabel"
id="bm_id0810200903592433" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904063252"
role="paragraph"><ahelp hid="." visibility="hidden">Formats the selected data
label.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertTitles"
id="bm_id0810200904002651" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904063239"
role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert
chart titles.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertRemoveAxes"
id="bm_id0810200904070699" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233047"
role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert or
delete axes.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertAxis"
id="bm_id0810200904131060" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233058"
role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert an
axis.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertAxisTitle"
id="bm_id0810200904134569" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233089"
role="paragraph"><ahelp hid="." visibility="hidden">Opens a dialog to insert an
axis title.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertMajorGrid"
id="bm_id081020090418240" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233160"
role="paragraph"><ahelp hid="." visibility="hidden">Inserts a major
grid.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertMinorGrid"
id="bm_id0810200904190029" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233175"
role="paragraph"><ahelp hid="." visibility="hidden">Inserts a minor
grid.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertDataLabels"
id="bm_id0810200904194557" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233111"
role="paragraph"><ahelp hid="." visibility="hidden">Inserts data
labels.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertTrendlineEquationAndR2"
id="bm_id0810200904204069" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904233174"
role="paragraph"><ahelp hid="." visibility="hidden">Inserts the trendline
equation and the coefficient of determination R².</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertR2Value"
id="bm_id0810200904250571" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904265639"
role="paragraph"><ahelp hid="." visibility="hidden">Inserts the coefficient of
determination R² value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertDataLabel"
id="bm_id081020090428246" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362614"
role="paragraph"><ahelp hid="." visibility="hidden">Inserts a single data
label.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteLegend"
id="bm_id0810200904303930" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362666"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the chart
legend.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteAxis"
id="bm_id0810200904311994" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362777"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the selected
axis.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteMajorGrid"
id="bm_id0810200904315530" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362785"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the major
grid.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteMinorGrid"
id="bm_id0810200904322666" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362748"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the minor
grid.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteDataLabels"
id="bm_id0810200904330358" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362778"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes all data
labels.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteTrendlineEquation"
id="bm_id0810200904341536" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362893"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the trendline
equation.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteR2Value"
id="bm_id0810200904345275" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362896"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the R²
value.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteDataLabel"
id="bm_id0810200904354291" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904362827"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the selected data
label.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteMeanValue"
id="bm_id0810200904405280" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904431376"
role="paragraph"><ahelp hid="." visibility="hidden">Deletes the mean value
line.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteYErrorBars"
id="bm_id0810200904413070" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id081020090443142" role="paragraph"><ahelp
hid="." visibility="hidden">Deletes the Y error bars.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:ResetDataPoint"
id="bm_id081020090437598" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904393229"
role="paragraph"><ahelp hid="." visibility="hidden">Resets the selected data
point to default format.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:ResetAllDataPoints"
id="bm_id0810200904383722" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id0810200904393351"
role="paragraph"><ahelp hid="." visibility="hidden">Resets all data points to
default format.</ahelp></paragraph><comment>how to update chart data
(drag&drop vs chart data dialog)</comment><embed
href="text/shared/guide/chart_title.xhp#chart_title"/>
+<bookmark branch="hid/.uno:FormatTitle" id="bm_id0810200903431839"
localize="false"/>
+<paragraph id="par_id081020090354489" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the selected title.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatChartArea" id="bm_id0810200903401642"
localize="false"/>
+<paragraph id="par_id0810200903405629" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the chart area.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatWall" id="bm_id0810200903420337"
localize="false"/>
+<paragraph id="par_id0810200903544867" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the chart wall.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatFloor" id="bm_id0810200903424458"
localize="false"/>
+<paragraph id="par_id0810200903544952" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the chart floor.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatLegend" id="bm_id0810200903440259"
localize="false"/>
+<paragraph id="par_id0810200903544927" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the chart legend.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatAxis" id="bm_id0810200903443886"
localize="false"/>
+<paragraph id="par_id0810200903544949" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the selected axis.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatDataPoint" id="bm_id081020090345395"
localize="false"/>
+<paragraph id="par_id0810200903544984" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the selected data point.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatMajorGrid" id="bm_id0810200903463111"
localize="false"/>
+<paragraph id="par_id0810200903545096" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the major grid.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatMinorGrid" id="bm_id081020090347088"
localize="false"/>
+<paragraph id="par_id0810200903545057" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the minor grid.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatDataSeries" id="bm_id0810200903475043"
localize="false"/>
+<paragraph id="par_id0810200903545095" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the data series.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatStockLoss" id="bm_id0810200903483389"
localize="false"/>
+<paragraph id="par_id0810200903545094" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the stock loss indicators.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatStockGain" id="bm_id0810200903491288"
localize="false"/>
+<paragraph id="par_id0810200903545113" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the stock gain indicators.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatDataLabels" id="bm_id0810200903510321"
localize="false"/>
+<paragraph id="par_id0810200903545149" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the data labels.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatYErrorBars" id="bm_id0810200903522796"
localize="false"/>
+<paragraph id="par_id0810200903545159" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the Y error bars.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatMeanValue" id="bm_id0810200903531785"
localize="false"/>
+<paragraph id="par_id081020090354524" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the mean value line.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatTrendline" id="bm_id0810200903541347"
localize="false"/>
+<paragraph id="par_id0810200903545274" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the trendline.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatTrendlineEquation" id="bm_id0810200903583324"
localize="false"/>
+<paragraph id="par_id0810200904063285" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the trendline equation.</ahelp></paragraph>
+<bookmark branch="hid/.uno:FormatDataLabel" id="bm_id0810200903592433"
localize="false"/>
+<paragraph id="par_id0810200904063252" role="paragraph"><ahelp hid="."
visibility="hidden">Formats the selected data label.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertTitles" id="bm_id0810200904002651"
localize="false"/>
+<paragraph id="par_id0810200904063239" role="paragraph"><ahelp hid="."
visibility="hidden">Opens a dialog to insert chart titles.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertRemoveAxes" id="bm_id0810200904070699"
localize="false"/>
+<paragraph id="par_id0810200904233047" role="paragraph"><ahelp hid="."
visibility="hidden">Opens a dialog to insert or delete axes.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertAxis" id="bm_id0810200904131060"
localize="false"/>
+<paragraph id="par_id0810200904233058" role="paragraph"><ahelp hid="."
visibility="hidden">Opens a dialog to insert an axis.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertAxisTitle" id="bm_id0810200904134569"
localize="false"/>
+<paragraph id="par_id0810200904233089" role="paragraph"><ahelp hid="."
visibility="hidden">Opens a dialog to insert an axis title.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertMajorGrid" id="bm_id081020090418240"
localize="false"/>
+<paragraph id="par_id0810200904233160" role="paragraph"><ahelp hid="."
visibility="hidden">Inserts a major grid.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertMinorGrid" id="bm_id0810200904190029"
localize="false"/>
+<paragraph id="par_id0810200904233175" role="paragraph"><ahelp hid="."
visibility="hidden">Inserts a minor grid.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertDataLabels" id="bm_id0810200904194557"
localize="false"/>
+<paragraph id="par_id0810200904233111" role="paragraph"><ahelp hid="."
visibility="hidden">Inserts data labels.</ahelp></paragraph>
+<paragraph id="par_id0810200904233174" role="paragraph"><ahelp
hid="hid/.uno:InsertTrendlineEquationAndR2" visibility="hidden">Inserts the
trendline equation and the coefficient of determination R².</ahelp></paragraph>
+<paragraph id="par_id0810200904265639" role="paragraph"><ahelp
hid="hid/.uno:InsertR2Value" visibility="hidden">Inserts the coefficient of
determination R² value.</ahelp></paragraph>
+<bookmark branch="hid/.uno:InsertDataLabel" id="bm_id081020090428246"
localize="false"/>
+<paragraph id="par_id0810200904362614" role="paragraph"><ahelp hid="."
visibility="hidden">Inserts a single data label.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteLegend" id="bm_id0810200904303930"
localize="false"/>
+<paragraph id="par_id0810200904362666" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the chart legend.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteAxis" id="bm_id0810200904311994"
localize="false"/>
+<paragraph id="par_id0810200904362777" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the selected axis.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteMajorGrid" id="bm_id0810200904315530"
localize="false"/>
+<paragraph id="par_id0810200904362785" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the major grid.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteMinorGrid" id="bm_id0810200904322666"
localize="false"/>
+<paragraph id="par_id0810200904362748" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the minor grid.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteDataLabels" id="bm_id0810200904330358"
localize="false"/>
+<paragraph id="par_id0810200904362778" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes all data labels.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteTrendlineEquation" id="bm_id0810200904341536"
localize="false"/>
+<paragraph id="par_id0810200904362893" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the trendline equation.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteR2Value" id="bm_id0810200904345275"
localize="false"/>
+<paragraph id="par_id0810200904362896" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the R² value.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteDataLabel" id="bm_id0810200904354291"
localize="false"/>
+<paragraph id="par_id0810200904362827" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the selected data label.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteMeanValue" id="bm_id0810200904405280"
localize="false"/>
+<paragraph id="par_id0810200904431376" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the mean value line.</ahelp></paragraph>
+<bookmark branch="hid/.uno:DeleteYErrorBars" id="bm_id0810200904413070"
localize="false"/>
+<paragraph id="par_id081020090443142" role="paragraph"><ahelp hid="."
visibility="hidden">Deletes the Y error bars.</ahelp></paragraph>
+<bookmark branch="hid/.uno:ResetDataPoint" id="bm_id081020090437598"
localize="false"/>
+<paragraph id="par_id0810200904393229" role="paragraph"><ahelp hid="."
visibility="hidden">Resets the selected data point to default
format.</ahelp></paragraph>
+<bookmark branch="hid/.uno:ResetAllDataPoints" id="bm_id0810200904383722"
localize="false"/>
+<paragraph id="par_id0810200904393351" role="paragraph"><ahelp hid="."
visibility="hidden">Resets all data points to default
format.</ahelp></paragraph><comment>how to update chart data (drag&drop vs
chart data dialog)</comment><embed
href="text/shared/guide/chart_title.xhp#chart_title"/>
<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_barformat.xhp#chart_barformat"/>
