hcshared29: end-of-year commitment

3 files changed, 30 insertions, 11 deletions

diff --git a/helpcontent2/source/text/schart/01/03010000.xhp b/helpcontent2/source/text/schart/01/03010000.xhp
index 4dbab4c7c8..f329660a9d 100644
--- a/helpcontent2/source/text/schart/01/03010000.xhp
+++ b/helpcontent2/source/text/schart/01/03010000.xhp
@@ -6,7 +6,7 @@
  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
@@ -87,6 +87,7 @@
 <bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_DELETE_COL" id="bm_id3153959" localize="false"/><comment>delete series</comment><paragraph role="paragraph" id="par_id3153336" xml-lang="en-US" l10n="U" oldref="29"><ahelp hid="." visibility="hidden">Deletes the current series or text column. It is not possible to delete the first text column.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_SWAP_COL" id="bm_id8501846" localize="false"/><comment>move series right</comment><paragraph role="paragraph" id="par_id4089175" xml-lang="en-US" l10n="CHG"><ahelp hid="." visibility="hidden">Switches the current column with its neighbor at the right.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_SWAP_ROW" id="bm_id4469130" localize="false"/><comment>move row down</comment><paragraph role="paragraph" id="par_id3949095" xml-lang="en-US" l10n="CHG"><ahelp hid="." visibility="hidden">Switches the current row with its neighbor below.</ahelp></paragraph><comment>edit fields, see i72361</comment>
+<bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_TBI_DATA_TOGGLE_DATE_CATEGORIES" id="bm_id990469130" localize="false"/><comment>Categories: Date/Text</comment><paragraph role="paragraph" id="par_id990949095" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">For a category axis that might be a date axis, you can change the formatting of the data from Date to Text.</ahelp></paragraph><comment>see i115840</comment>
 <bookmark xml-lang="en-US" branch="hid/CHART2_HID_SCH_DATA_SERIES_LABEL" id="bm_id3522446" localize="false"/><paragraph role="paragraph" id="par_id6697286" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter names for the data series.</ahelp></paragraph>
 </body>
 </helpdocument>
diff --git a/helpcontent2/source/text/schart/01/04050100.xhp b/helpcontent2/source/text/schart/01/04050100.xhp
index 6637b9a28a..e22c1fad51 100644
--- a/helpcontent2/source/text/schart/01/04050100.xhp
+++ b/helpcontent2/source/text/schart/01/04050100.xhp
@@ -43,10 +43,11 @@
       <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"/>
 <paragraph xml-lang="en-US" id="hd_id5409405" role="heading" level="1" l10n="CHG"><variable id="regression"><link href="text/schart/01/04050100.xhp">Trend Lines</link>
 </variable></paragraph>
-      <paragraph xml-lang="en-US" id="par_id7272255" role="paragraph" l10n="CHG"><variable id="trendlinestext"><ahelp hid=".">Regression curves, also known as trend lines, can be added to all 2D chart types except for Pie and Stock charts.</ahelp>
+      <paragraph xml-lang="en-US" id="par_id7272255" role="paragraph" l10n="CHG"><variable id="trendlinestext"><ahelp hid=".">Trend lines can be added to all 2D chart types except for Pie and Stock charts.</ahelp>
 </variable></paragraph>
       <embed href="text/schart/01/04030000.xhp#context"/>
       <section id="howtoget">
