You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openoffice.apache.org by ms...@apache.org on 2024/01/02 21:18:50 UTC
(openoffice) branch AOO42X updated: Small corrections in schart Help files
This is an automated email from the ASF dual-hosted git repository.
mseidel pushed a commit to branch AOO42X
in repository https://gitbox.apache.org/repos/asf/openoffice.git
The following commit(s) were added to refs/heads/AOO42X by this push:
new 86912e8e82 Small corrections in schart Help files
86912e8e82 is described below
commit 86912e8e82381732d8f9c1a68fb5b99ec31386fd
Author: mseidel <ms...@apache.org>
AuthorDate: Tue Jan 2 22:17:55 2024 +0100
Small corrections in schart Help files
(cherry picked from commit 19e329f54b0b8ec9e97ffb70f06290590094b8d4)
---
.../source/text/schart/00/00000004.xhp | 4 +--
.../source/text/schart/01/04050100.xhp | 36 +++++++++++-----------
.../source/text/schart/01/05020201.xhp | 2 +-
.../source/text/schart/01/choose_chart_type.xhp | 2 +-
.../source/text/schart/01/three_d_view.xhp | 10 +++---
.../source/text/schart/01/type_column_bar.xhp | 2 +-
.../source/text/schart/01/type_line.xhp | 2 +-
.../source/text/schart/01/type_net.xhp | 2 +-
.../source/text/schart/01/type_pie.xhp | 2 +-
.../source/text/schart/01/type_stock.xhp | 2 +-
.../helpcontent2/source/text/schart/01/type_xy.xhp | 8 ++---
.../source/text/schart/01/wiz_data_series.xhp | 2 +-
12 files changed, 37 insertions(+), 37 deletions(-)
diff --git a/main/helpcontent2/source/text/schart/00/00000004.xhp b/main/helpcontent2/source/text/schart/00/00000004.xhp
index 69d2ccb506..33ef76de01 100644
--- a/main/helpcontent2/source/text/schart/00/00000004.xhp
+++ b/main/helpcontent2/source/text/schart/00/00000004.xhp
@@ -229,11 +229,11 @@
</section>
<section id="wiz">
<paragraph role="paragraph" id="par_id9631641" xml-lang="en-US" l10n="NEW">Choose Insert - <switchinline select="appl"><caseinline select="WRITER"> Object -
-</caseinline></switchinline> Chart </paragraph>
+</caseinline></switchinline> Chart</paragraph>
</section>
<section id="wiz_ranges">
<paragraph role="paragraph" id="par_id2985320" xml-lang="en-US" l10n="NEW">Choose Insert - <switchinline select="appl"><caseinline select="WRITER"> Object -
-</caseinline></switchinline> Chart </paragraph>
+</caseinline></switchinline> Chart</paragraph>
<paragraph role="paragraph" id="par_id1096530" xml-lang="en-US" l10n="NEW">Double-click a chart, then choose Format - Data Ranges</paragraph>
</section>
<paragraph role="paragraph" id="par_id733359" xml-lang="en-US" l10n="NEW"><variable id="slp">In a chart of Line type or XY type which displays lines, mark Smooth lines and click the Properties button
diff --git a/main/helpcontent2/source/text/schart/01/04050100.xhp b/main/helpcontent2/source/text/schart/01/04050100.xhp
index 9751a607bf..af16508ba8 100644
--- a/main/helpcontent2/source/text/schart/01/04050100.xhp
+++ b/main/helpcontent2/source/text/schart/01/04050100.xhp
@@ -59,7 +59,7 @@
<paragraph xml-lang="en-US" id="par_id8962370" role="paragraph" l10n="NEW"><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/CHART2_HID_SCH_TRENDLINE_SHOW_R_SQUARED" id="bm_id9068880" localize="false"/>
<paragraph xml-lang="en-US" id="par_id6889858" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Shows the coefficient of determination next to the trend line.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id8398998" role="note" l10n="CHG">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.</paragraph>
+<paragraph xml-lang="en-US" id="par_id8398998" role="note" l10n="CHG">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.</paragraph>
<list type="ordered">
<listitem>
<paragraph xml-lang="en-US" id="par_id5676747" role="paragraph" l10n="CHG">To insert trend lines for all data series, double-click the chart to enter edit mode. Choose <item type="menuitem">Insert - Trend Lines</item>, then select the type of trend line from None, Linear, Logarithmic, Exponential, or Power trend line.</paragraph>
@@ -89,31 +89,31 @@
<paragraph xml-lang="en-US" id="par_id7735221" role="paragraph" l10n="NEW">You can also calculate the parameters using Calc functions as follows.</paragraph>
<paragraph xml-lang="en-US" id="hd_id5744193" role="heading" level="2" l10n="NEW">The linear regression equation</paragraph>
<paragraph xml-lang="en-US" id="par_id9251991" role="paragraph" l10n="NEW">The <emph>linear regression</emph> follows the equation <item type="literal">y=m*x+b</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_id7951902" role="code" l10n="NEW">m = SLOPE(Data_Y;Data_X) </paragraph>
-<paragraph xml-lang="en-US" id="par_id6637165" role="code" l10n="NEW">b = INTERCEPT(Data_Y ;Data_X) </paragraph>
+<paragraph xml-lang="en-US" id="par_id7951902" role="code" l10n="NEW">m = SLOPE(Data_Y;Data_X)</paragraph>
+<paragraph xml-lang="en-US" id="par_id6637165" role="code" l10n="NEW">b = INTERCEPT(Data_Y ;Data_X)</paragraph>
<paragraph xml-lang="en-US" id="par_id7879268" role="paragraph" l10n="NEW">Calculate the coefficient of determination by</paragraph>
-<paragraph xml-lang="en-US" id="par_id9244361" role="code" l10n="NEW">r² = RSQ(Data_Y;Data_X) </paragraph>
+<paragraph xml-lang="en-US" id="par_id9244361" role="code" l10n="NEW">r² = RSQ(Data_Y;Data_X)</paragraph>
<paragraph xml-lang="en-US" id="par_id2083498" role="paragraph" l10n="NEW">Besides m, b and r² the array function <emph>LINEST</emph> provides additional statistics for a regression analysis.</paragraph>
<paragraph xml-lang="en-US" id="hd_id2538834" role="heading" level="2" l10n="NEW">The logarithm regression equation</paragraph>
<paragraph xml-lang="en-US" id="par_id394299" role="paragraph" l10n="NEW">The <emph>logarithm regression</emph> follows the equation <item type="literal">y=a*ln(x)+b</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_id2134159" role="code" l10n="NEW">a = SLOPE(Data_Y;LN(Data_X)) </paragraph>
-<paragraph xml-lang="en-US" id="par_id5946531" role="code" l10n="NEW">b = INTERCEPT(Data_Y ;LN(Data_X)) </paragraph>
-<paragraph xml-lang="en-US" id="par_id5649281" role="code" l10n="NEW">r² = RSQ(Data_Y;LN(Data_X)) </paragraph>
+<paragraph xml-lang="en-US" id="par_id2134159" role="code" l10n="NEW">a = SLOPE(Data_Y;LN(Data_X))</paragraph>
+<paragraph xml-lang="en-US" id="par_id5946531" role="code" l10n="NEW">b = INTERCEPT(Data_Y ;LN(Data_X))</paragraph>
+<paragraph xml-lang="en-US" id="par_id5649281" role="code" l10n="NEW">r² = RSQ(Data_Y;LN(Data_X))</paragraph>
<paragraph xml-lang="en-US" id="hd_id7874080" role="heading" level="2" l10n="NEW">The exponential regression equation</paragraph>
-<paragraph xml-lang="en-US" id="par_id4679097" role="paragraph" l10n="CHG"> 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 xml-lang="en-US" id="par_id4679097" role="paragraph" l10n="CHG"> 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 xml-lang="en-US" id="par_id9112216" role="paragraph" l10n="NEW">The exponential regression follows the equation <item type="literal">y=b*exp(a*x)</item> or <item type="literal">y=b*m^x</item>, 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 xml-lang="en-US" id="par_id4416638" role="code" l10n="NEW">a = SLOPE(LN(Data_Y);Data_X) </paragraph>
+<paragraph xml-lang="en-US" id="par_id4416638" role="code" l10n="NEW">a = SLOPE(LN(Data_Y);Data_X)</paragraph>
<paragraph xml-lang="en-US" id="par_id1039155" role="paragraph" l10n="CHG">The variables for the second variation are calculated as follows:</paragraph>
-<paragraph xml-lang="en-US" id="par_id7184057" role="code" l10n="NEW">m = EXP(SLOPE(LN(Data_Y);Data_X)) </paragraph>
-<paragraph xml-lang="en-US" id="par_id786767" role="code" l10n="NEW">b = EXP(INTERCEPT(LN(Data_Y);Data_X)) </paragraph>
+<paragraph xml-lang="en-US" id="par_id7184057" role="code" l10n="NEW">m = EXP(SLOPE(LN(Data_Y);Data_X))</paragraph>
+<paragraph xml-lang="en-US" id="par_id786767" role="code" l10n="NEW">b = EXP(INTERCEPT(LN(Data_Y);Data_X))</paragraph>
<paragraph xml-lang="en-US" id="par_id7127292" role="paragraph" l10n="NEW">Calculate the coefficient of determination by</paragraph>
-<paragraph xml-lang="en-US" id="par_id5437177" role="code" l10n="NEW">r² = RSQ(LN(Data_Y);Data_X) </paragraph>
+<paragraph xml-lang="en-US" id="par_id5437177" role="code" l10n="NEW">r² = RSQ(LN(Data_Y);Data_X)</paragraph>
<paragraph xml-lang="en-US" id="par_id6946317" role="paragraph" l10n="NEW">Besides m, b and r² the array function LOGEST provides additional statistics for a regression analysis.</paragraph>
<paragraph xml-lang="en-US" id="hd_id6349375" role="heading" level="2" l10n="NEW">The power regression equation</paragraph>
<paragraph xml-lang="en-US" id="par_id1857661" role="paragraph" l10n="NEW"> 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^a</item> , which is transformed to <item type="literal">ln(y)=ln(b)+a*ln(x)</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_id8517105" role="code" l10n="NEW">a = SLOPE(LN(Data_Y);LN(Data_X)) </paragraph>
-<paragraph xml-lang="en-US" id="par_id9827265" role="code" l10n="NEW">b = EXP(INTERCEPT(LN(Data_Y);LN(Data_X)) </paragraph>
-<paragraph xml-lang="en-US" id="par_id2357249" role="code" l10n="NEW">r² = RSQ(LN(Data_Y);LN(Data_X)) </paragraph>
+<paragraph xml-lang="en-US" id="par_id8517105" role="code" l10n="NEW">a = SLOPE(LN(Data_Y);LN(Data_X))</paragraph>
+<paragraph xml-lang="en-US" id="par_id9827265" role="code" l10n="NEW">b = EXP(INTERCEPT(LN(Data_Y);LN(Data_X))</paragraph>
+<paragraph xml-lang="en-US" id="par_id2357249" role="code" l10n="NEW">r² = RSQ(LN(Data_Y);LN(Data_X))</paragraph>
<paragraph xml-lang="en-US" id="hd_id9204077" role="heading" level="2" l10n="NEW">Constraints<comment>UFI: is this still so?</comment></paragraph>
<paragraph xml-lang="en-US" id="par_id7393719" role="paragraph" l10n="CHG"> The calculation of the trend line considers only data pairs with the following values:</paragraph>
<list type="ordered">
@@ -129,9 +129,9 @@
</list>
<paragraph xml-lang="en-US" id="par_id181279" role="paragraph" l10n="NEW">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 xml-lang="en-US" id="hd_id7907040" role="heading" level="2" l10n="NEW">The polynomial regression equation</paragraph>
-<paragraph xml-lang="en-US" id="par_id8918729" role="paragraph" l10n="NEW">A <emph>polynomial regression</emph> curve cannot be added automatically. You must calculate this curve manually. </paragraph>
-<paragraph xml-lang="en-US" id="par_id33875" role="paragraph" l10n="NEW">Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n. </paragraph>
-<paragraph xml-lang="en-US" id="par_id8720053" role="paragraph" l10n="NEW">Use the formula <item type="literal">=LINEST(Data_Y,Data_X)</item> with the complete range x to xⁿ (without headings) as Data_X. </paragraph>
+<paragraph xml-lang="en-US" id="par_id8918729" role="paragraph" l10n="NEW">A <emph>polynomial regression</emph> curve cannot be added automatically. You must calculate this curve manually.</paragraph>
+<paragraph xml-lang="en-US" id="par_id33875" role="paragraph" l10n="NEW">Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n.</paragraph>
+<paragraph xml-lang="en-US" id="par_id8720053" role="paragraph" l10n="NEW">Use the formula <item type="literal">=LINEST(Data_Y,Data_X)</item> with the complete range x to xⁿ (without headings) as Data_X.</paragraph>
<paragraph xml-lang="en-US" id="par_id5068514" role="paragraph" l10n="NEW">The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position.</paragraph>
<paragraph xml-lang="en-US" id="par_id8202154" role="paragraph" l10n="NEW">The first element of the third row of the LINEST output is the value of r². See the <link href="text/scalc/01/04060107.xhp#Section8">LINEST</link> function for details on proper use and an explanation of the other output parameters.</paragraph>
<section id="relatedtopics">
diff --git a/main/helpcontent2/source/text/schart/01/05020201.xhp b/main/helpcontent2/source/text/schart/01/05020201.xhp
index da977072fc..28ff163820 100644
--- a/main/helpcontent2/source/text/schart/01/05020201.xhp
+++ b/main/helpcontent2/source/text/schart/01/05020201.xhp
@@ -42,7 +42,7 @@
<paragraph role="heading" id="hd_id3145750" xml-lang="en-US" level="2" l10n="U" oldref="71">Show labels</paragraph>
<paragraph role="paragraph" id="par_id3154319" xml-lang="en-US" l10n="U" oldref="72"><ahelp hid="SCH:CHECKBOX:TP_AXIS_LABEL:CB_AXIS_LABEL_SCHOW_DESCR">Specifies whether to show or hide the axis labels.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/.uno:ToggleAxisDescr" id="bm_id3150012" localize="false"/>
-<paragraph role="paragraph" id="par_id3147436" xml-lang="en-US" l10n="CHG" oldref="75"><variable id="sytextbeschr"><ahelp hid=".uno:ToggleAxisDescr">The<emph> AxesTitle On/Off </emph>icon on the <emph>Formatting</emph> bar switches the labeling of all axes on or off.</ahelp>
+<paragraph role="paragraph" id="par_id3147436" xml-lang="en-US" l10n="CHG" oldref="75"><variable id="sytextbeschr"><ahelp hid=".uno:ToggleAxisDescr">The <emph>AxesTitle On/Off</emph> icon on the <emph>Formatting</emph> bar switches the labeling of all axes on or off.</ahelp>
</variable></paragraph>
<embed href="text/schart/00/00000004.xhp#achsenalle"/>
<section id="schreibr">
diff --git a/main/helpcontent2/source/text/schart/01/choose_chart_type.xhp b/main/helpcontent2/source/text/schart/01/choose_chart_type.xhp
index 65d06f2f96..83186b1f3f 100644
--- a/main/helpcontent2/source/text/schart/01/choose_chart_type.xhp
+++ b/main/helpcontent2/source/text/schart/01/choose_chart_type.xhp
@@ -31,7 +31,7 @@
<body>
<paragraph xml-lang="en-US" id="hd_id9072237" role="heading" level="1" l10n="NEW"><variable id="choose_chart_type"><link href="text/schart/01/choose_chart_type.xhp">Choosing a Chart Type</link>
</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id7085787" role="paragraph" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
+<paragraph xml-lang="en-US" id="par_id7085787" role="paragraph" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
diff --git a/main/helpcontent2/source/text/schart/01/three_d_view.xhp b/main/helpcontent2/source/text/schart/01/three_d_view.xhp
index 06c9ac3468..d6d0b7cfdc 100644
--- a/main/helpcontent2/source/text/schart/01/three_d_view.xhp
+++ b/main/helpcontent2/source/text/schart/01/three_d_view.xhp
@@ -42,10 +42,10 @@
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
<embed href="text/shared/00/00000001.xhp#ShiftF1"/>
-<paragraph xml-lang="en-US" id="par_id6942045" role="paragraph" l10n="NEW">The chart preview responds to the new settings that you enter in the dialog. </paragraph>
+<paragraph xml-lang="en-US" id="par_id6942045" role="paragraph" l10n="NEW">The chart preview responds to the new settings that you enter in the dialog.</paragraph>
<list type="unordered">
<listitem>
-<paragraph xml-lang="en-US" id="par_id3806878" role="paragraph" l10n="NEW">When you leave the dialog with OK, the settings are applied permanently. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3806878" role="paragraph" l10n="NEW">When you leave the dialog with OK, the settings are applied permanently.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_id130619" role="paragraph" l10n="NEW">When you leave the dialog with Cancel or Escape, the chart returns to the state when you opened the dialog.</paragraph>
@@ -64,7 +64,7 @@
<paragraph xml-lang="en-US" id="par_id7869502" role="paragraph" l10n="NEW">The rotations are applied in the order first x, then y, last z.</paragraph>
<paragraph xml-lang="en-US" id="par_id9852900" role="paragraph" l10n="NEW">When shading is enabled and you rotate a chart, the lights are rotated as if they are fixed to the chart.</paragraph>
<paragraph xml-lang="en-US" id="par_id2578203" role="note" l10n="NEW">The rotation axes always relate to the page, not to the chart's axes. This is different from some other chart programs.</paragraph>
-<paragraph xml-lang="en-US" id="par_id4923245" role="paragraph" l10n="NEW">Select the Perspective check box to view the chart in central perspective as through a camera lens instead of using a parallel projection. </paragraph>
+<paragraph xml-lang="en-US" id="par_id4923245" role="paragraph" l10n="NEW">Select the Perspective check box to view the chart in central perspective as through a camera lens instead of using a parallel projection.</paragraph>
<paragraph xml-lang="en-US" id="par_id3416547" role="paragraph" l10n="NEW">Set the focus length with the spin button. 100% gives a perspective view where a far edge in the chart looks approximately half as big as a near edge.</paragraph>
<paragraph xml-lang="en-US" id="par_id3791924" role="note" l10n="NEW">Older versions of %PRODUCTNAME cannot display the percentage of perspective the same way as the current version.</paragraph><comment>Right-angled axes</comment>
<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_3D_SCENEGEOMETRY:CBX_RIGHT_ANGLED_AXES" id="bm_id5293740" localize="false"/>
@@ -90,8 +90,8 @@
<paragraph xml-lang="en-US" id="par_id7141026" role="paragraph" l10n="NEW">If you mark or unmark a combination of check boxes that is not given by the Realistic or Simple scheme, you create a Custom scheme.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id1579027" role="paragraph" l10n="NEW">Mark <emph>Shading</emph> to use the Gouraud method for rendering the surface, otherwise a flat method is used. </paragraph>
-<paragraph xml-lang="en-US" id="par_id5624561" role="paragraph" l10n="NEW">The flat method sets a single color and brightness for each polygon. The edges are visible, soft gradients and spot lights are not possible. </paragraph>
+<paragraph xml-lang="en-US" id="par_id1579027" role="paragraph" l10n="NEW">Mark <emph>Shading</emph> to use the Gouraud method for rendering the surface, otherwise a flat method is used.</paragraph>
+<paragraph xml-lang="en-US" id="par_id5624561" role="paragraph" l10n="NEW">The flat method sets a single color and brightness for each polygon. The edges are visible, soft gradients and spot lights are not possible.</paragraph>
<paragraph xml-lang="en-US" id="par_id5901058" role="paragraph" l10n="NEW">The Gouraud method applies gradients for a smoother, more realistic look.<comment>Regina: Need an external article on web, which describes the 3D engine in detail. Till that, the user should get some information on Gouraud and Flat.</comment></paragraph>
</listitem>
</list>
diff --git a/main/helpcontent2/source/text/schart/01/type_column_bar.xhp b/main/helpcontent2/source/text/schart/01/type_column_bar.xhp
index de4657dd53..8fbeddf671 100644
--- a/main/helpcontent2/source/text/schart/01/type_column_bar.xhp
+++ b/main/helpcontent2/source/text/schart/01/type_column_bar.xhp
@@ -36,7 +36,7 @@
</bookmark><comment>mw made one entry out of two "charts types;"</comment>
<paragraph role="heading" id="hd_id649433" xml-lang="en-US" level="1" l10n="NEW"><variable id="type_column_bar"><link href="text/schart/01/type_column_bar.xhp">Chart Type Column and Bar</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3430585" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
+<paragraph role="paragraph" id="par_id3430585" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
diff --git a/main/helpcontent2/source/text/schart/01/type_line.xhp b/main/helpcontent2/source/text/schart/01/type_line.xhp
index 514d8f112d..52c78135a6 100644
--- a/main/helpcontent2/source/text/schart/01/type_line.xhp
+++ b/main/helpcontent2/source/text/schart/01/type_line.xhp
@@ -35,7 +35,7 @@
</bookmark>
<paragraph role="heading" id="hd_id9422894" xml-lang="en-US" level="1" l10n="NEW"><variable id="type_line"><link href="text/schart/01/type_line.xhp">Chart Type Line</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id389721" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
+<paragraph role="paragraph" id="par_id389721" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
diff --git a/main/helpcontent2/source/text/schart/01/type_net.xhp b/main/helpcontent2/source/text/schart/01/type_net.xhp
index 8e0d9f4c9d..02661b482c 100644
--- a/main/helpcontent2/source/text/schart/01/type_net.xhp
+++ b/main/helpcontent2/source/text/schart/01/type_net.xhp
@@ -36,7 +36,7 @@
</bookmark>
<paragraph role="heading" id="hd_id1990722" xml-lang="en-US" level="1" l10n="NEW"><variable id="type_net"><link href="text/schart/01/type_net.xhp">Chart Type Net</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id40589" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
+<paragraph role="paragraph" id="par_id40589" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
diff --git a/main/helpcontent2/source/text/schart/01/type_pie.xhp b/main/helpcontent2/source/text/schart/01/type_pie.xhp
index a1ce11af80..e35e60b932 100644
--- a/main/helpcontent2/source/text/schart/01/type_pie.xhp
+++ b/main/helpcontent2/source/text/schart/01/type_pie.xhp
@@ -36,7 +36,7 @@
</bookmark><comment>mw made one index entry out of two "chart types;"</comment><comment>mw made "pie charts" a two level entry</comment>
<paragraph xml-lang="en-US" id="hd_id3365276" role="heading" level="1" l10n="NEW"><variable id="type_pie"><link href="text/schart/01/type_pie.xhp">Chart Type Pie</link>
</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id245979" role="paragraph" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
+<paragraph xml-lang="en-US" id="par_id245979" role="paragraph" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
diff --git a/main/helpcontent2/source/text/schart/01/type_stock.xhp b/main/helpcontent2/source/text/schart/01/type_stock.xhp
index 24c2fb530a..8098ae1835 100644
--- a/main/helpcontent2/source/text/schart/01/type_stock.xhp
+++ b/main/helpcontent2/source/text/schart/01/type_stock.xhp
@@ -222,7 +222,7 @@
<paragraph xml-lang="en-US" id="hd_id399182" role="heading" level="2" l10n="NEW">Charts based on its own data</paragraph>
<paragraph xml-lang="en-US" id="par_id5298318" role="paragraph" l10n="NEW">To change the data series of a chart having its own data, choose <link href="text/schart/01/03010000.xhp">Chart Data Table</link> from the View menu or from the context menu of the chart in edit mode.</paragraph>
<paragraph xml-lang="en-US" id="par_id7588732" role="paragraph" l10n="NEW">In an embedded chart data table, the data series are always organized in columns.</paragraph>
-<paragraph xml-lang="en-US" id="par_id95828" role="paragraph" l10n="CHG">For a new stock chart first use a column chart. Add the columns you need and enter your data in the order which is shown in the example, omitting any columns not required for the desired variant. Use Move Series Right to change the column order. Close the chart data table. Now use the Chart Type dialog to change to the stock chart variant. </paragraph>
+<paragraph xml-lang="en-US" id="par_id95828" role="paragraph" l10n="CHG">For a new stock chart first use a column chart. Add the columns you need and enter your data in the order which is shown in the example, omitting any columns not required for the desired variant. Use Move Series Right to change the column order. Close the chart data table. Now use the Chart Type dialog to change to the stock chart variant.</paragraph>
<paragraph xml-lang="en-US" id="par_id6182744" role="paragraph" l10n="NEW">If you have already got a stock chart and you want to change the variant, then first change the chart type to a column chart, add or remove columns so that it fits to the variant, and then change the chart type back to a stock chart.<comment>Watch issue 72433 to see whether a change in the handling is done.</comment></paragraph>
<paragraph xml-lang="en-US" id="par_id3496200" role="paragraph" l10n="NEW">Do not write the name of a data series in a row. Write the name into the field above the role name.</paragraph>
<paragraph xml-lang="en-US" id="par_id7599108" role="paragraph" l10n="CHG">The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order.</paragraph>
diff --git a/main/helpcontent2/source/text/schart/01/type_xy.xhp b/main/helpcontent2/source/text/schart/01/type_xy.xhp
index 12f05d6fed..4bf3f0d67f 100644
--- a/main/helpcontent2/source/text/schart/01/type_xy.xhp
+++ b/main/helpcontent2/source/text/schart/01/type_xy.xhp
@@ -42,7 +42,7 @@
</bookmark><comment>mw changed xy to XY (2x)</comment>
<paragraph role="heading" id="hd_id9346598" xml-lang="en-US" level="1" l10n="NEW"><variable id="type_xy"><link href="text/schart/01/type_xy.xhp">Chart Type XY (Scatter)</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id2003845" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type. </paragraph>
+<paragraph role="paragraph" id="par_id2003845" xml-lang="en-US" l10n="NEW">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can choose a chart type.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#wiz"/>
</section>
@@ -71,9 +71,9 @@
<paragraph role="paragraph" id="par_id0805200810492449" xml-lang="en-US" l10n="NEW">For 2D charts, you can choose <item type="menuitem">Insert - Y Error Bars</item> to enable the display of error bars.</paragraph>
<paragraph role="paragraph" id="par_id6221198" xml-lang="en-US" l10n="NEW">You can enable the display of mean value lines and trend lines using commands on the Insert menu.</paragraph>
<paragraph role="heading" id="hd_id1393475" xml-lang="en-US" level="3" l10n="NEW">Points only</paragraph>
-<paragraph role="paragraph" id="par_id6571550" xml-lang="en-US" l10n="NEW">Each data point is shown by an icon. %PRODUCTNAME uses default icons with different forms and colors for each data series. The default colors are set in <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Charts - Default Colors</item>. </paragraph>
+<paragraph role="paragraph" id="par_id6571550" xml-lang="en-US" l10n="NEW">Each data point is shown by an icon. %PRODUCTNAME uses default icons with different forms and colors for each data series. The default colors are set in <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Charts - Default Colors</item>.</paragraph>
<paragraph role="heading" id="hd_id5376140" xml-lang="en-US" level="3" l10n="NEW">Lines Only</paragraph>
-<paragraph role="paragraph" id="par_id4408093" xml-lang="en-US" l10n="NEW">This variant draws straight lines from one data point to the next. The data points are not shown by icons. </paragraph>
+<paragraph role="paragraph" id="par_id4408093" xml-lang="en-US" l10n="NEW">This variant draws straight lines from one data point to the next. The data points are not shown by icons.</paragraph>
<paragraph role="paragraph" id="par_id7261268" xml-lang="en-US" l10n="NEW">The drawing order is the same as the order in the data series. Mark <emph>Sort by X Values</emph> to draw the lines in the order of the x values. This sorting applies only to the chart, not to the data in the table.</paragraph>
<paragraph role="heading" id="hd_id6949369" xml-lang="en-US" level="3" l10n="NEW">Points and Lines</paragraph>
<paragraph role="paragraph" id="par_id9611499" xml-lang="en-US" l10n="NEW">This variant shows points and lines at the same time.</paragraph>
@@ -83,7 +83,7 @@
<paragraph role="paragraph" id="par_id7957396" xml-lang="en-US" l10n="CHG">Mark <emph>Smooth Lines</emph> to draw curves instead of straight line segments.<comment>i80587</comment></paragraph>
<paragraph role="paragraph" id="par_id1202124" xml-lang="en-US" l10n="NEW">Click <emph>Properties</emph> to set details for the curves.</paragraph>
<paragraph role="paragraph" id="par_id5989562" xml-lang="en-US" l10n="NEW">
-<emph>Cubic Spline</emph> interpolates your data points with polynomials of degree 3. The transitions between the polynomial pieces are smooth, having the same slope and curvature. </paragraph>
+<emph>Cubic Spline</emph> interpolates your data points with polynomials of degree 3. The transitions between the polynomial pieces are smooth, having the same slope and curvature.</paragraph>
<paragraph role="paragraph" id="par_id6128421" xml-lang="en-US" l10n="NEW">The <emph>Resolution</emph> determines how many line segments are calculated to draw a piece of polynomial between two data points. You can see the intermediate points if you click any data point.</paragraph>
<paragraph role="paragraph" id="par_id9280373" xml-lang="en-US" l10n="NEW">
<emph>B-Spline</emph> uses the data points as control points to form a B-spline curve. Those curves are built piecewise from polynomials. The <emph>Data points order</emph> sets the degree k of these polynomials. <comment>Besides the first and last point the curve doesn't go through the data points but lays inside the convex hull of each k+1 adjacent data points. Having Resolution r and n+1 data points, r times n uniform line segments are used to draw the whole curve.</comment></paragrap [...]
diff --git a/main/helpcontent2/source/text/schart/01/wiz_data_series.xhp b/main/helpcontent2/source/text/schart/01/wiz_data_series.xhp
index 6dc2027ef5..ff05b67564 100644
--- a/main/helpcontent2/source/text/schart/01/wiz_data_series.xhp
+++ b/main/helpcontent2/source/text/schart/01/wiz_data_series.xhp
@@ -80,7 +80,7 @@
<paragraph role="paragraph" id="par_id9222693" xml-lang="en-US" l10n="NEW">Enter or select a cell range that will be used as text for categories or data labels. <comment>UFI: red text means what?</comment></paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id9500106" xml-lang="en-US" l10n="NEW">Depending on the chart type, the texts are shown on the X axis or as data labels. </paragraph><comment>Regina: If you enter a range here, the check box "First column as label" (assumed data series in columns) on the Data Range page of the dialog is marked automatically and if you erase the entry in the input field, it is unchecked automatically.</comment><comment>data series list box</comment>
+<paragraph role="paragraph" id="par_id9500106" xml-lang="en-US" l10n="NEW">Depending on the chart type, the texts are shown on the X axis or as data labels.</paragraph><comment>Regina: If you enter a range here, the check box "First column as label" (assumed data series in columns) on the Data Range page of the dialog is marked automatically and if you erase the entry in the input field, it is unchecked automatically.</comment><comment>data series list box</comment>
<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_SERIES_LIST" id="bm_id1831" localize="false"/><paragraph role="paragraph" id="par_id5201879" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Shows a list of all data series in the chart. Click an entry to view and edit that data series. Click <emph>Add</emph> to insert a new series into the list after the selected entry.</ahelp></paragraph><comment>data ranges list box</comment>
<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_DATA_RANGES_LIST" id="bm_id6718649" localize="false"/><paragraph role="paragraph" id="par_id2571794" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Shows all the data ranges used by the data series that is selected in the Data Series list box. Each data range shows the role name and the source range address.</ahelp></paragraph><comment>range for ... & shrinky</comment>
<bookmark xml-lang="en-US" branch="hid/chart2:Edit:TP_DATA_SOURCE:EDT_RANGE" id="bm_id1857051" localize="false"/>