tdf#106623 Write help page for PIVOT CHART

+ Added example file
+ with inputs from Tomasz Vajngerl
+ remove a spurious character slipped in set 1
+ fix DTD issue 01

Change-Id: I13ebce0241a2ae1e7dcac29945403607da0d1dfa
Reviewed-on: https://gerrit.libreoffice.org/53692
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

13 files changed, 290 insertions, 6 deletions

diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index a44ba5300b..ad9218de29 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -337,6 +337,12 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
     helpcontent2/source/text/scalc/guide/multitables \
     helpcontent2/source/text/scalc/guide/note_insert \
     helpcontent2/source/text/scalc/guide/numbers_text \
+    helpcontent2/source/text/scalc/guide/pivotchart \
+    helpcontent2/source/text/scalc/guide/pivotchart_create \
+    helpcontent2/source/text/scalc/guide/pivotchart_edit \
+    helpcontent2/source/text/scalc/guide/pivotchart_update \
+    helpcontent2/source/text/scalc/guide/pivotchart_filter \
+    helpcontent2/source/text/scalc/guide/pivotchart_delete \
     helpcontent2/source/text/scalc/guide/print_details \
     helpcontent2/source/text/scalc/guide/print_exact \
     helpcontent2/source/text/scalc/guide/print_landscape \
diff --git a/source/auxiliary/scalc.tree b/source/auxiliary/scalc.tree
index c579d85f60..172a56bec0 100644
--- a/source/auxiliary/scalc.tree
+++ b/source/auxiliary/scalc.tree
@@ -140,6 +140,14 @@
 <topic id="scalc/text/scalc/guide/datapilot_tipps.xhp">Selecting Pivot Table Output Ranges</topic>
 <topic id="scalc/text/scalc/guide/datapilot_updatetable.xhp">Updating Pivot Tables</topic>
 		</node>
+                <node id="08091" title="Pivot Chart">
+                    <topic id="scalc/text/scalc/guide/pivotchart.xhp">Pivot Chart</topic>
+                    <topic id="scalc/text/scalc/guide/pivotchart_create.xhp">Creating Pivot Charts</topic>
+                    <topic id="scalc/text/scalc/guide/pivotchart_edit.xhp">Editing Pivot Charts</topic>
+                    <topic id="scalc/text/scalc/guide/pivotchart_filter.xhp">Filtering Pivot Charts</topic>
+                    <topic id="scalc/text/scalc/guide/pivotchart_update.xhp">Updating Pivot Charts</topic>
+                    <topic id="scalc/text/scalc/guide/pivotchart_delete.xhp">Deleting Pivot Charts</topic>
+                </node>
 		<node id="0810" title="Scenarios">
 <topic id="scalc/text/scalc/guide/scenario.xhp">Using Scenarios</topic>
 		</node>
diff --git a/source/media/files/scalc/pivot.ods b/source/media/files/scalc/pivot.ods
new file mode 100644
index 0000000000..9360517267
--- /dev/null
+++ b/source/media/files/scalc/pivot.ods
diff --git a/source/media/helpimg/sc_PivotChartButtons.png b/source/media/helpimg/sc_PivotChartButtons.png
new file mode 100644
index 0000000000..d217ff6805
--- /dev/null
+++ b/source/media/helpimg/sc_PivotChartButtons.png
diff --git a/source/text/scalc/06/calcsamplefiles.xhp b/source/text/scalc/06/calcsamplefiles.xhp
index 64171b0831..7d7df8d87d 100644
--- a/source/text/scalc/06/calcsamplefiles.xhp
+++ b/source/text/scalc/06/calcsamplefiles.xhp
@@ -20,5 +20,8 @@
     <section id="trigon">
         <paragraph role="paragraph" id="par_id161521663319918" xml-lang="en-US"><object data="media/files/scalc/trigon.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
     </section>
+    <section id="pivot">
+        <paragraph role="paragraph" id="par_id161521663314918" xml-lang="en-US"><object data="media/files/scalc/pivot.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph>
+    </section>
     </body>
 </helpdocument>