@@ -89,10 +90,10 @@
 <bookmark xml-lang="en-US" branch="hid/.uno:InsertTrendlineEquation" id="bm_id2754600" localize="false"/>
 <paragraph xml-lang="en-US" id="par_id846888" role="paragraph" l10n="NEW"><ahelp hid=".">To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose <emph>Insert Trend Line Equation</emph>.</ahelp></paragraph>
       <paragraph xml-lang="en-US" id="par_id8962065" role="paragraph" l10n="CHG">When the chart is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the coefficient of determination R². Click on the trend line to see the information in the status bar.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id1328470" role="note" l10n="NEW">For a category chart (for example a line chart), the regression information is calculated using numbers 1, 2, 3, … as x-values. This is also true if your data series uses other numbers as names for the x-values. For such charts the XY chart type might be more suitable.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id8092593" role="paragraph" l10n="CHG">To show the equation and the coefficient of determination, select the regression curve and choose <item type="menuitem">Format - Format Selection - Equation</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_id7971434" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Enable Show equation to see the equation of the regression curve.</ahelp></paragraph><comment>hid</comment>
-<paragraph xml-lang="en-US" id="par_id558793" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Enable Show Coefficient of Determination to see the determination coefficient of the regression curve.</ahelp></paragraph>
+      <paragraph xml-lang="en-US" id="par_id1328470" role="note" l10n="CHG">For a category chart (for example a line chart), the trend line information is calculated using numbers 1, 2, 3, … as x-values. This is also true if your data series uses other numbers as names for the x-values. For such charts the XY chart type might be more suitable.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id8092593" role="paragraph" l10n="CHG">To show the equation and the coefficient of determination, select the trend line and choose <item type="menuitem">Format - Format Selection - Equation</item>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id7971434" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Enable Show equation to see the equation of the trend line.</ahelp></paragraph><comment>hid</comment>
+<paragraph xml-lang="en-US" id="par_id558793" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Enable Show Coefficient of Determination to see the determination coefficient of the trend line.</ahelp></paragraph>
       <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>
@@ -107,7 +108,7 @@
       <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="NEW"> For exponential regression curves 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_id1039155" role="paragraph" l10n="CHG">The variables for the second variation are calculated as follows:</paragraph>
diff --git a/helpcontent2/source/text/schart/01/05040201.xhp b/helpcontent2/source/text/schart/01/05040201.xhp
index aa195e17f5..d11dad84d4 100644
--- a/helpcontent2/source/text/schart/01/05040201.xhp
+++ b/helpcontent2/source/text/schart/01/05040201.xhp
@@ -46,12 +46,12 @@
 <bookmark_value>Y axes; scaling</bookmark_value>
 </bookmark><comment>mw changed "axes;scaling" to "Y axes, scaling"</comment>
 <paragraph role="heading" id="hd_id3150868" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/schart/01/05040201.xhp" name="Scale">Scale</link></paragraph>
-<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="U" oldref="2">Controls the scaling of the Y axis. The X axis can also be scaled here for X-Y charts.</paragraph>
+<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="CHG" oldref="2">Controls the scaling of the X or Y axis.</paragraph>
 </section>
 <section id="howtoget">
 <embed href="text/schart/00/00000004.xhp#frtysk"/>
 </section>
-<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="79">The Y axis is automatically scaled by $[officename] so that all values are optimally displayed.</paragraph>
+<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="CHG" oldref="79">The axes are automatically scaled by $[officename] so that all values are optimally displayed.</paragraph>
 <paragraph role="paragraph" id="par_id3149379" xml-lang="en-US" l10n="U" oldref="3">To achieve specific results, you can manually change the axis scaling. For example, you can display only the top areas of the columns by shifting the zero line upwards.</paragraph>
 <paragraph role="heading" id="hd_id3154730" xml-lang="en-US" level="2" l10n="U" oldref="4">Scale</paragraph>
 <paragraph role="paragraph" id="par_id3149400" xml-lang="en-US" l10n="CHG" oldref="5">You can enter values for subdividing axes in this area. You can automatically set the properties <emph>Minimum, Maximum, Major interval, Minor interval count</emph> and <emph>Reference value</emph>.</paragraph>
