summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKurt Zenker <kz@openoffice.org>2009-09-11 16:06:18 +0000
committerKurt Zenker <kz@openoffice.org>2009-09-11 16:06:18 +0000
commit21c07ae6febccb6fab0d58c7d5bbf9628a06f4db (patch)
treeb951d1b60e3883395cf65bb9499aa8a286df61ad
parent905fd99a628ae400887ac6ee3310966d882aae22 (diff)
CWS-TOOLING: integrate CWS chartuseability01
2009-09-07 17:26:44 +0200 iha r275906 : CWS-TOOLING: rebase CWS chartuseability01 to trunk@275801 (milestone: DEV300:m57) 2009-08-27 13:48:16 +0200 iha r275481 : #7049# listbox to select chart elements 2009-08-27 11:54:53 +0200 iha r275464 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-26 16:49:58 +0200 iha r275435 : #i102820# added missing case 'floor' 2009-08-26 15:33:51 +0200 iha r275427 : #i102820# make 'insert legend' work properly 2009-08-25 16:35:00 +0200 ufi r275369 : i104087 2009-08-25 15:12:17 +0200 iha r275360 : #i104087# 'Object Properties' -> 'Format Selection' 2009-08-25 15:11:31 +0200 iha r275359 : #i104087# 'Object Properties' -> 'Format Selection' 2009-08-25 15:11:15 +0200 iha r275358 : #i104087# 'Object Properties' -> 'Format Selection' 2009-08-25 11:57:43 +0200 iha r275344 : #i104087# changed behavior of insert menu 2009-08-18 12:53:54 +0200 oc r275093 : #i104082,104086,104089# multiple changes because of changed chartUI 2009-08-10 16:46:17 +0200 ufi r274824 : i104083 i104087 i104090 2009-08-07 14:04:34 +0200 iha r274763 : #7049# listbox to select chart elements 2009-08-07 13:06:05 +0200 iha r274760 : #7049# listbox to select chart elements 2009-08-07 13:05:06 +0200 iha r274759 : #7049# listbox to select chart elements 2009-08-07 12:32:31 +0200 iha r274756 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-07 12:31:54 +0200 iha r274755 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-06 19:00:48 +0200 iha r274742 : #i103593# make insert menu behavior selection dependent 2009-08-06 19:00:14 +0200 iha r274741 : #i103593# make insert menu behavior selection dependent 2009-08-06 15:34:01 +0200 iha r274731 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-06 14:39:20 +0200 iha r274728 : #i86146# ease adding R-squared value with an equation 2009-08-06 14:37:02 +0200 iha r274727 : #i86146# ease adding R-squared value with an equation 2009-08-06 13:37:54 +0200 iha r274724 : #i86146# ease adding R-squared value with an equation 2009-08-06 13:37:15 +0200 iha r274723 : #i86146# ease adding R-squared value with an equation 2009-08-06 13:04:27 +0200 iha r274722 : #i103593# make insert menu behavior selection dependent 2009-08-06 13:03:35 +0200 iha r274721 : #i103593# make insert menu behavior selection dependent 2009-08-05 18:26:31 +0200 iha r274693 : #i104033# inconsistent wording 'error indicator' <-> 'error bar' 2009-08-05 16:51:45 +0200 iha r274688 : #i104028# rename font tabpage 'Characters'->'Font' 2009-08-05 16:30:21 +0200 iha r274685 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:34:11 +0200 iha r274680 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:32:43 +0200 iha r274679 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:31:26 +0200 iha r274678 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:17:51 +0200 iha r274676 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:16:22 +0200 iha r274675 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 14:58:59 +0200 iha r274674 : #7049# listbox to select chart elements 2009-08-05 14:33:54 +0200 iha r274669 : #7049# listbox to select chart elements 2009-08-05 14:22:17 +0200 iha r274665 : #7049# listbox to select chart elements 2009-08-05 13:21:05 +0200 iha r274656 : #i102820# offer insertion of several elements in context menu also if nothing is selected 2009-08-05 11:56:06 +0200 iha r274647 : #7049# listbox to select chart elements 2009-08-05 11:43:40 +0200 iha r274645 : #7049# listbox to select chart elements 2009-07-24 19:46:50 +0200 iha r274318 : #i58163# #i69422# #i102820# enhance chart context menu 2009-07-24 16:23:13 +0200 iha r274313 : #i58163# #i69422# #i102820# enhance chart context menu 2009-07-24 16:13:22 +0200 iha r274311 : #i58163# #i69422# #i102820# enhance chart context menu
-rw-r--r--helpcontent2/source/text/schart/00/00000004.xhp16
-rw-r--r--helpcontent2/source/text/schart/01/04010000.xhp4
-rw-r--r--helpcontent2/source/text/schart/01/04020000.xhp4
-rw-r--r--helpcontent2/source/text/schart/01/04030000.xhp85
-rw-r--r--helpcontent2/source/text/schart/01/04040000.xhp4
-rw-r--r--helpcontent2/source/text/schart/01/04050000.xhp6
-rw-r--r--helpcontent2/source/text/schart/01/04050100.xhp35
-rwxr-xr-xhelpcontent2/source/text/schart/01/04060000.xhp25
-rw-r--r--helpcontent2/source/text/schart/01/04070000.xhp4
-rw-r--r--helpcontent2/source/text/schart/01/05010000.xhp12
-rw-r--r--helpcontent2/source/text/schart/01/05010100.xhp2
-rw-r--r--helpcontent2/source/text/schart/01/05010200.xhp2
-rw-r--r--helpcontent2/source/text/schart/01/05020100.xhp60
-rw-r--r--helpcontent2/source/text/schart/01/three_d_view.xhp257
-rw-r--r--helpcontent2/source/text/schart/01/type_stock.xhp499
-rwxr-xr-xhelpcontent2/source/text/schart/main0000.xhp211
-rwxr-xr-xhelpcontent2/source/text/schart/main0202.xhp67
-rw-r--r--helpcontent2/source/text/schart/makefile.mk1
-rw-r--r--helpcontent2/util/scalc/makefile.mk1
-rw-r--r--helpcontent2/util/schart/makefile.mk1
-rw-r--r--helpcontent2/util/sdraw/makefile.mk1
-rw-r--r--helpcontent2/util/simpress/makefile.mk1
-rw-r--r--helpcontent2/util/swriter/makefile.mk1
23 files changed, 740 insertions, 559 deletions
diff --git a/helpcontent2/source/text/schart/00/00000004.xhp b/helpcontent2/source/text/schart/00/00000004.xhp
index 9aa9ca658e..9a3f58ca6a 100644
--- a/helpcontent2/source/text/schart/00/00000004.xhp
+++ b/helpcontent2/source/text/schart/00/00000004.xhp
@@ -70,7 +70,7 @@
</section>
<section id="efgdbs">
<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US" l10n="CHG" oldref="16">Choose <emph>Insert - Data Labels </emph>(Charts)</paragraph>
-<paragraph role="paragraph" id="par_id3147341" xml-lang="en-US" l10n="CHG" oldref="68">Choose <emph>Format - Object Properties - Data Point/Data Series - Data Labels</emph> tab (for data series and data point) (Charts)</paragraph>
+<paragraph role="paragraph" id="par_id3147341" xml-lang="en-US" l10n="CHG" oldref="68">Choose <emph>Format - Format Selection - Data Point/Data Series - Data Labels</emph> tab (for data series and data point) (Charts)</paragraph>
</section>
<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US" l10n="CHG" oldref="69"><variable id="efgaug">Choose <emph>Insert - Axes </emph>(Charts)
</variable></paragraph>
@@ -107,25 +107,25 @@
</variable></paragraph>
<paragraph role="paragraph" id="par_id3154532" xml-lang="en-US" l10n="CHG" oldref="67"><variable id="sonderz">Choose <emph>Insert - Special Character </emph>(Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153246" xml-lang="en-US" l10n="CHG" oldref="22"><variable id="frtoes">Choose <emph>Format - Object Properties </emph>(Charts)
+<paragraph role="paragraph" id="par_id3153246" xml-lang="en-US" l10n="CHG" oldref="22"><variable id="frtoes">Choose <emph>Format - Format Selection </emph>(Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG" oldref="23"><variable id="frtodd">Choose <emph>Format - Object Properties - Data Point</emph> dialog (Charts)
+<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="CHG" oldref="23"><variable id="frtodd">Choose <emph>Format - Format Selection - Data Point</emph> dialog (Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154765" xml-lang="en-US" l10n="CHG" oldref="24"><variable id="frtodr">Choose <emph>Format - Object Properties - Data Series</emph> dialog (Charts)
+<paragraph role="paragraph" id="par_id3154765" xml-lang="en-US" l10n="CHG" oldref="24"><variable id="frtodr">Choose <emph>Format - Format Selection - Data Series</emph> dialog (Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153009" xml-lang="en-US" l10n="CHG" oldref="66"><variable id="optionen">Choose <emph>Format - Object Properties - Data Series - Options</emph> tab (Charts)
+<paragraph role="paragraph" id="par_id3153009" xml-lang="en-US" l10n="CHG" oldref="66"><variable id="optionen">Choose <emph>Format - Format Selection - Data Series - Options</emph> tab (Charts)
</variable></paragraph>
<paragraph role="paragraph" id="par_id3154707" xml-lang="en-US" l10n="CHG" oldref="25"><variable id="frtttl">Choose <emph>Format - Title </emph>(Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3155758" xml-lang="en-US" l10n="CHG" oldref="26"><variable id="frtoe">Choose <emph>Format - Object Properties - Title</emph> dialog (Charts)
+<paragraph role="paragraph" id="par_id3155758" xml-lang="en-US" l10n="CHG" oldref="26"><variable id="frtoe">Choose <emph>Format - Format Selection - Title</emph> dialog (Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US" l10n="CHG" oldref="27"><variable id="frtegt">Choose <emph>Format - Object Properties - Title</emph> dialog (Charts)
+<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US" l10n="CHG" oldref="27"><variable id="frtegt">Choose <emph>Format - Format Selection - Title</emph> dialog (Charts)
</variable></paragraph>
<paragraph role="paragraph" id="par_id3149048" xml-lang="en-US" l10n="CHG" oldref="28"><variable id="frttya">Choose <emph>Format - Title </emph>(Charts)
</variable></paragraph>
<paragraph role="paragraph" id="par_id3147402" xml-lang="en-US" l10n="CHG" oldref="70"><variable id="frttyab">Choose <emph>Format - Axis </emph>(Charts)
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3147297" xml-lang="en-US" l10n="CHG" oldref="29"><variable id="frtlgd">Choose <emph>Format - Legend, or Format - Object Properties</emph> - <emph>Legend </emph>(Charts)
+<paragraph role="paragraph" id="par_id3147297" xml-lang="en-US" l10n="CHG" oldref="29"><variable id="frtlgd">Choose <emph>Format - Legend, or Format - Format Selection</emph> - <emph>Legend </emph>(Charts)
</variable></paragraph>
<paragraph role="paragraph" id="par_id3157876" xml-lang="en-US" l10n="CHG" oldref="31"><variable id="frtaa">Choose <emph>Format - Axis - X Axis/Secondary X Axis/Z Axis/All Axes </emph>(Charts)
</variable></paragraph>
diff --git a/helpcontent2/source/text/schart/01/04010000.xhp b/helpcontent2/source/text/schart/01/04010000.xhp
index 33ff18bbfa..3f79c5d42f 100644
--- a/helpcontent2/source/text/schart/01/04010000.xhp
+++ b/helpcontent2/source/text/schart/01/04010000.xhp
@@ -43,8 +43,8 @@
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertTitle" id="bm_id3146313" localize="false"/><paragraph role="heading" id="hd_id3147345" xml-lang="en-US" level="1" l10n="U" oldref="1">Titles</paragraph>
-<paragraph role="paragraph" id="par_id3150298" xml-lang="en-US" l10n="U" oldref="2"><variable id="titel"><ahelp hid=".uno:InsertTitle">Opens a dialog to enter or modify the titles in a chart.</ahelp>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuTitles" id="bm_id3146313" localize="false"/><paragraph role="heading" id="hd_id3147345" xml-lang="en-US" level="1" l10n="U" oldref="1">Titles</paragraph>
+<paragraph role="paragraph" id="par_id3150298" xml-lang="en-US" l10n="U" oldref="2"><variable id="titel"><ahelp hid=".uno:InsertMenuTitles">Opens a dialog to enter or modify the titles in a chart.</ahelp>
</variable> You can define the text for the main title, subtitle and the axis labels, and specify if they are displayed.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#efgttl"/>
diff --git a/helpcontent2/source/text/schart/01/04020000.xhp b/helpcontent2/source/text/schart/01/04020000.xhp
index 7853d2a62e..e05dfc7471 100644
--- a/helpcontent2/source/text/schart/01/04020000.xhp
+++ b/helpcontent2/source/text/schart/01/04020000.xhp
@@ -44,9 +44,9 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3156441"><bookmark_value>chart legends; hiding</bookmark_value>
<bookmark_value>hiding;chart legends</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertLegend" id="bm_id3149667" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuLegend" id="bm_id3149667" localize="false"/>
<paragraph role="heading" id="hd_id3156441" xml-lang="en-US" level="1" l10n="U" oldref="1">Legend</paragraph>
-<paragraph role="paragraph" id="par_id3155413" xml-lang="en-US" l10n="U" oldref="2"><variable id="legende"><ahelp hid=".uno:InsertLegend">Opens the <emph>Legend </emph>dialog, which allows you to change the position of legends in the chart, and to specify whether the legend is displayed.</ahelp>
+<paragraph role="paragraph" id="par_id3155413" xml-lang="en-US" l10n="U" oldref="2"><variable id="legende"><ahelp hid=".uno:InsertMenuLegend">Opens the <emph>Legend </emph>dialog, which allows you to change the position of legends in the chart, and to specify whether the legend is displayed.</ahelp>
</variable></paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#efglgd"/>
diff --git a/helpcontent2/source/text/schart/01/04030000.xhp b/helpcontent2/source/text/schart/01/04030000.xhp
index 7f31d5ad0a..20ef489737 100644
--- a/helpcontent2/source/text/schart/01/04030000.xhp
+++ b/helpcontent2/source/text/schart/01/04030000.xhp
@@ -10,8 +10,8 @@
*
* OpenOffice.org - a multi-platform office productivity suite
*
- * $RCSfile: 04030000.xhp,v $
- * $Revision: 1.11.34.1 $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
@@ -35,63 +35,70 @@
<meta>
-<topic id="textschart0104030000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Data Labels </title>
-<filename>/text/schart/01/04030000.xhp</filename>
-</topic>
-</meta>
-<body>
+ <topic id="textschart0104030000xml" indexer="include">
+ <title xml-lang="en-US" id="tit">Data Labels </title>
+ <filename>/text/schart/01/04030000.xhp</filename>
+ </topic>
+ </meta>
+ <body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150275"><bookmark_value>data labels in charts</bookmark_value>
-<bookmark_value>labels; for charts</bookmark_value>
-<bookmark_value>charts; data labels</bookmark_value>
-<bookmark_value>data values in charts</bookmark_value>
-<bookmark_value>chart legends; showing icons with labels</bookmark_value>
+ <bookmark_value>labels; for charts</bookmark_value>
+ <bookmark_value>charts; data labels</bookmark_value>
+ <bookmark_value>data values in charts</bookmark_value>
+ <bookmark_value>chart legends; showing icons with labels</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertDescription" id="bm_id3144510" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuDataLabels" id="bm_id3144510" localize="false"/>
<section id="datalabels">
-<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="datenbeschriftung"><link href="text/schart/01/04030000.xhp" name="Data labels">Data Labels</link>
+ <paragraph xml-lang="en-US" id="hd_id3150275" role="heading" level="1" l10n="U" oldref="1"><variable id="datenbeschriftung"><link href="text/schart/01/04030000.xhp" name="Data labels">Data Labels</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US" l10n="U" oldref="2"><variable id="besch"><ahelp hid=".uno:InsertDescription">Opens the<emph> Data Labels </emph>dialog, which enables you to set the data labels.</ahelp>
+ <paragraph xml-lang="en-US" id="par_id3154684" role="paragraph" l10n="U" oldref="2"><variable id="besch"><ahelp hid=".uno:InsertMenuDataLabels">Opens the<emph> Data Labels </emph>dialog, which enables you to set the data labels.</ahelp>
</variable></paragraph>
-</section>
-<section id="howtoget">
-<embed href="text/schart/00/00000004.xhp#efgdbs"/>
-</section>
+ </section>
+ <section id="context">
+ <paragraph xml-lang="en-US" id="par_id0810200912120416" role="paragraph" l10n="NEW">If an element of a data series is selected, this command works on that data series only. If no element is selected, this command works on all data series.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/schart/00/00000004.xhp#efgdbs"/>
+ </section>
<bookmark xml-lang="en-US" branch="hid/SCH_RADIOBUTTON_TP_DATA_DESCR_RB_NUMBER" id="bm_id3149123" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SCH_RADIOBUTTON_DLG_DATA_DESCR_RB_NUMBER" id="bm_id3146972" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_NUMBER" id="bm_id901516" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_VALUE" id="bm_id8825342" localize="false"/>
-<paragraph role="heading" id="hd_id3149401" xml-lang="en-US" level="2" l10n="CHG" oldref="17">Show value as number</paragraph>
-<paragraph role="paragraph" id="par_id3150751" xml-lang="en-US" l10n="U" oldref="18"><ahelp hid="SCH_RADIOBUTTON_DLG_DATA_DESCR_RB_NUMBER">Displays the absolute values of the data points.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3149401" role="heading" level="1" l10n="CHG"
+ oldref="17">Show value as number</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150751" role="paragraph" l10n="U" oldref="18"><ahelp hid="SCH_RADIOBUTTON_DLG_DATA_DESCR_RB_NUMBER">Displays the absolute values of the data points.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_PB_NUMBERFORMAT" id="bm_id1717276" localize="false"/>
-<paragraph role="heading" id="hd_id5077059" xml-lang="en-US" level="3" l10n="NEW">Number format</paragraph>
-<paragraph role="paragraph" id="par_id9794610" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Opens a dialog to select the number format.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id5077059" role="heading" level="1" l10n="NEW">Number format</paragraph>
+ <paragraph xml-lang="en-US" id="par_id9794610" role="paragraph" l10n="NEW"><ahelp hid=".">Opens a dialog to select the number format.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH_RADIOBUTTON_TP_DATA_DESCR_RB_PERCENT" id="bm_id3155766" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SCH_RADIOBUTTON_DLG_DATA_DESCR_RB_PERCENT" id="bm_id3154254" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_PERCENT" id="bm_id9111911" localize="false"/>
-<paragraph role="heading" id="hd_id3145643" xml-lang="en-US" level="2" l10n="CHG" oldref="9">Show value as percentage</paragraph>
-<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SCH_RADIOBUTTON_DLG_DATA_DESCR_RB_PERCENT">Displays the percentage of the data points in each column.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145643" role="heading" level="1" l10n="CHG"
+ oldref="9">Show value as percentage</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3156382" role="paragraph" l10n="U" oldref="10"><ahelp hid="SCH_RADIOBUTTON_DLG_DATA_DESCR_RB_PERCENT">Displays the percentage of the data points in each column.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_PB_PERCENT_NUMBERFORMAT" id="bm_id381481" localize="false"/>
-<paragraph role="heading" id="hd_id1316873" xml-lang="en-US" level="3" l10n="NEW">Percentage format</paragraph>
-<paragraph role="paragraph" id="par_id5476241" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Opens a dialog to select the percentage format.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id1316873" role="heading" level="1" l10n="NEW">Percentage format</paragraph>
+ <paragraph xml-lang="en-US" id="par_id5476241" role="paragraph" l10n="NEW"><ahelp hid=".">Opens a dialog to select the percentage format.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH_CHECKBOX_DLG_DATA_DESCR_CB_TEXT" id="bm_id3149258" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SCH_CHECKBOX_TP_DATA_DESCR_CB_TEXT" id="bm_id3153964" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_TEXT" id="bm_id3015533" localize="false"/>
-<paragraph role="heading" id="hd_id3145228" xml-lang="en-US" level="3" l10n="CHG" oldref="11">Show category</paragraph>
-<paragraph role="paragraph" id="par_id3154702" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="SCH_CHECKBOX_TP_DATA_DESCR_CB_TEXT">Shows the data point text labels.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145228" role="heading" level="1" l10n="CHG"
+ oldref="11">Show category</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154702" role="paragraph" l10n="U" oldref="12"><ahelp hid="SCH_CHECKBOX_TP_DATA_DESCR_CB_TEXT">Shows the data point text labels.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH_CHECKBOX_DLG_DATA_DESCR_CB_SYMBOL" id="bm_id3147004" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SCH_CHECKBOX_TP_DATA_DESCR_CB_SYMBOL" id="bm_id3143220" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_SYMBOL" id="bm_id2496108" localize="false"/>
-<paragraph role="heading" id="hd_id3150298" xml-lang="en-US" level="3" l10n="CHG" oldref="15">Show legend key</paragraph>
-<paragraph role="paragraph" id="par_id3150205" xml-lang="en-US" l10n="U" oldref="16"><ahelp hid="SCH_CHECKBOX_TP_DATA_DESCR_CB_SYMBOL">Displays the legend icons next to each data point label.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150298" role="heading" level="1" l10n="CHG"
+ oldref="15">Show legend key</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150205" role="paragraph" l10n="U" oldref="16"><ahelp hid="SCH_CHECKBOX_TP_DATA_DESCR_CB_SYMBOL">Displays the legend icons next to each data point label.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_SEPARATOR" id="bm_id6416821" localize="false"/>
-<paragraph role="heading" id="hd_id3836787" xml-lang="en-US" level="2" l10n="NEW">Separator</paragraph>
-<paragraph role="paragraph" id="par_id6668904" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Selects the separator between multiple text strings for the same object.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3836787" role="heading" level="1" l10n="NEW">Separator</paragraph>
+ <paragraph xml-lang="en-US" id="par_id6668904" role="paragraph" l10n="NEW"><ahelp hid=".">Selects the separator between multiple text strings for the same object.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_DATALABEL_PLACEMENT" id="bm_id110620081228356" localize="false"/>
-<paragraph role="heading" id="hd_id4319284" xml-lang="en-US" level="2" l10n="NEW">Placement</paragraph>
-<paragraph role="paragraph" id="par_id5159459" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Selects the placement of data labels relative to the objects.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id4319284" role="heading" level="1" l10n="NEW">Placement</paragraph>
+ <paragraph xml-lang="en-US" id="par_id5159459" role="paragraph" l10n="NEW"><ahelp hid=".">Selects the placement of data labels relative to the objects.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_SCH_TEXTDIRECTION" id="bm_id1106200812295486" localize="false"/>
-<paragraph role="heading" id="hd_id1106200812280727" xml-lang="en-US" level="3" l10n="NEW">Text Direction</paragraph>
-<paragraph role="paragraph" id="par_id1106200812280719" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled.</ahelp></paragraph>
-</body>
-</helpdocument>
+<paragraph xml-lang="en-US" id="hd_id1106200812280727" role="heading" level="1" l10n="NEW">Text Direction</paragraph>
+ <paragraph xml-lang="en-US" id="par_id1106200812280719" role="paragraph" l10n="NEW"><ahelp hid=".">Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled.</ahelp></paragraph>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/01/04040000.xhp b/helpcontent2/source/text/schart/01/04040000.xhp
index 8c9aed771b..da476ab884 100644
--- a/helpcontent2/source/text/schart/01/04040000.xhp
+++ b/helpcontent2/source/text/schart/01/04040000.xhp
@@ -51,8 +51,8 @@
<bookmark_value>axes; better scaling</bookmark_value>
<bookmark_value>secondary axes in charts</bookmark_value>
</bookmark><comment>mw made "secondary axes;" a one level entry, deleted "charts; showing secondary axes" and generated one "axes;" enry out of two "axes;showing..." entries</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertAxis" id="bm_id3146121" localize="false"/><paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="1" l10n="U" oldref="1">Axes</paragraph>
-<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US" l10n="U" oldref="2"><variable id="achsen"><ahelp hid=".uno:InsertAxis">Specifies the axes to be displayed in the chart.</ahelp>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuAxes" id="bm_id3146121" localize="false"/><paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="1" l10n="U" oldref="1">Axes</paragraph>
+<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US" l10n="U" oldref="2"><variable id="achsen"><ahelp hid=".uno:InsertMenuAxes">Specifies the axes to be displayed in the chart.</ahelp>
</variable></paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#efgaug"/>
diff --git a/helpcontent2/source/text/schart/01/04050000.xhp b/helpcontent2/source/text/schart/01/04050000.xhp
index b990bdc4b5..582a853fbb 100644
--- a/helpcontent2/source/text/schart/01/04050000.xhp
+++ b/helpcontent2/source/text/schart/01/04050000.xhp
@@ -40,11 +40,11 @@
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertStatistics" id="bm_id3154013" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertYErrorbars" id="bm_id877101" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuYErrorBars" id="bm_id877101" localize="false"/>
<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/schart/01/04050000.xhp" name="Y Error Bars">Y Error Bars</link></paragraph><comment>i85330</comment>
-<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="statistik"><ahelp hid=".uno:InsertStatistics">Use the <emph>Y Error Bars</emph> dialog to display error bars for 2D charts.</ahelp>
+<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="statistik"><ahelp hid=".">Use the <emph>Y Error Bars</emph> dialog to display error bars for 2D charts.</ahelp>
</variable></paragraph>
+<embed href="text/schart/01/04030000.xhp#context"/>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#efgsta"/>
</section>
diff --git a/helpcontent2/source/text/schart/01/04050100.xhp b/helpcontent2/source/text/schart/01/04050100.xhp
index 0386615f91..37a65ed1d8 100644
--- a/helpcontent2/source/text/schart/01/04050100.xhp
+++ b/helpcontent2/source/text/schart/01/04050100.xhp
@@ -11,7 +11,7 @@
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: soffice2xmlhelp.xsl,v $
- * $Revision: 1.10 $
+ * $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
@@ -46,11 +46,12 @@
<bookmark_value>trend lines in charts</bookmark_value>
<bookmark_value>mean value lines in charts</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertTrendlines" id="bm_id2001709" localize="false"/>
-<paragraph role="heading" id="hd_id5409405" xml-lang="en-US" level="1" l10n="CHG"><variable id="regression"><link href="text/schart/01/04050100.xhp">Trend Lines</link>
+<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>
</variable></paragraph>
+ <embed href="text/schart/01/04030000.xhp#context"/>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#trendlines"/>
</section><comment>None</comment>
@@ -69,7 +70,7 @@
<bookmark xml-lang="en-US" branch="hid/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>
- <list type="unordered">
+ <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>
</listitem>
@@ -84,31 +85,31 @@
</listitem>
</list>
<paragraph xml-lang="en-US" id="par_id296334" role="note" l10n="CHG">A trend line is shown in the legend automatically.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertMeanValues" id="bm_id7854243" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertMeanValue" id="bm_id7854245" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id4072084" role="paragraph" l10n="NEW"><ahelp hid=".">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 all data series. A single mean value line can be inserted by the <emph>Insert Mean Value Line</emph> command of the context menu of a data series.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id9569689" role="paragraph" l10n="NEW">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 - Object Properties - Line</item>.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuMeanValues" id="bm_id7854243" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id4072084" role="paragraph" l10n="NEW"><ahelp hid=".">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.</ahelp></paragraph>
+<embed href="text/schart/01/04030000.xhp#context"/>
+ <paragraph xml-lang="en-US" id="par_id9569689" role="paragraph" l10n="NEW">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>
<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 - Object Properties - Equation</item>. <comment>see http://specs.openoffice.org/chart/DisplayTrendLineEquations.odt</comment></paragraph><comment>hid</comment>
+ <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>. <comment>see http://specs.openoffice.org/chart/DisplayTrendLineEquations.odt</comment></paragraph><comment>hid</comment>
<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_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="hd_id5744193" role="heading" level="1" 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_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_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="hd_id2538834" role="heading" level="1" 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="hd_id7874080" role="heading" level="2" l10n="NEW">The exponential regression equation</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id7874080" role="heading" level="1" 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_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>
@@ -118,14 +119,14 @@
<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_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="hd_id6349375" role="heading" level="1" 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="hd_id9204077" role="heading" level="2" l10n="NEW">Constraints<comment>UFI: is this still so?</comment></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id9204077" role="heading" level="1" 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="unordered">
+ <list type="ordered">
<listitem>
<paragraph xml-lang="en-US" id="par_id7212744" role="paragraph" l10n="NEW">logarithm regression: only positive x-values are considered,</paragraph>
</listitem>
@@ -137,7 +138,7 @@
</listitem>
</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="hd_id7907040" role="heading" level="1" 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>
@@ -147,4 +148,4 @@
<paragraph xml-lang="en-US" id="par_id4562211" role="paragraph" l10n="CHG"><link href="text/schart/01/04050000.xhp">Y Error Bars tab page</link></paragraph>
</section>
</body>
-</helpdocument>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/01/04060000.xhp b/helpcontent2/source/text/schart/01/04060000.xhp
index bd3c017fdc..15536a17e1 100755
--- a/helpcontent2/source/text/schart/01/04060000.xhp
+++ b/helpcontent2/source/text/schart/01/04060000.xhp
@@ -11,7 +11,7 @@
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: soffice2xmlhelp.xsl,v $
- * $Revision: 1.10 $
+ * $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
@@ -56,29 +56,29 @@
<paragraph xml-lang="en-US" id="par_id3145228" role="paragraph" l10n="U" oldref="10">In this area you can choose between two Y axis scaling modes. The axes can only be scaled and given properties separately.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_OPTIONS:RBT_OPT_AXIS_1" id="bm_id3154703" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:RadioButton:TP_OPTIONS:RBT_OPT_AXIS_1" id="bm_id8064516" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147346" role="heading" level="3" l10n="U" oldref="4">Primary Y axis</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147346" role="heading" level="2" l10n="U" oldref="4">Primary Y axis</paragraph>
<paragraph xml-lang="en-US" id="par_id3147005" role="paragraph" l10n="U" oldref="15"><ahelp hid="SCH:RADIOBUTTON:TP_OPTIONS:RBT_OPT_AXIS_1">This option is active as default. All data series are aligned to the primary Y axis.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_OPTIONS:RBT_OPT_AXIS_2" id="bm_id3150205" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:RadioButton:TP_OPTIONS:RBT_OPT_AXIS_2" id="bm_id9959715" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3143221" role="heading" level="3" l10n="U" oldref="5">Secondary Y axis</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3143221" role="heading" level="2" l10n="U" oldref="5">Secondary Y axis</paragraph>
<paragraph xml-lang="en-US" id="par_id3154656" role="paragraph" l10n="U" oldref="11"><ahelp hid="SCH:RADIOBUTTON:TP_OPTIONS:RBT_OPT_AXIS_2">Changes the scaling of the Y axis. This axis is only visible when at least one data series is assigned to it and the axis view is active.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3166423" role="heading" level="2" l10n="U" oldref="6">Settings</paragraph>
<paragraph xml-lang="en-US" id="par_id3150365" role="paragraph" l10n="U" oldref="12">Define the settings for a bar chart in this area. Any changes apply to all data series of the chart, not to the selected data only.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:TP_OPTIONS:MT_GAP" id="bm_id3166428" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_OPTIONS:MT_GAP" id="bm_id6286812" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145584" role="heading" level="3" l10n="U" oldref="7">Spacing</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145584" role="heading" level="2" l10n="U" oldref="7">Spacing</paragraph>
<paragraph xml-lang="en-US" id="par_id3155376" role="paragraph" l10n="U" oldref="13"><ahelp hid="SCH:METRICFIELD:TP_OPTIONS:MT_GAP">Defines the spacing between the columns in percent.</ahelp> The maximal spacing is 600%.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:TP_OPTIONS:MT_OVERLAP" id="bm_id3146978" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_OPTIONS:MT_OVERLAP" id="bm_id119022" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145384" role="heading" level="3" l10n="U" oldref="8">Overlap</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145384" role="heading" level="2" l10n="U" oldref="8">Overlap</paragraph>
<paragraph xml-lang="en-US" id="par_id3156447" role="paragraph" l10n="U" oldref="14"><ahelp hid="SCH:METRICFIELD:TP_OPTIONS:MT_OVERLAP">Defines the necessary settings for overlapping data series.</ahelp> You can choose between -100 and +100%.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SCH:CHECKBOX:TP_OPTIONS:CB_CONNECTOR" id="bm_id3153815" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_OPTIONS:CB_CONNECTOR" id="bm_id5567491" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153305" role="heading" level="3" l10n="U"
+<paragraph xml-lang="en-US" id="hd_id3153305" role="heading" level="2" l10n="U"
oldref="16">Connection Lines</paragraph>
<paragraph xml-lang="en-US" id="par_id3148868" role="paragraph" l10n="U" oldref="17"><ahelp hid="SCH:CHECKBOX:TP_OPTIONS:CB_CONNECTOR">For "stacked" and "percent" column (vertical bar) charts, mark this check box to connect the column layers that belong together with lines.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2_CheckBox_TP_OPTIONS_CB_BARS_SIDE_BY_SIDE" id="bm_id8464003" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id9842219" role="heading" level="3" l10n="NEW">Show bars side by side</paragraph>
+<paragraph xml-lang="en-US" id="hd_id9842219" role="heading" level="2" l10n="NEW">Show bars side by side</paragraph>
<paragraph xml-lang="en-US" id="par_id9800103" role="paragraph" l10n="NEW">If two axes are shown in a bar chart, and some data series are attached to the first axis, while some other data series are attached to the second axis, then both sets of data series are shown independently, overlapping each other.</paragraph>
<paragraph xml-lang="en-US" id="par_id2144535" role="paragraph" l10n="NEW">As a result, bars attached to the first y-axis are partly or completely hidden by bars attached to the second y-axis. To avoid this, enable the option to display bars side by side. <ahelp hid=".">The bars from different data series are shown as if they were attached only to one axis.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_POLAROPTIONS:CB_CLOCKWISE" id="bm_id7622913" localize="false"/>
@@ -90,20 +90,21 @@
<paragraph xml-lang="en-US" id="par_id553910" role="note" l10n="NEW">In 3D pie and donut charts that were created with older versions of the software, the starting angle is 0 degrees instead of 90 degrees. For old and new 2D charts the default starting angle is 90 degrees.</paragraph>
<paragraph xml-lang="en-US" id="par_id1414838" role="note" l10n="NEW">When you change the starting angle or the direction, only current versions of the software show the changed values. Older versions of the software display the same document using the default values: Always counterclockwise direction and a starting value of 90 degrees (2D pie charts) or 0 degrees (3D pie charts).</paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2:NumericField:TP_POLAROPTIONS:NF_STARTING_ANGLE" id="bm_id5705740" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3179723" role="heading" level="3" l10n="NEW">Degrees</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3179723" role="heading" level="2" l10n="NEW">Degrees</paragraph>
<paragraph xml-lang="en-US" id="par_id2164067" role="paragraph" l10n="NEW"><ahelp hid=".">Enter the starting angle between 0 and 359 degrees. You can also click the arrows to change the displayed value.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id0305200910524613" role="heading" level="2" l10n="NEW">Plot missing values</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200910524650" role="paragraph" l10n="NEW">Sometimes values are missing in a data series that is shown in a chart. You can select from different options how to plot the missing values. The options are available for some chart types only.</paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2_RadioButton_TP_OPTIONS_RB_DONT_PAINT" id="bm_id0305200910520854" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id0305200910524823" role="heading" level="3" l10n="NEW">Leave gap</paragraph>
+<paragraph xml-lang="en-US" id="hd_id0305200910524823" role="heading" level="2" l10n="NEW">Leave gap</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200910524811" role="paragraph" l10n="NEW"><ahelp hid=".">For a missing value, no data will be shown. This is the default for chart types Column, Bar, Line, Net.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2_RadioButton_TP_OPTIONS_RB_ASSUME_ZERO" id="bm_id0305200910522325" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id0305200910524811" role="heading" level="3" l10n="NEW">Assume zero</paragraph>
+<paragraph xml-lang="en-US" id="hd_id0305200910524811" role="heading" level="2" l10n="NEW">Assume zero</paragraph>
<paragraph xml-lang="en-US" id="par_id030520091052489" role="paragraph" l10n="NEW"><ahelp hid=".">For a missing value, the y-value will be shown as zero. This is the default for chart type Area.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2_RadioButton_TP_OPTIONS_RB_CONTINUE_LINE" id="bm_id0305200910523975" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id0305200910524837" role="heading" level="3" l10n="NEW">Continue line</paragraph>
+<paragraph xml-lang="en-US" id="hd_id0305200910524837" role="heading" level="2" l10n="NEW">Continue line</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200910524938" role="paragraph" l10n="NEW"><ahelp hid=".">For a missing value, the interpolation from the neighbor values will be shown. This is the default for chart type XY.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id0305200910524937" role="heading" level="3" l10n="NEW">Plot values from hidden cells</paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2_CheckBox_TP_OPTIONS_CB_INCLUDE_HIDDEN_CELLS" id="bm_id0825200904350621" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id0305200910524937" role="heading" level="2" l10n="NEW">Include values from hidden cells</paragraph>
<paragraph xml-lang="en-US" id="par_id030520091052494" role="paragraph" l10n="NEW"><ahelp hid=".">Check to also show values of currently hidden cells within the source cell range.</ahelp></paragraph>
</body>
</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/01/04070000.xhp b/helpcontent2/source/text/schart/01/04070000.xhp
index 95d2e02b27..0b1b170a4f 100644
--- a/helpcontent2/source/text/schart/01/04070000.xhp
+++ b/helpcontent2/source/text/schart/01/04070000.xhp
@@ -48,9 +48,9 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3147434"><bookmark_value>axes; inserting grids</bookmark_value>
<bookmark_value>grids; inserting in charts</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:InsertGrids" id="bm_id3145748" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuGrids" id="bm_id3145748" localize="false"/>
<paragraph role="heading" id="hd_id3147434" xml-lang="en-US" level="1" l10n="U" oldref="1">Grids</paragraph>
-<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US" l10n="U" oldref="2"><variable id="gitter"><ahelp hid=".uno:InsertGrids">You can divide the axes into sections by assigning gridlines to them. This allows you to get a better overview of the chart, especially if you are working with large charts.</ahelp>
+<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US" l10n="U" oldref="2"><variable id="gitter"><ahelp hid=".">You can divide the axes into sections by assigning gridlines to them. This allows you to get a better overview of the chart, especially if you are working with large charts.</ahelp>
</variable> The Y axis major grid is activated by default.</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#efgaugg"/>
diff --git a/helpcontent2/source/text/schart/01/05010000.xhp b/helpcontent2/source/text/schart/01/05010000.xhp
index 5ba1a8b5c5..817dec6cfe 100644
--- a/helpcontent2/source/text/schart/01/05010000.xhp
+++ b/helpcontent2/source/text/schart/01/05010000.xhp
@@ -36,22 +36,18 @@
<helpdocument version="1.0">
<meta>
<topic id="textschart0105010000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Object Properties</title>
+<title id="tit" xml-lang="en-US">Format Selection</title>
<filename>/text/schart/01/05010000.xhp</filename>
</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2007-01-29T10:31:37">converted from old format - fpe</lastedited>
-</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3149666"><bookmark_value>objects;properties of charts</bookmark_value>
<bookmark_value>charts; properties</bookmark_value>
<bookmark_value>properties;charts</bookmark_value>
</bookmark><comment>mw changed "properties;"</comment>
-<bookmark xml-lang="en-US" branch="hid/.uno:DiagramObjects" id="bm_id3147436" localize="false"/>
-<paragraph role="heading" id="hd_id3149666" xml-lang="en-US" level="1" l10n="U" oldref="1">Object Properties</paragraph>
-<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="2"><variable id="objekteigenschaften"><ahelp hid=".uno:DiagramObjects">Assigns certain properties to the selected object.</ahelp>
+<bookmark xml-lang="en-US" branch="hid/.uno:FormatSelection" id="bm_id3147436" localize="false"/>
+<paragraph role="heading" id="hd_id3149666" xml-lang="en-US" level="1" l10n="U" oldref="1">Format Selection</paragraph>
+<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="2"><variable id="objekteigenschaften"><ahelp hid=".">Formats the selected object.</ahelp>
</variable> Depending on the object selected, the command opens dialogs that you can also open by choosing the following commands from the <emph>Format</emph> menu:</paragraph>
<section id="howtoget">
<embed href="text/schart/00/00000004.xhp#frtoes"/>
diff --git a/helpcontent2/source/text/schart/01/05010100.xhp b/helpcontent2/source/text/schart/01/05010100.xhp
index 8b715fa095..660df56330 100644
--- a/helpcontent2/source/text/schart/01/05010100.xhp
+++ b/helpcontent2/source/text/schart/01/05010100.xhp
@@ -46,7 +46,7 @@
<section id="datenpunkt">
<paragraph id="hd_id3153768" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/schart/01/05010100.xhp" name="Data Point">Data Point</link></paragraph>
- <paragraph xml-lang="en-US" role="paragraph" id="par_id3152577" l10n="U" oldref="2">This dialog allows you to change the properties of a selected data point. The dialog appears when there is only one data point selected when you choose <emph>Format - Object Properties</emph>. Some of the menu entries are only available for 2D or 3D charts.</paragraph>
+ <paragraph xml-lang="en-US" role="paragraph" id="par_id3152577" l10n="U" oldref="2">This dialog allows you to change the properties of a selected data point. The dialog appears when there is only one data point selected when you choose <emph>Format - Format Selection</emph>. Some of the menu entries are only available for 2D or 3D charts.</paragraph>
</section>
<paragraph role="note" id="par_id3149121" l10n="U" xml-lang="en-US" oldref="3">Any changes made only affect this one data point. For example, if you edit the color of a bar, only the color of that bar will be different.</paragraph>
<section id="howtoget">
diff --git a/helpcontent2/source/text/schart/01/05010200.xhp b/helpcontent2/source/text/schart/01/05010200.xhp
index d7d3b263b0..abfee069f3 100644
--- a/helpcontent2/source/text/schart/01/05010200.xhp
+++ b/helpcontent2/source/text/schart/01/05010200.xhp
@@ -45,7 +45,7 @@
<body>
<section id="datenreihe">
<paragraph role="heading" id="hd_id3150449" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/schart/01/05010200.xhp" name="Data Series">Data Series</link></paragraph>
-<paragraph role="paragraph" id="par_id3145750" xml-lang="en-US" l10n="U" oldref="2">Use this to change the properties of a selected data series. This dialog appears when one data series is selected when you choose <emph>Format - Object Properties</emph>. Some of the menu entries are only available for 2D or 3D charts.</paragraph>
+<paragraph role="paragraph" id="par_id3145750" xml-lang="en-US" l10n="U" oldref="2">Use this to change the properties of a selected data series. This dialog appears when one data series is selected when you choose <emph>Format - Format Selection</emph>. Some of the menu entries are only available for 2D or 3D charts.</paragraph>
</section>
<paragraph role="note" id="par_id3154015" xml-lang="en-US" l10n="U" oldref="4">Any changes made here affect the entire data series. For example, if you change the color, all elements belonging to this data series will change color.</paragraph>
<section id="howtoget">
diff --git a/helpcontent2/source/text/schart/01/05020100.xhp b/helpcontent2/source/text/schart/01/05020100.xhp
index bcc3a69d70..f6cb11933f 100644
--- a/helpcontent2/source/text/schart/01/05020100.xhp
+++ b/helpcontent2/source/text/schart/01/05020100.xhp
@@ -1,8 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
+
<!--
- ***********************************************************************
+***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
@@ -10,8 +10,8 @@
*
* OpenOffice.org - a multi-platform office productivity suite
*
- * $RCSfile: 05020100.xhp,v $
- * $Revision: 1.7 $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
@@ -32,37 +32,35 @@
*
************************************************************************
-->
+
-<helpdocument version="1.0">
<meta>
-<topic id="textschart0105020100xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Title</title>
-<filename>/text/schart/01/05020100.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2007-01-22T14:26:49">converted from old format - fpe</lastedited>
-</history>
-</meta>
-<body>
+ <topic id="textschart0105020100xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Title</title>
+ <filename>/text/schart/01/05020100.xhp</filename>
+ </topic>
+ </meta>
+ <body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150769"><bookmark_value>editing; titles</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:MainTitle" id="bm_id3150870" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:XTitle" id="bm_id3150441" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:ZTitle" id="bm_id3153771" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:SubTitle" id="bm_id3154686" localize="false"/><comment>moved the subtitle bookmark here from 0502020</comment>
-<paragraph role="heading" id="hd_id3150769" xml-lang="en-US" level="1" l10n="U" oldref="2">Title</paragraph>
-<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US" l10n="U" oldref="1"><variable id="titel"><ahelp hid=".uno:ZTitle">Modifies the properties of the selected title.</ahelp>
+<bookmark xml-lang="en-US" branch="hid/.uno:SubTitle" id="bm_id3154686" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:SecondaryXTitle" id="bm_id082520090430086" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:SecondaryYTitle" id="bm_id0825200904302515" localize="false"/><comment>moved the subtitle bookmark here from 0502020</comment>
+<paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1" l10n="U" oldref="2">Title</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149666" role="paragraph" l10n="U" oldref="1"><variable id="titel"><ahelp hid=".uno:ZTitle">Modifies the properties of the selected title.</ahelp>
</variable></paragraph>
-<section id="howtoget">
- <embed href="text/schart/00/00000004.xhp#frtoe"/>
-</section>
-<embed href="text/shared/01/05200100.xhp#linie"/>
-<embed href="text/shared/01/05210100.xhp#flaeche"/>
-<embed href="text/shared/01/05210700.xhp#transparenz"/>
-<paragraph role="heading" id="hd_id3149378" xml-lang="en-US" level="2" l10n="U" oldref="3"><link href="text/shared/01/05020100.xhp" name="Character">Character</link></paragraph>
-<embed href="text/shared/01/05020100.xhp#zn"/>
-<embed href="text/schart/01/05020101.xhp#ausricht"/>
-<embed href="text/shared/00/00000001.xhp#zurueck"/>
-</body>
-</helpdocument>
+ <section id="howtoget">
+ <embed href="text/schart/00/00000004.xhp#frtoe"/>
+ </section>
+ <embed href="text/shared/01/05200100.xhp#linie"/>
+ <embed href="text/shared/01/05210100.xhp#flaeche"/>
+ <embed href="text/shared/01/05210700.xhp#transparenz"/>
+ <paragraph xml-lang="en-US" id="hd_id3149378" role="heading" level="2" l10n="U" oldref="3"><link href="text/shared/01/05020100.xhp" name="Character">Character</link></paragraph>
+ <embed href="text/shared/01/05020100.xhp#zn"/>
+ <embed href="text/schart/01/05020101.xhp#ausricht"/>
+ <embed href="text/shared/00/00000001.xhp#zurueck"/>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/01/three_d_view.xhp b/helpcontent2/source/text/schart/01/three_d_view.xhp
index 8c64baccd5..83175cd14a 100644
--- a/helpcontent2/source/text/schart/01/three_d_view.xhp
+++ b/helpcontent2/source/text/schart/01/three_d_view.xhp
@@ -1,9 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
+<helpdocument version="1.0">
+
<!--
- ***********************************************************************
+***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
@@ -11,8 +10,8 @@
*
* OpenOffice.org - a multi-platform office productivity suite
*
- * $RCSfile: three_d_view.xhp,v $
- * $Revision: 1.7 $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
@@ -33,128 +32,146 @@
*
************************************************************************
-->
-
-
- <helpdocument version="1.0">
+
+
<meta>
-<topic id="textschart01three_d_viewxhp" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">3D View </title>
-<filename>/text/schart/01/three_d_view.xhp</filename>
-</topic>
-</meta>
-<body>
+ <topic id="textschart01three_d_viewxhp" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">3D View </title>
+ <filename>/text/schart/01/three_d_view.xhp</filename>
+ </topic>
+ </meta>
+ <body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3156423"><bookmark_value>3D charts</bookmark_value>
-<bookmark_value>charts; 3D views</bookmark_value>
-<bookmark_value>illumination; 3D charts</bookmark_value>
+ <bookmark_value>charts; 3D views</bookmark_value>
+ <bookmark_value>illumination; 3D charts</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:View3D" id="bm_id3150449" localize="false"/><comment>mw made "3D charts;" a one level entry</comment><paragraph role="heading" id="hd_id3464461" xml-lang="en-US" level="1" l10n="NEW"><variable id="three_d_view"><link href="text/schart/01/three_d_view.xhp">3D View</link>
+<bookmark xml-lang="en-US" branch="hid/.uno:View3D" id="bm_id3150449" localize="false"/><comment>mw made "3D charts;" a one level entry</comment>
+<paragraph xml-lang="en-US" id="hd_id3464461" role="heading" level="1" l10n="NEW"><variable id="three_d_view"><link href="text/schart/01/three_d_view.xhp">3D View</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id6998809" xml-lang="en-US" l10n="CHG">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> or in the context menu of a chart you can choose a chart type. <ahelp hid="." visibility="hidden">Enables a three dimensional view for Column, Bar, Pie, and Area charts. For Line and XY (Scatter) charts you can see 3D lines.</ahelp><comment>must be AHID, see i80656</comment></paragraph>
-<section id="howtoget">
- <embed href="text/schart/00/00000004.xhp#wiz"/>
-</section>
-<embed href="text/shared/00/00000001.xhp#ShiftF1"/>
-<paragraph role="paragraph" id="par_id6942045" xml-lang="en-US" l10n="NEW">The chart preview responds to the new settings that you enter in the dialog. </paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id3806878" xml-lang="en-US" l10n="NEW">When you leave the dialog with OK, the settings are applied permanently. </paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id130619" xml-lang="en-US" l10n="NEW">When you leave the dialog with Cancel or Escape, the chart returns to the state when you opened the dialog.</paragraph>
-</listitem>
-</list>
-<paragraph role="paragraph" id="par_id8081911" xml-lang="en-US" l10n="NEW">For a 3D chart you can choose <item type="menuitem">Format - 3D View</item> to set perspective, appearance and illumination.</paragraph>
-<paragraph role="heading" id="hd_id2924283" xml-lang="en-US" level="2" l10n="NEW">Perspective</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id5781731" xml-lang="en-US" l10n="NEW">Enter the values for rotation of the chart on the three axes and for a perspective view.</paragraph>
-</listitem>
-</list>
-<paragraph role="paragraph" id="par_id9999694" xml-lang="en-US" l10n="NEW">Set all angles to 0 for a front view of the chart. Pie charts and donut charts are shown as circles.</paragraph>
-<paragraph role="paragraph" id="par_id2861720" xml-lang="en-US" l10n="NEW">With Right-angled axes enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders.</paragraph>
-<paragraph role="paragraph" id="par_id2216559" xml-lang="en-US" l10n="NEW">An x value of 90, with y and z set to 0, provides a view from top down to the chart. With x set to -90, you see the bottom of the chart.</paragraph>
-<paragraph role="paragraph" id="par_id7869502" xml-lang="en-US" l10n="NEW">The rotations are applied in the order first x, then y, last z.</paragraph>
-<paragraph role="paragraph" id="par_id9852900" xml-lang="en-US" 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 role="note" id="par_id2578203" xml-lang="en-US" 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 role="paragraph" id="par_id4923245" xml-lang="en-US" 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 role="paragraph" id="par_id3416547" xml-lang="en-US" 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 role="note" id="par_id3791924" xml-lang="en-US" 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"/><paragraph role="paragraph" id="par_id7623828" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">If Right-angled axes is enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. Right-angled axes is enabled by default for newly created 3D charts. Pie and Donut charts do not support right-angled axes.</ahelp></paragraph><comment>X rotation</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_X_ROTATION" id="bm_id6549272" localize="false"/><paragraph role="paragraph" id="par_id4721823" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the x axis. The preview responds to the new settings.</ahelp></paragraph><comment>Y rotation </comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_Y_ROTATION" id="bm_id6529740" localize="false"/><paragraph role="paragraph" id="par_id5806756" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the y axis. The preview responds to the new settings.</ahelp></paragraph><comment>z rotation</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_Z_ROTATION" id="bm_id9121982" localize="false"/><paragraph role="paragraph" id="par_id8915372" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the z axis. The preview responds to the new settings.</ahelp></paragraph><comment>perspective</comment>
+ <paragraph xml-lang="en-US" id="par_id6998809" role="paragraph" l10n="CHG">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> or in the context menu of a chart you can choose a chart type. <ahelp hid="." visibility="hidden">Opens a dialog to edit the properties of a three dimensional view for Column, Bar, Pie, and Area charts. For Line and XY (Scatter) charts you can see 3D lines.</ahelp><comment>must be AHID, see i80656</comment></paragraph>
+ <section id="howtoget">
+ <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>
+ <list type="ordered">
+ <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>
+ </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>
+ </listitem>
+ </list>
+ <paragraph xml-lang="en-US" id="par_id8081911" role="paragraph" l10n="NEW">For a 3D chart you can choose <item type="menuitem">Format - 3D View</item> to set perspective, appearance and illumination.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2924283" role="heading" level="2" l10n="NEW">Perspective</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id5781731" role="paragraph" l10n="NEW">Enter the values for rotation of the chart on the three axes and for a perspective view.</paragraph>
+ </listitem>
+ </list>
+ <paragraph xml-lang="en-US" id="par_id9999694" role="paragraph" l10n="NEW">Set all angles to 0 for a front view of the chart. Pie charts and donut charts are shown as circles.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2861720" role="paragraph" l10n="NEW">With Right-angled axes enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2216559" role="paragraph" l10n="NEW">An x value of 90, with y and z set to 0, provides a view from top down to the chart. With x set to -90, you see the bottom of the chart.</paragraph>
+ <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_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"/>
+<paragraph xml-lang="en-US" id="par_id7623828" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">If Right-angled axes is enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. Right-angled axes is enabled by default for newly created 3D charts. Pie and Donut charts do not support right-angled axes.</ahelp></paragraph><comment>X rotation</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_X_ROTATION" id="bm_id6549272" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id4721823" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the x axis. The preview responds to the new settings.</ahelp></paragraph><comment>Y rotation </comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_Y_ROTATION" id="bm_id6529740" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id5806756" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the y axis. The preview responds to the new settings.</ahelp></paragraph><comment>z rotation</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_Z_ROTATION" id="bm_id9121982" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id8915372" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Sets the rotation of the chart on the z axis. The preview responds to the new settings.</ahelp></paragraph><comment>perspective</comment>
<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_3D_SCENEGEOMETRY:CBX_PERSPECTIVE" id="bm_id2394482" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_PERSPECTIVE" id="bm_id3808404" localize="false"/><paragraph role="paragraph" id="par_id6070436" xml-lang="en-US" l10n="CHG"><ahelp hid="." visibility="hidden">Mark the Perspective box to view the chart as through a camera lens. Use the spin button to set the percentage. With a high percentage nearer objects look bigger than more distant objects.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id7564012" xml-lang="en-US" level="2" l10n="NEW">Appearance</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id1186254" xml-lang="en-US" l10n="NEW">Select a scheme from the list box.</paragraph>
-</listitem>
-</list>
-<paragraph role="paragraph" id="par_id7432477" xml-lang="en-US" l10n="NEW">By selecting a scheme, the check boxes and the light sources are set accordingly.</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id7141026" xml-lang="en-US" 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 role="paragraph" id="par_id1579027" xml-lang="en-US" l10n="NEW">Mark <emph>Shading</emph> to use the Gouraud method for rendering the surface, otherwise a flat method is used. </paragraph>
-<paragraph role="paragraph" id="par_id5624561" xml-lang="en-US" 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 role="paragraph" id="par_id5901058" xml-lang="en-US" 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>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id8469191" xml-lang="en-US" l10n="NEW">Mark <emph>Object Borders</emph> to draw lines along the edges.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id4407483" xml-lang="en-US" l10n="NEW">Mark <emph>Rounded Edges</emph> to smooth the edges of box shapes.</paragraph>
-</listitem>
-</list><comment>Scheme</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_3D_SCENEAPPEARANCE:LB_SCHEME" id="bm_id631733" localize="false"/><paragraph role="paragraph" id="par_id8531449" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select a scheme from the list box, or click any of the check boxes below.</ahelp></paragraph><comment>Shading</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_3D_SCENEAPPEARANCE:CB_SHADING" id="bm_id7811822" localize="false"/><paragraph role="paragraph" id="par_id9183935" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Applies Gouraud shading if marked, or flat shading if unmarked.</ahelp></paragraph><comment>Object borders</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_3D_SCENEAPPEARANCE:CB_OBJECTLINES" id="bm_id3640247" localize="false"/><paragraph role="paragraph" id="par_id946684" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Shows borders around the areas by setting the line style to Solid.</ahelp></paragraph><comment>Rounded Edges</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:Checkbox:TP_3D_SCENEAPPEARANCE:CB_ROUNDEDEDGE" id="bm_id4585100" localize="false"/><paragraph role="paragraph" id="par_id9607226" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Edges are rounded by 5%.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id1939451" xml-lang="en-US" level="2" l10n="NEW">Illumination</paragraph>
-<paragraph role="paragraph" id="par_id9038972" xml-lang="en-US" l10n="NEW">Set the light sources for the 3D view.</paragraph>
-<list type="ordered">
-<listitem>
-<paragraph role="paragraph" id="par_id6531266" xml-lang="en-US" l10n="NEW">Click any of the eight buttons to switch a directed light source on or off.</paragraph>
-<paragraph role="paragraph" id="par_id6173894" xml-lang="en-US" l10n="NEW">By default, the second light source is switched on. It is the first of seven "normal", uniform light sources. The light source number one projects a specular light with highlights.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id2761314" xml-lang="en-US" l10n="CHG">For the selected light source, you can then choose a color and intensity in the list box just below the eight buttons. The brightness values of all lights are added, so use dark colors when you enable multiple lights.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id3912778" xml-lang="en-US" l10n="NEW">The small preview inside this tab page has two sliders to set the vertical and horizontal position of the selected light source. The light source always aims to the middle of the object.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id3163853" xml-lang="en-US" l10n="NEW">The button in the corner of the small preview switches the internal illumination model between a sphere and a cube.<comment>Regina: Are you sure? I thought, that it only toggles the preview in the dialog.</comment></paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id121158" xml-lang="en-US" l10n="NEW">Use the Ambient light list box to define the ambient light which shines with a uniform intensity from all directions.</paragraph>
-</listitem>
-</list><comment>preview right bar</comment>
-<bookmark xml-lang="en-US" branch="hid/34145" id="bm_id8956572" localize="false"/><paragraph role="paragraph" id="par_id2423780" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Drag the right slider to set the vertical height and direction of the selected light source.</ahelp></paragraph><comment>preview bottom bar</comment>
-<bookmark xml-lang="en-US" branch="hid/34144" id="bm_id500808" localize="false"/><paragraph role="paragraph" id="par_id2569658" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Drag the bottom slider to set the horizontal position and direction of the selected light source.</ahelp></paragraph><comment>preview right bottom button</comment>
-<bookmark xml-lang="en-US" branch="hid/34146" id="bm_id8366649" localize="false"/><paragraph role="paragraph" id="par_id6394238" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to switch between an illumination model of a sphere or a cube.</ahelp></paragraph><comment>Light source</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_1" id="bm_id2334665" localize="false"/><paragraph role="paragraph" id="par_id533768" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to enable or disable the specular light source with highlights.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2:MetricField:TP_3D_SCENEGEOMETRY:MTR_FLD_PERSPECTIVE" id="bm_id3808404" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id6070436" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Mark the Perspective box to view the chart as through a camera lens. Use the spin button to set the percentage. With a high percentage nearer objects look bigger than more distant objects.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id7564012" role="heading" level="2" l10n="NEW">Appearance</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id1186254" role="paragraph" l10n="NEW">Select a scheme from the list box.</paragraph>
+ </listitem>
+ </list>
+ <paragraph xml-lang="en-US" id="par_id7432477" role="paragraph" l10n="NEW">By selecting a scheme, the check boxes and the light sources are set accordingly.</paragraph>
+ <list type="ordered">
+ <listitem>
+ <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_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>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id8469191" role="paragraph" l10n="NEW">Mark <emph>Object Borders</emph> to draw lines along the edges.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id4407483" role="paragraph" l10n="NEW">Mark <emph>Rounded Edges</emph> to smooth the edges of box shapes.</paragraph>
+ </listitem>
+ </list><comment>Scheme</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_3D_SCENEAPPEARANCE:LB_SCHEME" id="bm_id631733" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id8531449" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select a scheme from the list box, or click any of the check boxes below.</ahelp></paragraph><comment>Shading</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_3D_SCENEAPPEARANCE:CB_SHADING" id="bm_id7811822" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id9183935" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Applies Gouraud shading if marked, or flat shading if unmarked.</ahelp></paragraph><comment>Object borders</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:CheckBox:TP_3D_SCENEAPPEARANCE:CB_OBJECTLINES" id="bm_id3640247" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id946684" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Shows borders around the areas by setting the line style to Solid.</ahelp></paragraph><comment>Rounded Edges</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:Checkbox:TP_3D_SCENEAPPEARANCE:CB_ROUNDEDEDGE" id="bm_id4585100" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id9607226" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Edges are rounded by 5%.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id1939451" role="heading" level="2" l10n="NEW">Illumination</paragraph>
+ <paragraph xml-lang="en-US" id="par_id9038972" role="paragraph" l10n="NEW">Set the light sources for the 3D view.</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id6531266" role="paragraph" l10n="NEW">Click any of the eight buttons to switch a directed light source on or off.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id6173894" role="paragraph" l10n="NEW">By default, the second light source is switched on. It is the first of seven "normal", uniform light sources. The light source number one projects a specular light with highlights.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id2761314" role="paragraph" l10n="CHG">For the selected light source, you can then choose a color and intensity in the list box just below the eight buttons. The brightness values of all lights are added, so use dark colors when you enable multiple lights.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id3912778" role="paragraph" l10n="NEW">The small preview inside this tab page has two sliders to set the vertical and horizontal position of the selected light source. The light source always aims to the middle of the object.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id3163853" role="paragraph" l10n="NEW">The button in the corner of the small preview switches the internal illumination model between a sphere and a cube.<comment>Regina: Are you sure? I thought, that it only toggles the preview in the dialog.</comment></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id121158" role="paragraph" l10n="NEW">Use the Ambient light list box to define the ambient light which shines with a uniform intensity from all directions.</paragraph>
+ </listitem>
+ </list><comment>preview right bar</comment>
+<bookmark xml-lang="en-US" branch="hid/34145" id="bm_id8956572" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id2423780" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Drag the right slider to set the vertical height and direction of the selected light source.</ahelp></paragraph><comment>preview bottom bar</comment>
+<bookmark xml-lang="en-US" branch="hid/34144" id="bm_id500808" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id2569658" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Drag the bottom slider to set the horizontal position and direction of the selected light source.</ahelp></paragraph><comment>preview right bottom button</comment>
+<bookmark xml-lang="en-US" branch="hid/34146" id="bm_id8366649" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id6394238" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to switch between an illumination model of a sphere or a cube.</ahelp></paragraph><comment>Light source</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_1" id="bm_id2334665" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id533768" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to enable or disable the specular light source with highlights.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_2" id="bm_id476393" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_3" id="bm_id2655720" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_4" id="bm_id3682058" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_5" id="bm_id5977965" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_6" id="bm_id3050325" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_7" id="bm_id9421979" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_8" id="bm_id1646778" localize="false"/><paragraph role="paragraph" id="par_id7214270" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to enable or disable the uniform light source.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_3D_SCENEILLUMINATION:LB_LIGHTSOURCE" id="bm_id1601611" localize="false"/><paragraph role="paragraph" id="par_id2186346" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color for the selected light source.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHTSOURCE_COLOR" id="bm_id733359" localize="false"/><paragraph role="paragraph" id="par_id1331217" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color using the color dialog.</ahelp></paragraph><comment>Ambient light</comment>
-<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_3D_SCENEILLUMINATION:LB_AMBIENTLIGHT" id="bm_id1228370" localize="false"/><paragraph role="paragraph" id="par_id393993" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color for the ambient light.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_AMBIENT_COLOR" id="bm_id879848" localize="false"/><paragraph role="paragraph" id="par_id5871761" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color using the color dialog.</ahelp></paragraph>
-<section id="relatedtopics">
-<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
-<embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
-<embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/>
-<embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/>
-<embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
-</section>
-</body>
-</helpdocument>
+<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHT_8" id="bm_id1646778" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id7214270" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to enable or disable the uniform light source.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_3D_SCENEILLUMINATION:LB_LIGHTSOURCE" id="bm_id1601611" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id2186346" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color for the selected light source.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_LIGHTSOURCE_COLOR" id="bm_id733359" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id1331217" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color using the color dialog.</ahelp></paragraph><comment>Ambient light</comment>
+<bookmark xml-lang="en-US" branch="hid/chart2:ListBox:TP_3D_SCENEILLUMINATION:LB_AMBIENTLIGHT" id="bm_id1228370" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id393993" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color for the ambient light.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/chart2:ImageButton:TP_3D_SCENEILLUMINATION:BTN_AMBIENT_COLOR" id="bm_id879848" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id5871761" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select a color using the color dialog.</ahelp></paragraph>
+ <section id="relatedtopics">
+ <embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
+ <embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
+ <embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/>
+ <embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/>
+ <embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
+ </section>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/01/type_stock.xhp b/helpcontent2/source/text/schart/01/type_stock.xhp
index 230e8aada7..3290c9a0ce 100644
--- a/helpcontent2/source/text/schart/01/type_stock.xhp
+++ b/helpcontent2/source/text/schart/01/type_stock.xhp
@@ -1,9 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
+<helpdocument version="1.0">
+
<!--
- ***********************************************************************
+***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
@@ -11,8 +10,8 @@
*
* OpenOffice.org - a multi-platform office productivity suite
*
- * $RCSfile: type_stock.xhp,v $
- * $Revision: 1.7 $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
@@ -33,247 +32,253 @@
*
************************************************************************
-->
-
-
- <helpdocument version="1.0">
+
+
<meta>
-<topic id="textschart01type_stockxhp" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Chart Type Stock</title>
-<filename>/text/schart/01/type_stock.xhp</filename>
-</topic>
-</meta>
-<body>
+ <topic id="textschart01type_stockxhp" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Chart Type Stock</title>
+ <filename>/text/schart/01/type_stock.xhp</filename>
+ </topic>
+ </meta>
+ <body>
<bookmark xml-lang="en-US" branch="index" id="bm_id2959990"><bookmark_value>stock charts</bookmark_value>
-<bookmark_value>chart types;stock</bookmark_value>
-<bookmark_value>data sources;setting for stock charts</bookmark_value>
-</bookmark><comment>mw added one entry</comment><paragraph role="heading" id="hd_id966216" xml-lang="en-US" level="1" l10n="NEW"><variable id="type_stock"><link href="text/schart/01/type_stock.xhp">Chart Type Stock</link>
+ <bookmark_value>chart types;stock</bookmark_value>
+ <bookmark_value>data sources;setting for stock charts</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<paragraph xml-lang="en-US" id="hd_id966216" role="heading" level="1" l10n="NEW"><variable id="type_stock"><link href="text/schart/01/type_stock.xhp">Chart Type Stock</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3516953" 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>
-<paragraph role="heading" id="hd_id5268410" xml-lang="en-US" level="2" l10n="NEW">Stock</paragraph>
-<paragraph role="paragraph" id="par_id61342" xml-lang="en-US" l10n="NEW">A Stock chart illustrates the market trend given by opening price, bottom price, top price and closing price. The transaction volume can also be shown.<comment>UFI: should we show example charts for every type?</comment></paragraph>
-<paragraph role="paragraph" id="par_id2131412" xml-lang="en-US" l10n="NEW">For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below.</paragraph>
-<table id="tbl_id1370586">
-<tablerow>
-<tablecell colspan="" rowspan=""/>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id1022064" xml-lang="en-US" l10n="NEW">A</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id1924192" xml-lang="en-US" l10n="NEW">B</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3258156" xml-lang="en-US" l10n="NEW">C</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3161412" xml-lang="en-US" l10n="NEW">D</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id5619373" xml-lang="en-US" l10n="NEW">E</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id6474501" xml-lang="en-US" l10n="NEW">F</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7411725" xml-lang="en-US" l10n="NEW">1</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan=""/>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1933957" xml-lang="en-US" l10n="NEW">Transaction volume</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1274452" xml-lang="en-US" l10n="NEW">Opening price</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id5044404" xml-lang="en-US" l10n="NEW">Low (bottom price)</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3892635" xml-lang="en-US" l10n="NEW">High (top price)</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id4641865" xml-lang="en-US" l10n="NEW">Closing price</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7684560" xml-lang="en-US" l10n="NEW">2</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3998840" xml-lang="en-US" l10n="NEW">Monday</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7675099" xml-lang="en-US" l10n="NEW">2500</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7806329" xml-lang="en-US" l10n="NEW">20</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id5589159" xml-lang="en-US" l10n="NEW">15</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id9936216" xml-lang="en-US" l10n="NEW">25</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7953123" xml-lang="en-US" l10n="NEW">17</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id4013794" xml-lang="en-US" l10n="NEW">3</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1631824" xml-lang="en-US" l10n="NEW">Tuesday</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7271645" xml-lang="en-US" l10n="NEW">3500</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2136295" xml-lang="en-US" l10n="NEW">32</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id4186223" xml-lang="en-US" l10n="NEW">22</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1491134" xml-lang="en-US" l10n="NEW">37</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2873622" xml-lang="en-US" l10n="NEW">30</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2374034" xml-lang="en-US" l10n="NEW">4</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1687063" xml-lang="en-US" l10n="NEW">Wednesday</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id8982207" xml-lang="en-US" l10n="NEW">1000</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7074190" xml-lang="en-US" l10n="NEW">15</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id5452436" xml-lang="en-US" l10n="NEW">15</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id9527878" xml-lang="en-US" l10n="NEW">17</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id6342356" xml-lang="en-US" l10n="NEW">17</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id166936" xml-lang="en-US" l10n="NEW">5</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id6826990" xml-lang="en-US" l10n="NEW">Thursday</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id6897183" xml-lang="en-US" l10n="NEW">2200</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7003387" xml-lang="en-US" l10n="NEW">40</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id4897915" xml-lang="en-US" l10n="NEW">30</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3105868" xml-lang="en-US" l10n="NEW">47</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3908810" xml-lang="en-US" l10n="NEW">35</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id9461653" xml-lang="en-US" l10n="NEW">6</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id9239173" xml-lang="en-US" l10n="NEW">Friday</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2656941" xml-lang="en-US" l10n="NEW">4600</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id1481063" xml-lang="en-US" l10n="NEW">27</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id7921079" xml-lang="en-US" l10n="NEW">20</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id636921" xml-lang="en-US" l10n="NEW">32</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id2799157" xml-lang="en-US" l10n="NEW">31</paragraph>
-</tablecell>
-</tablerow>
-</table>
-<paragraph role="paragraph" id="par_id3004547" xml-lang="en-US" l10n="NEW">The open, low, high, and closing values of a row build together one data unit in the chart. A stock price data series consists of several rows containing such data units. The column containing the transaction volume builds an optional second data series.</paragraph>
-<paragraph role="paragraph" id="par_id6401867" xml-lang="en-US" l10n="NEW">Depending on the chosen variant, you do not need all columns.</paragraph>
-<paragraph role="heading" id="hd_id18616" xml-lang="en-US" level="2" l10n="NEW">Stock Chart Variants</paragraph>
-<paragraph role="paragraph" id="par_id6138492" xml-lang="en-US" l10n="NEW">Choose the <emph>Stock</emph> chart type on the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart wizard</link>. Then select one of the four variants.</paragraph>
-<paragraph role="heading" id="hd_id4569231" xml-lang="en-US" level="3" l10n="NEW">Type 1</paragraph>
-<paragraph role="paragraph" id="par_id291451" xml-lang="en-US" l10n="NEW">Based on<emph> low</emph>
-<emph>and high </emph>column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line.</paragraph>
-<paragraph role="paragraph" id="par_id3341776" xml-lang="en-US" l10n="NEW">Based on<emph> low, high,</emph> and <emph>close</emph> column Type 1 shows an additional horizontal mark <emph>for</emph> the closing price.</paragraph>
-<paragraph role="heading" id="hd_id5947141" xml-lang="en-US" level="3" l10n="NEW">Type 2</paragraph>
-<paragraph role="paragraph" id="par_id1911679" xml-lang="en-US" l10n="CHG">Based on <emph>open, low, high</emph>, and <emph>close</emph> column Type 2 generates the traditional "candle stick" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values.</paragraph>
-<paragraph role="heading" id="hd_id9364909" xml-lang="en-US" level="3" l10n="NEW">Type 3</paragraph>
-<paragraph role="paragraph" id="par_id4473403" xml-lang="en-US" l10n="CHG">Based on <emph>volume, low, high</emph>, and <emph>close</emph> column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.<comment>i80596</comment></paragraph>
-<paragraph role="heading" id="hd_id4313791" xml-lang="en-US" level="3" l10n="NEW">Type 4</paragraph>
-<paragraph role="paragraph" id="par_id4331797" xml-lang="en-US" l10n="CHG">Based on all five data columns <emph>volume, open, low, high</emph>, and <emph>close</emph>, Type 4 combines a chart of Type 2 with a column chart for the transaction volume.</paragraph>
-<paragraph role="paragraph" id="par_id4191717" xml-lang="en-US" l10n="NEW">Because measurement for transaction volume might be "units", a second y axis is introduced in chart Type 3 and Type 4. The price axis is shown on the right side and the volume axis on the left side.</paragraph>
-<paragraph role="heading" id="hd_id2318796" xml-lang="en-US" level="2" l10n="NEW">Setting the Data Source</paragraph>
-<paragraph role="heading" id="hd_id399182" xml-lang="en-US" level="3" l10n="NEW">Charts based on its own data</paragraph>
-<paragraph role="paragraph" id="par_id5298318" xml-lang="en-US" 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 role="paragraph" id="par_id7588732" xml-lang="en-US" l10n="NEW">In an embedded chart data table, the data series are always organized in columns.</paragraph>
-<paragraph role="paragraph" id="par_id95828" xml-lang="en-US" 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 role="paragraph" id="par_id6182744" xml-lang="en-US" 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 role="paragraph" id="par_id3496200" xml-lang="en-US" 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 role="paragraph" id="par_id7599108" xml-lang="en-US" 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>
-<paragraph role="heading" id="hd_id888698" xml-lang="en-US" level="3" l10n="NEW">Charts based on Calc or Writer tables</paragraph>
-<paragraph role="paragraph" id="par_id3394573" xml-lang="en-US" l10n="NEW">You can choose or alter a data range on the second page of the Chart wizard or in the <link href="text/schart/01/wiz_data_range.xhp">Data Range</link> dialog. For fine tuning use the <link href="text/schart/01/wiz_data_series.xhp">Data Series</link> dialog.</paragraph>
-<paragraph role="paragraph" id="par_id7594225" xml-lang="en-US" l10n="NEW">To specify a data range do one of the following:</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id5081637" xml-lang="en-US" l10n="NEW">Enter the data range in the text box.</paragraph>
-<paragraph role="paragraph" id="par_id9759514" xml-lang="en-US" l10n="NEW">In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".</paragraph>
-<paragraph role="paragraph" id="par_id1614429" xml-lang="en-US" l10n="NEW">As long as the syntax is not correct, %PRODUCTNAME shows the text in red.</paragraph>
-</listitem>
-</list>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id1589098" xml-lang="en-US" l10n="NEW">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click <emph>Select data range</emph> again to add a data range. In the input field of the minimized dialog, click after the entry and type a semicolon. Then drag to select the next range.</paragraph>
-</listitem>
-</list>
-<paragraph role="paragraph" id="par_id8746910" xml-lang="en-US" l10n="NEW">Click one of the options for data series in rows or in columns. </paragraph>
-<paragraph role="paragraph" id="par_id9636524" xml-lang="en-US" l10n="NEW">Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".<comment>I don't know whether copying a table based chart to draw or impress needs chart data arranged in columns, and I cannot test it, because the clipboard is broken.</comment></paragraph>
-<paragraph role="heading" id="hd_id5675527" xml-lang="en-US" level="2" l10n="NEW">Fine Tuning the Data Ranges of Table Based Stock Charts</paragraph>
-<paragraph role="paragraph" id="par_id3486434" xml-lang="en-US" l10n="NEW">You can organize data series and edit the source for parts of single data series on the third page of the Chart wizard or on the page Data Series in the Data Range dialog.</paragraph>
-<paragraph role="heading" id="hd_id3068636" xml-lang="en-US" level="3" l10n="NEW">Organize Data Series</paragraph>
-<paragraph role="paragraph" id="par_id2480849" xml-lang="en-US" l10n="NEW">In the <emph>data series</emph> area on the left side of the dialog, you can organize the data series of the actual chart. A stock chart has at least one data series containing the prices. It might have a second data series for transaction volume.</paragraph>
-<paragraph role="paragraph" id="par_id4181951" xml-lang="en-US" l10n="CHG">If you have got more than one price data series, use the Up and Down arrow buttons to order them. The order determines the arrangement in the chart. Do the same for volume data series. You cannot switch price and volume data series.</paragraph>
-<paragraph role="paragraph" id="par_id2927335" xml-lang="en-US" l10n="NEW">To remove a data series, select the data series in the list and click <emph>Remove</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id2107303" xml-lang="en-US" l10n="NEW">To add a data series, select one of the existing data series and click <emph>Add</emph>. You get an empty entry below the selected one, which has the same type. If you have no price data series or no volume data series, you must first select a range for these series in the <emph>Data Range</emph> dialog.<comment>Regina: The behavior is odd, but I don't know a better solution. Therefore I have not written an issue.</comment></paragraph>
-<paragraph role="heading" id="hd_id4071779" xml-lang="en-US" level="3" l10n="NEW">Setting Data Ranges</paragraph>
-<paragraph role="paragraph" id="par_id7844477" xml-lang="en-US" l10n="NEW">In the <emph>Data Ranges</emph> dialog you can set or change the data range of each component of the selected data series.</paragraph>
-<paragraph role="paragraph" id="par_id6478469" xml-lang="en-US" l10n="NEW">In the upper list you see the role name of the components and the current values. When you have selected a role, you can change the value in the text box below the list. The label shows the selected role.</paragraph><comment>deleted a para, see i80596</comment><paragraph role="paragraph" id="par_id9038972" xml-lang="en-US" l10n="NEW">Enter the range into the text box or click on <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph>
-<paragraph role="paragraph" id="par_id7985168" xml-lang="en-US" l10n="NEW">Select Open Values, Close Values, High Values, and Low Values in any order. Specify only the ranges for those roles which you need for the chosen variant of the stock chart. The ranges need not be next to each other in the table.</paragraph>
-<paragraph role="heading" id="hd_id876186" xml-lang="en-US" level="3" l10n="NEW">Legend</paragraph>
-<paragraph role="paragraph" id="par_id3939634" xml-lang="en-US" l10n="NEW">The legend displays the labels from the first row or column or from the special range that you have set in the <emph>Data Series</emph> dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.</paragraph><comment>deleted 3 paras</comment><paragraph role="paragraph" id="par_id2377697" xml-lang="en-US" l10n="NEW">The legend shows the value from the range, which you entered in the <emph>Range for Name</emph> field in the <emph>Data Range</emph> dialog. The default entry is the column header of the closing price column.</paragraph>
-<paragraph role="paragraph" id="par_id2188787" xml-lang="en-US" l10n="NEW">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph>
-<section id="relatedtopics">
-<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
-<embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
-<embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/>
-<embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/>
-<embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
-</section>
-</body>
-</helpdocument>
+ <paragraph xml-lang="en-US" id="par_id3516953" 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>
+ <paragraph xml-lang="en-US" id="hd_id5268410" role="heading" level="1" l10n="NEW">Stock</paragraph>
+ <paragraph xml-lang="en-US" id="par_id61342" role="paragraph" l10n="NEW">A Stock chart illustrates the market trend given by opening price, bottom price, top price and closing price. The transaction volume can also be shown.<comment>UFI: should we show example charts for every type?</comment></paragraph>
+ <paragraph xml-lang="en-US" id="par_id2131412" role="paragraph" l10n="NEW">For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below.</paragraph>
+ <table id="tbl_id1370586">
+ <tablerow>
+ <tablecell>
+</tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1022064" role="tablehead" l10n="NEW">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1924192" role="tablehead" l10n="NEW">B</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3258156" role="tablehead" l10n="NEW">C</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3161412" role="tablehead" l10n="NEW">D</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id5619373" role="tablehead" l10n="NEW">E</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id6474501" role="tablehead" l10n="NEW">F</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7411725" role="tablecontent" l10n="NEW">1</paragraph>
+ </tablecell>
+ <tablecell>
+</tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1933957" role="tablecontent" l10n="NEW">Transaction volume</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1274452" role="tablecontent" l10n="NEW">Opening price</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id5044404" role="tablecontent" l10n="NEW">Low (bottom price)</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3892635" role="tablecontent" l10n="NEW">High (top price)</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id4641865" role="tablecontent" l10n="NEW">Closing price</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7684560" role="tablecontent" l10n="NEW">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3998840" role="tablecontent" l10n="NEW">Monday</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7675099" role="tablecontent" l10n="NEW">2500</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7806329" role="tablecontent" l10n="NEW">20</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id5589159" role="tablecontent" l10n="NEW">15</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id9936216" role="tablecontent" l10n="NEW">25</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7953123" role="tablecontent" l10n="NEW">17</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id4013794" role="tablecontent" l10n="NEW">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1631824" role="tablecontent" l10n="NEW">Tuesday</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7271645" role="tablecontent" l10n="NEW">3500</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2136295" role="tablecontent" l10n="NEW">32</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id4186223" role="tablecontent" l10n="NEW">22</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1491134" role="tablecontent" l10n="NEW">37</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2873622" role="tablecontent" l10n="NEW">30</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2374034" role="tablecontent" l10n="NEW">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1687063" role="tablecontent" l10n="NEW">Wednesday</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id8982207" role="tablecontent" l10n="NEW">1000</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7074190" role="tablecontent" l10n="NEW">15</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id5452436" role="tablecontent" l10n="NEW">15</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id9527878" role="tablecontent" l10n="NEW">17</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id6342356" role="tablecontent" l10n="NEW">17</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id166936" role="tablecontent" l10n="NEW">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id6826990" role="tablecontent" l10n="NEW">Thursday</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id6897183" role="tablecontent" l10n="NEW">2200</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7003387" role="tablecontent" l10n="NEW">40</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id4897915" role="tablecontent" l10n="NEW">30</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3105868" role="tablecontent" l10n="NEW">47</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3908810" role="tablecontent" l10n="NEW">35</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id9461653" role="tablecontent" l10n="NEW">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id9239173" role="tablecontent" l10n="NEW">Friday</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2656941" role="tablecontent" l10n="NEW">4600</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id1481063" role="tablecontent" l10n="NEW">27</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id7921079" role="tablecontent" l10n="NEW">20</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id636921" role="tablecontent" l10n="NEW">32</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2799157" role="tablecontent" l10n="NEW">31</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+
+ <paragraph xml-lang="en-US" id="par_id3004547" role="paragraph" l10n="NEW">The open, low, high, and closing values of a row build together one data unit in the chart. A stock price data series consists of several rows containing such data units. The column containing the transaction volume builds an optional second data series.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id6401867" role="paragraph" l10n="NEW">Depending on the chosen variant, you do not need all columns.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id18616" role="heading" level="1" l10n="NEW">Stock Chart Variants</paragraph>
+ <paragraph xml-lang="en-US" id="par_id6138492" role="paragraph" l10n="NEW">Choose the <emph>Stock</emph> chart type on the first page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart wizard</link>. Then select one of the four variants.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id4569231" role="heading" level="1" l10n="NEW">Type 1</paragraph>
+ <paragraph xml-lang="en-US" id="par_id291451" role="paragraph" l10n="NEW">Based on<emph> low</emph>
+ <emph>and high </emph>column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3341776" role="paragraph" l10n="NEW">Based on<emph> low, high,</emph> and <emph>close</emph> column Type 1 shows an additional horizontal mark <emph>for</emph> the closing price.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id5947141" role="heading" level="1" l10n="NEW">Type 2</paragraph>
+ <paragraph xml-lang="en-US" id="par_id1911679" role="paragraph" l10n="CHG">Based on <emph>open, low, high</emph>, and <emph>close</emph> column Type 2 generates the traditional "candle stick" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id9364909" role="heading" level="1" l10n="NEW">Type 3</paragraph>
+ <paragraph xml-lang="en-US" id="par_id4473403" role="paragraph" l10n="CHG">Based on <emph>volume, low, high</emph>, and <emph>close</emph> column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.<comment>i80596</comment></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id4313791" role="heading" level="1" l10n="NEW">Type 4</paragraph>
+ <paragraph xml-lang="en-US" id="par_id4331797" role="paragraph" l10n="CHG">Based on all five data columns <emph>volume, open, low, high</emph>, and <emph>close</emph>, Type 4 combines a chart of Type 2 with a column chart for the transaction volume.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id4191717" role="paragraph" l10n="NEW">Because measurement for transaction volume might be "units", a second y axis is introduced in chart Type 3 and Type 4. The price axis is shown on the right side and the volume axis on the left side.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2318796" role="heading" level="1" l10n="NEW">Setting the Data Source</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id399182" role="heading" level="1" 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_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>
+ <paragraph xml-lang="en-US" id="hd_id888698" role="heading" level="1" l10n="NEW">Charts based on Calc or Writer tables</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3394573" role="paragraph" l10n="NEW">You can choose or alter a data range on the second page of the Chart wizard or in the <link href="text/schart/01/wiz_data_range.xhp">Data Range</link> dialog. For fine tuning use the <link href="text/schart/01/wiz_data_series.xhp">Data Series</link> dialog.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id7594225" role="paragraph" l10n="NEW">To specify a data range do one of the following:</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id5081637" role="paragraph" l10n="NEW">Enter the data range in the text box.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id9759514" role="paragraph" l10n="NEW">In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".</paragraph>
+ <paragraph xml-lang="en-US" id="par_id1614429" role="paragraph" l10n="NEW">As long as the syntax is not correct, %PRODUCTNAME shows the text in red.</paragraph>
+ </listitem>
+ </list>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id1589098" role="paragraph" l10n="NEW">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click <emph>Select </emph>
+ <emph>data range</emph> again to add a data range. In the input field of the minimized dialog, click after the entry and type a semicolon. Then drag to select the next range.</paragraph>
+ </listitem>
+ </list>
+ <paragraph xml-lang="en-US" id="par_id8746910" role="paragraph" l10n="NEW">Click one of the options for data series in rows or in columns. </paragraph>
+ <paragraph xml-lang="en-US" id="par_id9636524" role="paragraph" l10n="NEW">Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".<comment>I don't know whether copying a table based chart to draw or impress needs chart data arranged in columns, and I cannot test it, because the clipboard is broken.</comment></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id5675527" role="heading" level="1" l10n="NEW">Fine Tuning the Data Ranges of Table Based Stock Charts</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3486434" role="paragraph" l10n="NEW">You can organize data series and edit the source for parts of single data series on the third page of the Chart wizard or on the page Data Series in the Data Range dialog.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3068636" role="heading" level="1" l10n="NEW">Organize Data Series</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2480849" role="paragraph" l10n="NEW">In the <emph>data series</emph> area on the left side of the dialog, you can organize the data series of the actual chart. A stock chart has at least one data series containing the prices. It might have a second data series for transaction volume.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id4181951" role="paragraph" l10n="CHG">If you have got more than one price data series, use the Up and Down arrow buttons to order them. The order determines the arrangement in the chart. Do the same for volume data series. You cannot switch price and volume data series.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2927335" role="paragraph" l10n="NEW">To remove a data series, select the data series in the list and click <emph>Remove</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2107303" role="paragraph" l10n="NEW">To add a data series, select one of the existing data series and click <emph>Add</emph>. You get an empty entry below the selected one, which has the same type. If you have no price data series or no volume data series, you must first select a range for these series in the <emph>Data Range</emph> dialog.<comment>Regina: The behavior is odd, but I don't know a better solution. Therefore I have not written an issue.</comment></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id4071779" role="heading" level="1" l10n="NEW">Setting Data Ranges</paragraph>
+ <paragraph xml-lang="en-US" id="par_id7844477" role="paragraph" l10n="NEW">In the <emph>Data Ranges</emph> dialog you can set or change the data range of each component of the selected data series.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id6478469" role="paragraph" l10n="NEW">In the upper list you see the role name of the components and the current values. When you have selected a role, you can change the value in the text box below the list. The label shows the selected role.</paragraph><comment>deleted a para, see i80596</comment>
+<paragraph xml-lang="en-US" id="par_id9038972" role="paragraph" l10n="NEW">Enter the range into the text box or click on <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id7985168" role="paragraph" l10n="NEW">Select Open Values, Close Values, High Values, and Low Values in any order. Specify only the ranges for those roles which you need for the chosen variant of the stock chart. The ranges need not be next to each other in the table.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id876186" role="heading" level="1" l10n="NEW">Legend</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3939634" role="paragraph" l10n="NEW">The legend displays the labels from the first row or column or from the special range that you have set in the <emph>Data Series</emph> dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.</paragraph><comment>deleted 3 paras</comment>
+<paragraph xml-lang="en-US" id="par_id2377697" role="paragraph" l10n="NEW">The legend shows the value from the range, which you entered in the <emph>Range for Name</emph> field in the <emph>Data Range</emph> dialog. The default entry is the column header of the closing price column.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2188787" role="paragraph" l10n="NEW">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph>
+ <section id="relatedtopics">
+ <embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
+ <embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
+ <embed href="text/schart/01/wiz_data_range.xhp#wiz_data_range"/>
+ <embed href="text/schart/01/wiz_data_series.xhp#wiz_data_series"/>
+ <embed href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
+ </section>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/main0000.xhp b/helpcontent2/source/text/schart/main0000.xhp
index 651ac2e471..19d9cc6c67 100755
--- a/helpcontent2/source/text/schart/main0000.xhp
+++ b/helpcontent2/source/text/schart/main0000.xhp
@@ -1,9 +1,8 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
+<helpdocument version="1.0">
+
<!--
- ***********************************************************************
+***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
@@ -11,7 +10,7 @@
*
* OpenOffice.org - a multi-platform office productivity suite
*
- * $RCSfile: main0000.xhp,v $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
* $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
@@ -33,72 +32,156 @@
*
************************************************************************
-->
-
-
- <helpdocument version="1.0">
+
+
<meta>
-<topic id="textschartmain0000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Charts in $[officename]</title>
-<filename>/text/schart/main0000.xhp</filename>
-</topic>
-</meta>
-<body>
+ <topic id="textschartmain0000xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" 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_value>HowTos for charts</bookmark_value>
-</bookmark><comment>MW added one entry</comment><paragraph role="heading" id="hd_id3148664" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="chart_main"><link href="text/schart/main0000.xhp" name="Charts in $[officename]">Using Charts in %PRODUCTNAME</link>
+ <bookmark_value>HowTos for charts</bookmark_value>
+</bookmark><comment>MW added one entry</comment>
+<paragraph xml-lang="en-US" id="hd_id3148664" role="heading" level="1" l10n="U" oldref="1"><variable id="chart_main"><link href="text/schart/main0000.xhp" name="Charts in $[officename]">Using Charts in %PRODUCTNAME</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="chart">$[officename] lets you present data graphically in a chart, so that you can visually compare data series and view trends in the data. You can insert charts into spreadsheets, text documents, drawings, and presentations.
+ <paragraph xml-lang="en-US" id="par_id3154685" role="paragraph" l10n="CHG" oldref="2"><variable id="chart">$[officename] lets you present data graphically in a chart, so that you can visually compare data series and view trends in the data. You can insert charts into spreadsheets, text documents, drawings, and presentations.
</variable></paragraph>
-<paragraph role="heading" id="hd_id3153143" xml-lang="en-US" level="2" l10n="CHG" oldref="5">Chart Data</paragraph>
-<paragraph role="paragraph" id="par_id5181432" xml-lang="en-US" l10n="NEW">Charts can be based on the following data:</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id7787102" xml-lang="en-US" l10n="NEW">Spreadsheet values from Calc cell ranges<comment>also Excel...</comment></paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id7929929" xml-lang="en-US" l10n="NEW">Cell values from a Writer table</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id4727011" xml-lang="en-US" l10n="NEW">Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc)</paragraph>
-</listitem>
-</list><comment>command line Insert - (Object -) Chart, moved here from deleted shared/01/04160100.xhp</comment>
+ <paragraph xml-lang="en-US" id="hd_id3153143" role="heading" level="1" l10n="CHG"
+ oldref="5">Chart Data</paragraph>
+ <paragraph xml-lang="en-US" id="par_id5181432" role="paragraph" l10n="NEW">Charts can be based on the following data:</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id7787102" role="paragraph" l10n="NEW">Spreadsheet values from Calc cell ranges<comment>also Excel...</comment></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id7929929" role="paragraph" l10n="NEW">Cell values from a Writer table</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id4727011" role="paragraph" l10n="NEW">Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc)</paragraph>
+ </listitem>
+ </list><comment>command line Insert - (Object -) Chart, moved here from deleted shared/01/04160100.xhp</comment>
<bookmark xml-lang="en-US" branch="hid/SID_INSERT_DIAGRAM" id="bm_id2038889" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertObjectChart" id="bm_id3149551" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SID_DRAW_CHART" id="bm_id6209730" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:DrawChart" id="bm_id3154688" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SID_OPENDLG_CHART" id="bm_id7389470" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:StarChartDialog" id="bm_id3146060" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/HID_INSERT_CHART" id="bm_id3149532" localize="false"/><paragraph role="paragraph" id="par_id76601" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Creates a chart in the current document. To use a range of cells as the data source for your chart, select the cells, and then choose this command.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id5345011" xml-lang="en-US" level="2" l10n="NEW">To insert a chart</paragraph>
-<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
-<embed href="text/schart/01/choose_chart_type.xhp#choose_chart_type"/>
-<paragraph role="heading" id="hd_id5631580" xml-lang="en-US" level="2" l10n="NEW">To edit a chart</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="paragraph" id="par_id7911008" xml-lang="en-US" l10n="NEW">Click a chart to edit the chart object properties:</paragraph>
-<paragraph role="paragraph" id="par_id9844660" xml-lang="en-US" l10n="NEW">size and position on the current page</paragraph>
-<paragraph role="paragraph" id="par_id8039796" xml-lang="en-US" l10n="NEW">alignment, text wrap, outer borders, and more</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id7986693" xml-lang="en-US" l10n="NEW">Double-click a chart to enter the chart edit mode:</paragraph>
-<paragraph role="paragraph" id="par_id2350840" xml-lang="en-US" l10n="NEW">chart data values (for charts with own data)</paragraph>
-<paragraph role="paragraph" id="par_id3776055" xml-lang="en-US" l10n="NEW">chart type, axes, titles, walls, grid, and more</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id8442335" xml-lang="en-US" l10n="NEW">Double-click a chart element in chart edit mode:</paragraph>
-<paragraph role="paragraph" id="par_id4194769" xml-lang="en-US" l10n="NEW">double-click an axis to edit the scale, type, color, and more</paragraph>
-<paragraph role="paragraph" id="par_id8644672" xml-lang="en-US" l10n="NEW">double-click a data point, or a data series in the legend, to edit the graphical values of the data series</paragraph>
-<paragraph role="paragraph" id="par_id6574907" xml-lang="en-US" l10n="NEW">with a data series selected, double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart)</paragraph>
-<paragraph role="paragraph" id="par_id7528916" xml-lang="en-US" l10n="NEW">double-click any other chart element, or click the element and open the Format menu, to edit the properties</paragraph>
-</listitem>
-<listitem>
-<paragraph role="paragraph" id="par_id8420667" xml-lang="en-US" l10n="NEW">Click outside the chart to leave the current edit mode.</paragraph>
-</listitem>
-</list>
-<paragraph role="tip" id="par_id4923856" xml-lang="en-US" l10n="NEW">To print a chart in high quality, you can export the chart to a PDF file and print that file.</paragraph><comment>how to update chart data (drag&amp;drop vs chart data dialog)</comment><embed href="text/shared/guide/chart_title.xhp#chart_title"/>
-<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"/>
-</body>
-</helpdocument>
+<bookmark xml-lang="en-US" branch="hid/HID_INSERT_CHART" id="bm_id3149532" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id76601" role="paragraph" l10n="CHG"><ahelp hid="." visibility="hidden">Creates a chart in the current document. To use a continuous range of cells as the data source for your chart, click inside the cell range, and then choose this command. Alternatively, select some cells and choose this command to create a chart of the selected cells.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id5345011" role="heading" level="1" l10n="NEW">To insert a chart</paragraph>
+ <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="1" l10n="NEW">To edit a chart</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id7911008" role="paragraph" l10n="NEW">Click a chart to edit the object properties:</paragraph>
+ <paragraph xml-lang="en-US" id="par_id9844660" role="paragraph" l10n="NEW">Size and position on the current page.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id8039796" role="paragraph" l10n="NEW">Alignment, text wrap, outer borders, and more.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id7986693" role="paragraph" l10n="NEW">Double-click a chart to enter the chart edit mode:</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2350840" role="paragraph" l10n="NEW">Chart data values (for charts with own data).</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3776055" role="paragraph" l10n="NEW">Chart type, axes, titles, walls, grid, and more.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id8442335" role="paragraph" l10n="NEW">Double-click a chart element in chart edit mode:</paragraph>
+ <paragraph xml-lang="en-US" id="par_id4194769" role="paragraph" l10n="NEW">Double-click an axis to edit the scale, type, color, and more.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id8644672" role="paragraph" l10n="NEW">Double-click a data point, or a data series in the legend, to edit the graphical values of the data series.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id6574907" role="paragraph" l10n="NEW">With a data series selected, double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart).</paragraph>
+ <paragraph xml-lang="en-US" id="par_id7528916" role="paragraph" l10n="NEW">Double-click any other chart element, or click the element and open the Format menu, to edit the properties.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id8420667" role="paragraph" l10n="NEW">Click outside the chart to leave the current edit mode.</paragraph>
+ </listitem>
+ </list>
+ <paragraph xml-lang="en-US" id="par_id4923856" role="tip" l10n="NEW">To print a chart in high quality, you can export the chart to a PDF file and print that file.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200912061033" role="paragraph" l10n="NEW">In chart edit mode, you see the <link href="text/schart/main0202.xhp">Formatting Bar</link> for charts. </paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902080452" role="paragraph" l10n="NEW">You can right-click an element of a chart to open the context menu. The context menu offers many commands to format the selected element.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/.uno:FormatTitle" id="bm_id0810200903431839" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id081020090354489" role="paragraph" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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_id0810200903545095" role="paragraph" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><ahelp hid="." visibility="hidden">Formats the data lables.</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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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_id0810200904362777" role="paragraph" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><ahelp hid="." visibility="hidden">Resets all data points to default format.</ahelp></paragraph><comment>how to update chart data (drag&amp;drop vs chart data dialog)</comment><embed href="text/shared/guide/chart_title.xhp#chart_title"/>
+ <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"/>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/main0202.xhp b/helpcontent2/source/text/schart/main0202.xhp
new file mode 100755
index 0000000000..c2a5ecdf08
--- /dev/null
+++ b/helpcontent2/source/text/schart/main0202.xhp
@@ -0,0 +1,67 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+
+<!--
+***********************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2008 by Sun Microsystems, Inc.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.8 $
+ *
+ * This file is part of OpenOffice.org.
+ *
+ * OpenOffice.org is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License version 3
+ * only, as published by the Free Software Foundation.
+ *
+ * OpenOffice.org is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License version 3 for more details
+ * (a copy is included in the LICENSE file that accompanied this code).
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * version 3 along with OpenOffice.org. If not, see
+ * <http://www.openoffice.org/license.html>
+ * for a copy of the LGPLv3 License.
+ *
+ ************************************************************************
+ -->
+
+
+<meta>
+ <topic id="textschartmain0202xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Formatting Bar</title>
+ <filename>/text/schart/main0202.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="chartformatting">
+ <paragraph xml-lang="en-US" id="hd_id0810200911433792" role="heading" level="1" l10n="NEW"><link href="text/schart/main0202.xhp" name="Formatting Bar">Formatting Bar</link></paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200911433835" role="paragraph" l10n="NEW">The Formatting Bar is shown when a chart is set to edit mode. Double-click a chart to enter edit mode. Click outside the chart to leave edit mode.</paragraph>
+ </section>
+ <paragraph xml-lang="en-US" id="par_id0810200911433878" role="paragraph" l10n="NEW">You can edit the formatting of a chart using the controls and icons on the Formatting Bar.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/.uno:ChartElementSelector" id="bm_id0810200902112648" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id0810200902300436" role="heading" level="2" l10n="NEW">Select Chart Element</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300479" role="paragraph" l10n="NEW"><ahelp hid=".">Select the element from the chart that you want to format. The element gets selected in the chart preview. Click Format Selection to open the properties dialog for the selected element.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id0810200902300555" role="heading" level="2" l10n="NEW">Format Selection</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300539" role="paragraph" l10n="NEW"><ahelp hid=".">Opens the properties dialog for the selected element.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id0810200902300545" role="heading" level="2" l10n="NEW">Chart Type</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300594" role="paragraph" l10n="NEW"><ahelp hid=".">Opens the Chart Type dialog.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id0810200902300537" role="heading" level="2" l10n="NEW">Chart Data Table</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300699" role="paragraph" l10n="NEW"><ahelp hid=".">Opens the Data Table dialog where you can edit the chart data.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id0810200902300672" role="heading" level="2" l10n="NEW">Horizontal Grid On/Off</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300630" role="paragraph" l10n="NEW"><ahelp hid=".">The Horizontal Grid On/Off icon on the Formatting bar toggles the visibility of the grid display for the X axis. Note: This only works if the Minor grid check boxes in Insert - Grids are cleared.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id0810200902300738" role="heading" level="2" l10n="NEW">Legend On/Off</paragraph>
+ <paragraph xml-lang="en-US" id="par_id081020090230076" role="paragraph" l10n="NEW"><ahelp hid=".">To show or hide a legend, click Legend On/Off on the Formatting bar.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id0810200902300785" role="heading" level="2" l10n="NEW">Scale Text</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300784" role="paragraph" l10n="NEW"><ahelp hid=".">Rescales the text in the chart when you change the size of the chart.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id081020090230087" role="heading" level="2" l10n="NEW">Automatic Layout</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0810200902300834" role="paragraph" l10n="NEW"><ahelp hid=".">Moves all chart elements to their default positions inside the current chart. This function does not alter the chart type or any other attributes other than the position of elements.</ahelp></paragraph>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/schart/makefile.mk b/helpcontent2/source/text/schart/makefile.mk
index 463e6311b6..43822b4c47 100644
--- a/helpcontent2/source/text/schart/makefile.mk
+++ b/helpcontent2/source/text/schart/makefile.mk
@@ -49,6 +49,7 @@ MODULE = schart
# this list matches the *.xhp files to process
XHPFILES = \
main0000.xhp \
+ main0202.xhp \
main0503.xhp
# --- Targets ------------------------------------------------------
diff --git a/helpcontent2/util/scalc/makefile.mk b/helpcontent2/util/scalc/makefile.mk
index c5639ba9a4..61bbcef62f 100644
--- a/helpcontent2/util/scalc/makefile.mk
+++ b/helpcontent2/util/scalc/makefile.mk
@@ -1309,6 +1309,7 @@ LINKLINKFILES= \
text$/schart$/02$/02020000.xhp \
text$/schart$/04$/01020000.xhp \
text$/schart$/main0000.xhp \
+ text$/schart$/main0202.xhp \
text$/schart$/main0503.xhp \
diff --git a/helpcontent2/util/schart/makefile.mk b/helpcontent2/util/schart/makefile.mk
index 7ae0d0c373..c40f0ebb83 100644
--- a/helpcontent2/util/schart/makefile.mk
+++ b/helpcontent2/util/schart/makefile.mk
@@ -998,6 +998,7 @@ LINKLINKFILES= \
text$/schart$/02$/02020000.xhp \
text$/schart$/04$/01020000.xhp \
text$/schart$/main0000.xhp \
+ text$/schart$/main0202.xhp \
text$/schart$/main0503.xhp \
diff --git a/helpcontent2/util/sdraw/makefile.mk b/helpcontent2/util/sdraw/makefile.mk
index 868a878f5e..18caa9f7f6 100644
--- a/helpcontent2/util/sdraw/makefile.mk
+++ b/helpcontent2/util/sdraw/makefile.mk
@@ -1231,6 +1231,7 @@ LINKLINKFILES= \
text$/schart$/02$/02020000.xhp \
text$/schart$/04$/01020000.xhp \
text$/schart$/main0000.xhp \
+ text$/schart$/main0202.xhp \
text$/schart$/main0503.xhp \
diff --git a/helpcontent2/util/simpress/makefile.mk b/helpcontent2/util/simpress/makefile.mk
index 74d5e8850c..a6ab94b35d 100644
--- a/helpcontent2/util/simpress/makefile.mk
+++ b/helpcontent2/util/simpress/makefile.mk
@@ -1233,6 +1233,7 @@ LINKLINKFILES= \
text$/schart$/02$/02020000.xhp \
text$/schart$/04$/01020000.xhp \
text$/schart$/main0000.xhp \
+ text$/schart$/main0202.xhp \
text$/schart$/main0503.xhp \
diff --git a/helpcontent2/util/swriter/makefile.mk b/helpcontent2/util/swriter/makefile.mk
index 8b41362846..b54a27fb0f 100644
--- a/helpcontent2/util/swriter/makefile.mk
+++ b/helpcontent2/util/swriter/makefile.mk
@@ -1389,6 +1389,7 @@ LINKLINKFILES= \
text$/schart$/02$/02020000.xhp \
text$/schart$/04$/01020000.xhp \
text$/schart$/main0000.xhp \
+ text$/schart$/main0202.xhp \
text$/schart$/main0503.xhp \