diff --git a/source/text/scalc/guide/datapilot_deletetable.xhp b/source/text/scalc/guide/datapilot_deletetable.xhp
index 15d42f6e42..c53abbf180 100644
--- a/source/text/scalc/guide/datapilot_deletetable.xhp
+++ b/source/text/scalc/guide/datapilot_deletetable.xhp
@@ -33,6 +33,7 @@
 <paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1"><variable id="datapilot_deletetable"><link href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting Pivot Tables">Deleting Pivot Tables</link>
 </variable></paragraph>
       <paragraph xml-lang="en-US" id="par_id3154014" role="paragraph">In order to delete a pivot table, click any cell in the pivot table, then choose <emph>Delete</emph> in the context menu.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id141525148751543" role="warning">If you delete a pivot table linked to a pivot chart, the pivot chart is also deleted. A dialog box opens to confirm the pivot chart deletion.</paragraph>
       <section id="relatedtopics">
          <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
          <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
@@ -42,4 +43,4 @@
          <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
       </section>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/scalc/guide/pivotchart.xhp b/source/text/scalc/guide/pivotchart.xhp
new file mode 100644
index 0000000000..f71157b0b3
--- /dev/null
+++ b/source/text/scalc/guide/pivotchart.xhp
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="pivotchartintro" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">Pivot Chart</title>
+            <filename>/text/scalc/guide/pivotchart.xhp</filename>
+        </topic>
+    </meta>
+<body>
+    <bookmark xml-lang="en-US" branch="hid//path/to/dialog/widget" id="bm_id461525139708202" localize="false"/>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id541525139738752">
+        <bookmark_value>chart;pivot chart</bookmark_value>
+        <bookmark_value>pivot table;pivot chart</bookmark_value>
+    </bookmark>
+    <paragraph role="heading" id="hd_id141525139671420" level="1" xml-lang="en-US">Pivot Chart</paragraph>
+
+    <paragraph role="paragraph" id="par_id291525139878423" xml-lang="en-US">A pivot chart is a chart with data range and data series of a <link href="text/scalc/guide/datapilot.xhp" name="Pivot Table">pivot table</link>.</paragraph>
+    <paragraph role="paragraph" id="par_id911525139890364" xml-lang="en-US">Different from static sized tables, where the number of rows and columns are constant, pivot tables can have varying dimensions, depending on the pivot table settings and its data source contents.</paragraph>
+
+    <paragraph role="paragraph" id="par_id201525141351484" xml-lang="en-US">Pivot charts tracks the changes in the data issued from a pivot table and adjusts the data series and data range accordingly.</paragraph>
+    <embed href="text/shared/00/00000004.xhp#samplefile"/>
+    <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id741525141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_create.xhp" name="Creating pivot charts">Creating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id281525144162940" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_edit.xhp" name="Edit Pivot Chart">Editing Pivot Charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741825141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_filter.xhp" name="Filtering pivot charts">Filtering pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525143310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_update.xhp" name="Updating pivot charts">Updating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141315392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_delete.xhp" name="Deleting pivot charts">Deleting pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id191525177790601" xml-lang="en-US"><link href="https://tomazvajngerl.blogspot.com.br/2017/03/pivot-charts-in-libreoffice-part-1.html" name="Tomasz Vajngerl blog">Technical details on %PRODUCTNAME pivot chart implementation</link>.</paragraph>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/pivotchart_create.xhp b/source/text/scalc/guide/pivotchart_create.xhp
new file mode 100644
index 0000000000..bf7ea0aa94
--- /dev/null
+++ b/source/text/scalc/guide/pivotchart_create.xhp
@@ -0,0 +1,58 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="pivotchartcreate" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">Creating Pivot Charts</title>
+            <filename>/text/scalc/guide/pivotchart_create.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id531525141739769">
+        <bookmark_value>pivot chart;creating</bookmark_value>
+    </bookmark>
+    <paragraph role="heading" id="hd_id441525141699185" level="1" xml-lang="en-US">Creating Pivot Charts</paragraph>
+    <paragraph role="paragraph" id="par_id481525142550652" xml-lang="en-US">To create a pivot chart proceed as below:</paragraph>
+    <list type="ordered">
+        <listitem>
+            <paragraph id="par_id761525140219212"  role="listitem" xml-lang="en-US">Click inside the pivot table that you want to present in your chart.</paragraph>
+        </listitem>
+        <listitem>
+            <paragraph id="par_id351525140237521"  role="listitem" xml-lang="en-US">Choose <emph>Insert – Chart</emph> or click in the
+                <image id="img_id3157322" src="cmd/sc_insertobjectchart.png" width="0.2228in" height="0.2228in"><alt id="alt_id3159322" xml-lang="en-US">Insert Chart Icon</alt></image> <emph>Insert Chart</emph> icon in the main toolbar.</paragraph>
+        </listitem>
+    </list>
+    <paragraph role="paragraph" id="par_id151525140367370" xml-lang="en-US">%PRODUCTNAME Calc automatically detects the pivot table and opens the pivot chart wizard.</paragraph>
+    <list type="ordered" startwith="3">
+        <listitem>
+            <paragraph id="par_id861525140391601"  role="listitem" xml-lang="en-US">Select the <link href="text/schart/01/wiz_chart_type.xhp" name="Chart type">Chart type</link> for the data in the chart wizard.</paragraph>
+        </listitem>
+    </list>
+    <paragraph xml-lang="en-US" id="par_id41525141917275" role="note">The data range and the data series pages of the chart wizard are not enabled. They are controlled by the pivot table.</paragraph>
+    <list type="ordered" startwith="4">
+        <listitem>
+            <paragraph id="par_id511525140411625"  role="listitem" xml-lang="en-US">Select the <link href="text/schart/01/wiz_chart_elements.xhp" name="Chart elements">Chart Elements</link> of the pivot chart in the wizard.</paragraph>
+        </listitem>
+        <listitem>
+            <paragraph id="par_id1001525165156188"  role="listitem" xml-lang="en-US">Click <emph>OK</emph> to close the wizard and create the pivot chart.</paragraph>
+        </listitem>
+    </list>
+    <embed href="text/shared/00/00000004.xhp#samplefile"/>
+    <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id741525127310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart.xhp" name="Pivot charts">Pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525123310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_edit.xhp" name="Editing pivot charts">Editing pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741825141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_filter.xhp" name="Filtering pivot charts">Filtering pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525143310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_update.xhp" name="Updating pivot charts">Updating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141315392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_delete.xhp" name="Deleting pivot charts">Deleting pivot charts</link></paragraph>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/pivotchart_delete.xhp b/source/text/scalc/guide/pivotchart_delete.xhp
new file mode 100644
index 0000000000..44587a5200
--- /dev/null
+++ b/source/text/scalc/guide/pivotchart_delete.xhp
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="pivotchartdelete" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">Deleting Pivot Charts</title>
+            <filename>/text/scalc/guide/pivotchart_delete.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <paragraph role="heading" id="hd_id231525147891984" level="1" xml-lang="en-US">Deleting a Pivot Chart</paragraph>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id231525149357908">
+        <bookmark_value>pivot chart;deleting</bookmark_value>
+    </bookmark>
+    <paragraph role="paragraph" id="par_id141525147903623" xml-lang="en-US">To delete a pivot chart, select the chart and press <emph>Del</emph>.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id431525148462157" role="note">When deleting a pivot chart, the linked pivot table is not affected.</paragraph>
+    <paragraph xml-lang="en-US" id="par_id141525148751543" role="warning">If you delete a pivot table linked to a pivot chart, the pivot chart is also deleted. A dialog box opens to confirm the pivot chart deletion.</paragraph>
+    <embed href="text/shared/00/00000004.xhp#samplefile"/>
+    <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id741525127310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart.xhp" name="Pivot charts">Pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141311392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_create.xhp" name="Creating pivot charts">Creating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_edit.xhp" name="Editing pivot charts">Editing pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741825141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_filter.xhp" name="Filtering pivot charts">Filtering pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141315392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_update.xhp" name="Updating pivot charts">Updating pivot charts</link></paragraph>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/pivotchart_edit.xhp b/source/text/scalc/guide/pivotchart_edit.xhp
new file mode 100644
index 0000000000..21bf9c5499
--- /dev/null
+++ b/source/text/scalc/guide/pivotchart_edit.xhp
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="pivotchartedit" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">Editing Pivot Charts</title>
+            <filename>/text/scalc/guide/pivotchart_edit.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id661525144028976">
+        <bookmark_value>pivot chart;editing</bookmark_value>
+    </bookmark>
+    <paragraph role="heading" id="hd_id271525144002806" level="1" xml-lang="en-US">Editing Pivot Charts</paragraph>
+    <paragraph role="paragraph" id="par_id971525144066574" xml-lang="en-US">Edit a pivot chart in the same way as normal charts.</paragraph>
+    <paragraph xml-lang="en-US" id="hd_id5631580" role="heading" level="2">To edit a pivot chart</paragraph>
+    <embed href="text/schart/main0000.xhp#chartedit"/>
+    <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"/>
+    <embed href="text/schart/01/three_d_view.xhp#three_d_view"/>
+    <embed href="text/shared/00/00000004.xhp#samplefile"/>
+    <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id741525127310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart.xhp" name="Pivot charts">Pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_create.xhp" name="Creating pivot charts">Creating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741825141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_filter.xhp" name="Filtering pivot charts">Filtering pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525143310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_update.xhp" name="Updating pivot charts">Updating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141315392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_delete.xhp" name="Deleting pivot charts">Deleting pivot charts</link></paragraph>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/pivotchart_filter.xhp b/source/text/scalc/guide/pivotchart_filter.xhp
new file mode 100644
index 0000000000..0cc4c27480
--- /dev/null
+++ b/source/text/scalc/guide/pivotchart_filter.xhp
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="pivotchartfilter" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">Filtering Pivot Charts</title>
+            <filename>/text/scalc/guide/pivotchart_filter.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <paragraph role="heading" id="hd_id401525165755583" level="1" xml-lang="en-US">Filtering Pivot Charts</paragraph>
+    <paragraph role="paragraph" id="par_id781525166702239" xml-lang="en-US">Filters are used to remove unwanted data from the pivot chart. You can use filters in the pivot chart or in the corresponding <link href="text/scalc/guide/datapilot_filtertable.xhp" name="Pivot table filtering">pivot table</link>, since the resulting chart is exactly the same.</paragraph>
+
+    <paragraph role="heading" id="hd_id201525166689277" level="2" xml-lang="en-US">Pivot chart field buttons</paragraph>
+
+    <paragraph role="paragraph" id="par_id751525167435160" xml-lang="en-US">Pivot chart buttons are unique to pivot charts, normal charts don't have them. The buttons shows the layout of the pivot table, which are the pivot table fields. If present, page fields are displayed in the top. Row fields are displayed on the bottom of the chart next to each other and the legend shows the buttons from column fields stacked.</paragraph>
+
+    <paragraph role="paragraph" id="par_id681525167692377" xml-lang="en-US">
+        <image src="media/helpimg/sc_PivotChartButtons.png" id="img_id801525167692378" width="604px" height="340px">
+            <alt xml-lang="en-US" id="alt_id881525167692378">Pivot chart buttons</alt>
+        </image>
+    </paragraph>
+
+    <paragraph role="paragraph" id="par_id851525167448337" xml-lang="en-US">The buttons have a pop-up action attached to them. If there is some filtering applied, then the arrow turns blue (similar to the pivot table), so it is easier to see when a field has any filter applied.</paragraph>
+
+    <paragraph role="paragraph" id="par_id401525167457977" xml-lang="en-US">Existing page fields shows what is filtered: when nothing is filtered "- all -" is shown, when some data is filtered, then "- multiple -" is shown and when only one value is not filtered, the value is shown.</paragraph>
+    <embed href="text/shared/00/00000004.xhp#samplefile"/>
+    <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
+
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id741525127310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart.xhp" name="Pivot charts">Pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_create.xhp" name="Creating pivot charts">Creating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id281525144162940" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_edit.xhp" name="Edit Pivot Chart">Editing Pivot Charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525143310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_update.xhp" name="Updating pivot charts">Updating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141315392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_delete.xhp" name="Deleting pivot charts">Deleting pivot charts</link></paragraph>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/pivotchart_update.xhp b/source/text/scalc/guide/pivotchart_update.xhp
new file mode 100644
index 0000000000..48963bf8e8
--- /dev/null
+++ b/source/text/scalc/guide/pivotchart_update.xhp
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+    <!--
+    * This file is part of the LibreOffice project.
+    *
+    * This Source Code Form is subject to the terms of the Mozilla Public
+    * License, v. 2.0. If a copy of the MPL was not distributed with this
+    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+    *
+    -->
+
+    <meta>
+        <topic id="pivotchartupdate" indexer="include" status="PUBLISH">
+            <title id="tit" xml-lang="en-US">Pivot Chart Update</title>
+            <filename>/text/scalc/guide/pivotchart_update.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <bookmark xml-lang="en-US" branch="index" id="bm_id801525146393791">
+        <bookmark_value>pivot chart;update</bookmark_value>
+    </bookmark>
+    <paragraph role="heading" id="hd_id281525146417678" level="1" xml-lang="en-US">Pivot Chart Update</paragraph>
+    <paragraph role="paragraph" id="par_id831525146706944" xml-lang="en-US">If the data of the source sheet has been changed, you must refresh the pivot table and the pivot chart is updated accordingly. To refresh the pivot table (and thus the pivot chart):</paragraph>
+    <list type="unordered">
+        <listitem>
+            <paragraph id="par_id451525146722974"  role="listitem" xml-lang="en-US">Choose <emph>Data - Pivot Table - Refresh</emph>.</paragraph>
+        </listitem>
+        <listitem>
+            <paragraph id="par_id331525146738273"  role="listitem" xml-lang="en-US">Choose <emph>Refresh...</emph> in the context menu of any cell in the pivot table.</paragraph>
+        </listitem>
+    </list>
+    <embed href="text/shared/00/00000004.xhp#samplefile"/>
+    <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id741525127310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart.xhp" name="Pivot charts">Pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141311392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_create.xhp" name="Creating pivot charts">Creating pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_edit.xhp" name="Editing pivot charts">Editing pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741825141310392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_filter.xhp" name="Filtering pivot charts">Filtering pivot charts</link></paragraph>
+        <paragraph role="paragraph" id="par_id741525141315392" xml-lang="en-US"><link href="text/scalc/guide/pivotchart_delete.xhp" name="Deleting pivot charts">Deleting pivot charts</link></paragraph>
+    </section>
+</body>
+</helpdocument>
diff --git a/source/text/schart/main0000.xhp b/source/text/schart/main0000.xhp
index d89857f9e7..d706baab0d 100644
--- a/source/text/schart/main0000.xhp
+++ b/source/text/schart/main0000.xhp
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,8 +18,8 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
- 
-	
+
+
 <meta>
       <topic id="textschartmain0000xml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Charts in $[officename]</title>
@@ -32,7 +32,7 @@
 </bookmark><comment>MW added one entry</comment>
 <paragraph xml-lang="en-US" id="hd_id3148664" role="heading" level="1"><variable id="chart_main"><link href="text/schart/main0000.xhp" name="Charts in $[officename]">Using Charts in %PRODUCTNAME</link>
 </variable></paragraph>
-      <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 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.
 </variable></paragraph>
       <paragraph xml-lang="en-US" id="hd_id3153143" role="heading" level="2">Chart Data</paragraph>
       <paragraph xml-lang="en-US" id="par_id5181432" role="paragraph">Charts can be based on the following data:</paragraph>
@@ -59,6 +59,7 @@
       <embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
       <embed href="text/schart/01/choose_chart_type.xhp#choose_chart_type"/>
       <paragraph xml-lang="en-US" id="hd_id5631580" role="heading" level="2">To edit a chart</paragraph>
+      <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>
@@ -85,6 +86,7 @@
       <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>
+  </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"/>
@@ -170,4 +172,4 @@
       <embed href="text/shared/guide/chart_barformat.xhp#chart_barformat"/>
       <embed href="text/schart/01/three_d_view.xhp#three_d_view"/>
    </body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>