@@ -90,6 +90,7 @@
 <bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_AUTO_ORIGIN" id="bm_id6670125" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/CHART2_CHECKBOX_TP_SCALE_CBX_AUTO_ORIGIN" id="bm_id1006200803192265" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_AUTO_ORIGIN" id="bm_id1006200805190759" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_AUTO_TIME_RESOLUTION" id="bm_id10087605190759" localize="false"/>
 <paragraph role="heading" id="hd_id3166432" xml-lang="en-US" level="3" l10n="U" oldref="62">Automatic</paragraph>
 <paragraph role="paragraph" id="par_id3145389" xml-lang="en-US" l10n="U" oldref="63"><ahelp hid="SCH:CHECKBOX:TP_SCALE:CBX_AUTO_ORIGIN">You must first deselect the <emph>Automatic</emph> option in order to modify the values.</ahelp></paragraph>
 <paragraph role="note" id="par_id3149129" xml-lang="en-US" l10n="U" oldref="64">Disable this feature if you are working with "fixed" values, as it does not permit automatic scaling.</paragraph>
@@ -98,9 +99,25 @@
 <paragraph role="heading" id="hd_id3159206" xml-lang="en-US" level="3" l10n="U" oldref="16">Logarithmic scale</paragraph>
 <paragraph role="paragraph" id="par_id3145360" xml-lang="en-US" l10n="CHG" oldref="17"><ahelp hid="SCH:CHECKBOX:TP_SCALE:CBX_LOGARITHM">Specifies that you want the axis to be subdivided logarithmically.</ahelp></paragraph>
 <paragraph role="note" id="par_id3153956" xml-lang="en-US" l10n="U" oldref="61">Use this feature if you are working with values that differ sharply from each other. You can use logarithmic scaling to make the grid lines of the axis equidistant but have values that may increase or decrease.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_REVERSE" id="bm_id4007080" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_REVERSE" id="bm_id1024200803164240" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_REVERSE:Category" id="bm_id4007080" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_REVERSE:ValueAxis" id="bm_id1024200803164240" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_SCALE:CBX_REVERSE_MayBeDateAxis" id="bm_id109575190759" localize="false"/>
+
 <paragraph role="heading" id="hd_id9941404" xml-lang="en-US" level="3" l10n="NEW">Reverse direction</paragraph>
 <paragraph role="paragraph" id="par_id5581835" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Defines where the lower and where the higher values are displayed at the axis. The unchecked state is the mathematical direction.</ahelp> That means for Cartesian coordinate systems that the x-axis shows the lower values on the left and the y-axis shows the lower values at the bottom. For polar coordinate systems the mathematical angle axis direction is counterclockwise and the radial axis is from inner to outer.</paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_SCALE:LB_AXIS_TYPE" id="bm_id10022759" localize="false"/>
+<paragraph role="heading" id="hd_id922204" xml-lang="en-US" level="3" l10n="NEW">Type</paragraph>
+<paragraph role="paragraph" id="par_id59225" xml-lang="en-US" l10n="NEW"><ahelp hid=".">For some types of axes, you can select to format an axis as text or date, or to detect the type automatically.</ahelp> For the axis type "Date" you can set the following options.</paragraph>
+<paragraph role="paragraph" id="par_id1159225" xml-lang="en-US" l10n="NEW">Minimum and maximum value to be shown on the ends of the scale.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_SCALE:LB_TIME_RESOLUTION" id="bm_id1344759" localize="false"/>
+<paragraph role="paragraph" id="par_id2259225" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Resolution can be set to show days, months, or years as interval steps.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_SCALE:MT_MAIN_DATE_STEP" id="bm_id2210022759" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_SCALE:LB_MAIN_TIME_UNIT" id="bm_id1033022759" localize="false"/>
+<paragraph role="paragraph" id="par_id3359225" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Major interval can be set to show a certain number of days, months, or years.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_SCALE:LB_HELP_TIME_UNIT" id="bm_id1472759" localize="false"/>
+<paragraph role="paragraph" id="par_id4459225" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Minor interval can be set to show a certain number of days, months, or years.</ahelp></paragraph>
+
 </body>
 </helpdocument>