source/text/schart/00/00000004.xhp | 34 +- source/text/schart/01/choose_chart_type.xhp | 9 source/text/schart/01/type_area.xhp | 9 source/text/schart/01/type_bubble.xhp | 12 source/text/schart/01/type_column_bar.xhp | 9 source/text/schart/01/type_column_line.xhp | 113 +++--- source/text/schart/01/type_line.xhp | 9 source/text/schart/01/type_net.xhp | 9 source/text/schart/01/type_ofpie.xhp | 11 source/text/schart/01/type_pie.xhp | 11 source/text/schart/01/type_stock.xhp | 467 +++++++++++++++------------- source/text/schart/01/type_xy.xhp | 12 source/text/schart/main0503.xhp | 17 - 13 files changed, 365 insertions(+), 357 deletions(-)
New commits: commit 2daf496b40b300ac162c7a3ac0f93567a67bd102 Author: Olivier Hallot <olivier.hal...@libreoffice.org> AuthorDate: Fri May 16 09:29:02 2025 -0300 Commit: Olivier Hallot <olivier.hal...@libreoffice.org> CommitDate: Fri May 16 14:48:04 2025 +0200 Revisit Column and Line charts Help pages + More refactor to spare translations Change-Id: I980fbc6f6ea9e205937c4ac773147a5682bb13c8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/185414 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org> diff --git a/source/text/schart/00/00000004.xhp b/source/text/schart/00/00000004.xhp index 18b2e4fdb8..2319f2f6a9 100644 --- a/source/text/schart/00/00000004.xhp +++ b/source/text/schart/00/00000004.xhp @@ -204,24 +204,26 @@ </tablecell> </tablerow> </table> - -</section> -<section id="wiz_icon"> - <table id="tab_id721525135741575"> - <tablerow> - <tablecell> - <paragraph role="paragraph" id="par_id441525135741575" localize="false"> - <image id="img_id3157322" src="cmd/lc_drawchart.svg" width="1cm" height="1cm"><alt id="alt_id3159322">Icon Insert Chart</alt></image> </paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id161525135741575" role="paragraph"><emph>Insert Chart</emph></paragraph> - </tablecell> - </tablerow> - </table> </section> <section id="wiz"> - <paragraph role="paragraph" id="par_id9631641">Choose <emph>Insert - Chart...</emph></paragraph> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type...</menuitem></paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type...</menuitem></paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <section id="wiz_icon"> + <table id="tab_id721525135741575"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id441525135741575" localize="false"> + <image id="img_id3157322" src="cmd/lc_drawchart.svg" width="1cm" height="1cm"><alt id="alt_id3159322">Icon Insert Chart</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id161525135741575" role="paragraph"><emph>Insert Chart</emph></paragraph> + </tablecell> + </tablerow> + </table> + </section> </section> <section id="wiz_ranges"> <paragraph role="paragraph" id="par_id2985320">Choose <emph>Insert - Chart...</emph></paragraph> diff --git a/source/text/schart/01/choose_chart_type.xhp b/source/text/schart/01/choose_chart_type.xhp index 74b50f8993..708370366b 100644 --- a/source/text/schart/01/choose_chart_type.xhp +++ b/source/text/schart/01/choose_chart_type.xhp @@ -28,8 +28,7 @@ </meta> <body> <bookmark branch="hid/modules/schart/ui/charttypedialog/@@nowidget@@" id="bm_id171747242819474" localize="false"/> -<h1 id="hd_id9072237"><variable id="choose_chart_type"><link href="text/schart/01/choose_chart_type.xhp">Choosing a Chart Type</link> - </variable></h1> +<h1 id="hd_id9072237"><variable id="choose_chart_type"><link href="text/schart/01/choose_chart_type.xhp">Choosing a Chart Type</link></variable></h1> <paragraph id="par_id7085787" role="paragraph">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"/> @@ -82,7 +81,7 @@ <paragraph id="par_id3946653" role="tablecontent"><image id="Graphic4" src="chart2/res/valueaxisdirectpoints_52x60.svg" width="0.6252in" height="0.5417in"><alt id="alt_">Icon XY Chart</alt></image></paragraph> </tablecell> <tablecell> - <paragraph id="par_id5882747" localize="false" role="tablecontent"><embedvar href="text/schart/01/type_xy.xhp#type_xy" markup="ignore"/><link href="text/schart/01/type_xy.xhp">XY (scatter)</link></paragraph> + <paragraph id="par_id5882747" localize="false" role="tablecontent"><embedvar href="text/schart/01/type_xy.xhp#type_xy" markup="ignore"/></paragraph> </tablecell> </tablerow> <tablerow> @@ -106,7 +105,7 @@ <paragraph id="par_id1846369" role="tablecontent"><image id="Graphic6" src="chart2/res/stock_52x60.svg" width="0.6252in" height="0.5417in"><alt id="alt_">Icon Stock Chart</alt></image></paragraph> </tablecell> <tablecell> - <paragraph id="par_id1680654" role="tablecontent"><link href="text/schart/01/type_stock.xhp">Stock</link></paragraph> + <paragraph id="par_id1680654" localize="false" role="tablecontent"><embedvar href="text/schart/01/type_stock.xhp#type_stock" markup="ignore"/></paragraph> </tablecell> </tablerow> <tablerow> @@ -114,7 +113,7 @@ <paragraph id="par_id1592150" role="tablecontent"><image id="Graphic7" src="chart2/res/columnline_52x60.svg" width="0.6252in" height="0.5417in"><alt id="alt_">Icon Column and Line Chart</alt></image></paragraph> </tablecell> <tablecell> - <paragraph id="par_id3308816" role="tablecontent"><link href="text/schart/01/type_column_line.xhp">Column and Line</link></paragraph> + <paragraph id="par_id3308816" localize="false" role="tablecontent"><embedvar href="text/schart/01/type_column_line.xhp#type_column_line" markup="ignore"/></paragraph> </tablecell> </tablerow> </table> diff --git a/source/text/schart/01/type_area.xhp b/source/text/schart/01/type_area.xhp index d94b0a5d48..e9604af370 100644 --- a/source/text/schart/01/type_area.xhp +++ b/source/text/schart/01/type_area.xhp @@ -31,13 +31,8 @@ </variable></h1> <paragraph role="paragraph" id="par_id916776">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/shared/00/00000004.xhp#from_menu_bar"/> -<paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Area</menuitem></paragraph> -<embed href="text/shared/00/00000004.xhp#from_tabUI"/> -<paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Area</menuitem></paragraph> -<embed href="text/shared/00/00000004.xhp#from_toolbars"/> -<embed href="text/schart/00/00000004.xhp#wiz_icon"/> -<paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Area</menuitem></paragraph> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Area</emph>.</paragraph> </section> <h2 id="hd_id961943">Area</h2> <paragraph role="paragraph" id="par_id631733">An area chart shows values as points on the y axis. The x axis shows categories. The y values of each data series are connected by a line. The area between each two lines is filled with a color. The area chart's focus is to emphasize the changes from one category to the next.</paragraph> diff --git a/source/text/schart/01/type_bubble.xhp b/source/text/schart/01/type_bubble.xhp index 03ad9ccd01..5bc87ce448 100644 --- a/source/text/schart/01/type_bubble.xhp +++ b/source/text/schart/01/type_bubble.xhp @@ -30,17 +30,11 @@ <bookmark branch="index" id="bm_id2183975"><bookmark_value>bubble charts</bookmark_value> <bookmark_value>chart types;bubble</bookmark_value> </bookmark> -<h1 id="hd_id1970722"><variable id="type_bubble"><link href="text/schart/01/type_bubble.xhp">Chart Type Bubble</link> - </variable></h1> +<h1 id="hd_id1970722"><variable id="type_bubble"><link href="text/schart/01/type_bubble.xhp">Chart Type Bubble</link></variable></h1> <paragraph id="par_id40589" role="paragraph">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/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Bubble</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_tabUI"/> - <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Bubble</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_toolbars"/> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> - <paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Bubble</menuitem></paragraph> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Bubble</emph>.</paragraph> </section> <h2 id="hd_id0526200904491284">Bubble</h2> <paragraph id="par_id0526200904491222" role="paragraph">A bubble chart shows the relations of three variables. Two variables are used for the position on the X-axis and Y-axis, while the third variable is shown as the relative size of each bubble.</paragraph> diff --git a/source/text/schart/01/type_column_bar.xhp b/source/text/schart/01/type_column_bar.xhp index 908c6b003a..eaf67e2ca5 100644 --- a/source/text/schart/01/type_column_bar.xhp +++ b/source/text/schart/01/type_column_bar.xhp @@ -35,13 +35,8 @@ </variable></h1> <paragraph role="paragraph" id="par_id3430585">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/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Column (or Bar)</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_tabUI"/> - <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Column (or Bar)</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_toolbars"/> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> - <paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Column (or Bar)</menuitem></paragraph> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Column or Bar</emph>.</paragraph> </section> <h2 id="hd_id9826960">Column</h2> <paragraph role="paragraph" id="par_id2244026">This type shows a bar chart or bar graph with vertical bars. The height of each bar is proportional to its value. The x axis shows categories. The y axis shows the value for each category.</paragraph> diff --git a/source/text/schart/01/type_column_line.xhp b/source/text/schart/01/type_column_line.xhp index 8371add889..0364aa4568 100644 --- a/source/text/schart/01/type_column_line.xhp +++ b/source/text/schart/01/type_column_line.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,120 +16,136 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textschart01type_column_linexhp" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Chart Type Column and Line </title> +<title id="tit">Chart Type Column and Line </title> <filename>/text/schart/01/type_column_line.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id5976744"><bookmark_value>column and line charts</bookmark_value> +<bookmark branch="index" id="bm_id5976744"><bookmark_value>column and line charts</bookmark_value> <bookmark_value>chart types;column and line</bookmark_value> <bookmark_value>combination charts</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id8596453" xml-lang="en-US" level="1"><variable id="type_column_line"><link href="text/schart/01/type_column_line.xhp">Chart Type Column and Line</link> -</variable></paragraph> -<paragraph role="paragraph" id="par_id4818567" xml-lang="en-US">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> +<h1 id="hd_id8596453"><variable id="type_column_line"><link href="text/schart/01/type_column_line.xhp">Chart Type Column and Line</link> +</variable></h1> +<paragraph role="paragraph" id="par_id4818567">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"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Column and Line</emph>.</paragraph> </section> <h2 id="hd_id2451551">Column and Line</h2> -<paragraph role="paragraph" id="par_id3101901" xml-lang="en-US">A Column and Line chart is a combination of a <link href="text/schart/01/type_column_bar.xhp">Column chart</link> with a <link href="text/schart/01/type_line.xhp">Line chart</link>.</paragraph> -<paragraph role="paragraph" id="par_id7910397" xml-lang="en-US">Select one of the variants</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="paragraph" id="par_id5244300" xml-lang="en-US">Columns and Lines. The rectangles of the column data series are drawn side by side so that you can easily compare their values.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id7163609" xml-lang="en-US">Stacked Columns and Lines. The rectangles of the column data series are drawn stacked above each other, so that the height of a column visualizes the sum of the data values.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id1842097" xml-lang="en-US">You can insert a second y-axis with <link href="text/schart/01/04040000.xhp">Insert - Axes</link> after you finish the wizard.</paragraph> +<paragraph role="paragraph" id="par_id3101901">A Column and Line chart is a combination of a <link href="text/schart/01/type_column_bar.xhp">Column chart</link> with a <link href="text/schart/01/type_line.xhp">Line chart</link>.</paragraph> +<h3 id="hd_id81747397775672">Columns and Lines</h3> +<paragraph role="paragraph" id="par_id5244300">The rectangles of the column data series are drawn side by side so that you can easily compare their values.</paragraph> +<table id="tab_id251747397797158"> + <tablerow> + <tablecell> + <paragraph id="par_id831747397797160" role="paragraph"><image src="chart2/res/columnline_52x60.svg" id="img_id161747397797163" width="0.6252in" height="0.5417in"><alt id="alt_id471747397797165">Icon Columns and Lines</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id861747397797169" role="paragraph">Columns and Lines</paragraph> + </tablecell> + </tablerow> +</table> +<h3 id="hd_id441747397937219">Stacked Columns and Lines</h3> +<paragraph role="paragraph" id="par_id7163609">The rectangles of the column data series are drawn stacked above each other, so that the height of a column visualizes the sum of the data values.</paragraph> +<table id="tab_id311747397961281"> + <tablerow> + <tablecell> + <paragraph id="par_id191747397961284" role="paragraph"><image src="chart2/res/columnstackline_52x60.svg" id="img_id431747397961286" width="0.6252in" height="0.5417in"><alt id="alt_id961747397961289">Icon Stacked Columns and Lines</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id681747397961294" role="paragraph">Stacked Columns and Lines</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph role="paragraph" id="par_id1842097">You can insert a second y-axis with <link href="text/schart/01/04040000.xhp">Insert - Axes</link> after you finish the wizard.</paragraph> <h2 id="hd_id8297677">To specify a data range</h2> -<paragraph role="paragraph" id="par_id8871120" xml-lang="en-US">The leftmost columns (or the top rows) of the selected data range provide the data that are shown as Columns objects. The other columns or rows of the data range provide the data for the Lines objects. You can change this assignment in the <emph>Data Series</emph> dialog.</paragraph> +<paragraph role="paragraph" id="par_id8871120">The leftmost columns (or the top rows) of the selected data range provide the data that are shown as Columns objects. The other columns or rows of the data range provide the data for the Lines objects. You can change this assignment in the <emph>Data Series</emph> dialog.</paragraph> <list type="ordered"> <listitem> -<paragraph role="paragraph" id="par_id2952055" xml-lang="en-US">Select the data range.</paragraph> +<paragraph role="paragraph" id="par_id2952055">Select the data range.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id594500" xml-lang="en-US">Click one of the options for data series in rows or in columns.</paragraph> +<paragraph role="paragraph" id="par_id594500">Click one of the options for data series in rows or in columns.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id1944944" xml-lang="en-US">Check whether the data range has labels in the first row or in the first column or both.</paragraph> +<paragraph role="paragraph" id="par_id1944944">Check whether the data range has labels in the first row or in the first column or both.</paragraph> </listitem> </list> <h2 id="hd_id6667683">Organizing data series</h2> -<paragraph role="paragraph" id="par_id7616809" xml-lang="en-US">In the Data Series list box you see a list of all data series in the current chart.</paragraph> -<paragraph role="paragraph" id="par_id9770195" xml-lang="en-US">The column data series are positioned at the top of the list, the line data series at the bottom of the list.</paragraph> +<paragraph role="paragraph" id="par_id7616809">In the Data Series list box you see a list of all data series in the current chart.</paragraph> +<paragraph role="paragraph" id="par_id9770195">The column data series are positioned at the top of the list, the line data series at the bottom of the list.</paragraph> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id1446272" xml-lang="en-US">To organize the data series, select an entry in the list.</paragraph> +<paragraph role="paragraph" id="par_id1446272">To organize the data series, select an entry in the list.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id3779717" xml-lang="en-US">Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry.</paragraph> +<paragraph role="paragraph" id="par_id3779717">Click Add to add another data series below the selected entry. The new data series has the same type as the selected entry.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id5056611" xml-lang="en-US">Click Remove to remove the selected entry from the Data Series list.</paragraph> +<paragraph role="paragraph" id="par_id5056611">Click Remove to remove the selected entry from the Data Series list.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id7786492" xml-lang="en-US">Use the Up and Down arrow buttons to move the selected entry in the list up or down. This way you can convert a Column data series to a List data series and back. This does not change the order in the data source table, but changes only the arrangement in the chart.</paragraph> +<paragraph role="paragraph" id="par_id7786492">Use the Up and Down arrow buttons to move the selected entry in the list up or down. This way you can convert a Column data series to a List data series and back. This does not change the order in the data source table, but changes only the arrangement in the chart.</paragraph> </listitem> </list> <h2 id="hd_id265816">Editing data series</h2> <list type="ordered"> <listitem> -<paragraph role="paragraph" id="par_id6768700" xml-lang="en-US">Click an entry in the list to view and edit the properties for that entry.</paragraph> -<paragraph role="paragraph" id="par_id1924497" xml-lang="en-US">In the Data Ranges list box you see the role names and cell ranges of the data series components. </paragraph> +<paragraph role="paragraph" id="par_id6768700">Click an entry in the list to view and edit the properties for that entry.</paragraph> +<paragraph role="paragraph" id="par_id1924497">In the Data Ranges list box you see the role names and cell ranges of the data series components. </paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id5081942" xml-lang="en-US">Click an entry, then edit the contents in the text box below. </paragraph> -<paragraph role="paragraph" id="par_id2958464" xml-lang="en-US">The label next to the text box states the currently selected role. </paragraph> +<paragraph role="paragraph" id="par_id5081942">Click an entry, then edit the contents in the text box below. </paragraph> +<paragraph role="paragraph" id="par_id2958464">The label next to the text box states the currently selected role. </paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id883816" xml-lang="en-US">Enter the range or click <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph> +<paragraph role="paragraph" id="par_id883816">Enter the range or click <emph>Select data range</emph> to minimize the dialog and select the range with the mouse.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id5091708" xml-lang="en-US">The range for a data role, like Y-Values, must not include a label cell.</paragraph> +<paragraph role="paragraph" id="par_id5091708">The range for a data role, like Y-Values, must not include a label cell.</paragraph> <h2 id="hd_id974456">Editing categories or data labels</h2> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id2767113" xml-lang="en-US">Enter or select a cell range that will be used as text for categories or data labels. </paragraph> +<paragraph role="paragraph" id="par_id2767113">Enter or select a cell range that will be used as text for categories or data labels. </paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id301828" xml-lang="en-US">The values in the Categories range will be shown as labels on the x axis.</paragraph> +<paragraph role="paragraph" id="par_id301828">The values in the Categories range will be shown as labels on the x axis.</paragraph> <h2 id="hd_id8996246">Inserting chart elements</h2> -<paragraph role="paragraph" id="par_id5729544" xml-lang="en-US">Use the Chart Elements page of the Chart Wizard to insert any of the following elements:</paragraph> +<paragraph role="paragraph" id="par_id5729544">Use the Chart Elements page of the Chart Wizard to insert any of the following elements:</paragraph> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id2932828" xml-lang="en-US">Chart titles</paragraph> +<paragraph role="paragraph" id="par_id2932828">Chart titles</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id9449446" xml-lang="en-US">Legend</paragraph> +<paragraph role="paragraph" id="par_id9449446">Legend</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id8122196" xml-lang="en-US">Visible grid lines</paragraph> +<paragraph role="paragraph" id="par_id8122196">Visible grid lines</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id9909665" xml-lang="en-US">For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements:</paragraph> +<paragraph role="paragraph" id="par_id9909665">For additional elements use the Insert menu of the chart in edit mode. There you can define the following elements:</paragraph> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id9141819" xml-lang="en-US">Secondary axes</paragraph> +<paragraph role="paragraph" id="par_id9141819">Secondary axes</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id6354869" xml-lang="en-US">Minor grids</paragraph> +<paragraph role="paragraph" id="par_id6354869">Minor grids</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id2685323" xml-lang="en-US">Data labels</paragraph> +<paragraph role="paragraph" id="par_id2685323">Data labels</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id6042664" xml-lang="en-US">Statistics, for example mean values, y error bars and trend lines</paragraph> +<paragraph role="paragraph" id="par_id6042664">Statistics, for example mean values, y error bars and trend lines</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id7889950" xml-lang="en-US">To set different data labels for each data series, use the properties dialog of the data series.</paragraph> +<paragraph role="paragraph" id="par_id7889950">To set different data labels for each data series, use the properties dialog of the data series.</paragraph> <section id="relatedtopics"> +<paragraph role="paragraph" id="par_id731747249615264" localize="false"><embedvar href="text/schart/01/choose_chart_type.xhp#choose_chart_type" markup="ignore"/></paragraph> <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"/> diff --git a/source/text/schart/01/type_line.xhp b/source/text/schart/01/type_line.xhp index dc1193da66..8704758227 100644 --- a/source/text/schart/01/type_line.xhp +++ b/source/text/schart/01/type_line.xhp @@ -34,13 +34,8 @@ </variable></h1> <paragraph role="paragraph" id="par_id389721">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/shared/00/00000004.xhp#from_menu_bar"/> -<paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Line</menuitem></paragraph> -<embed href="text/shared/00/00000004.xhp#from_tabUI"/> -<paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Line</menuitem></paragraph> -<embed href="text/shared/00/00000004.xhp#from_toolbars"/> -<embed href="text/schart/00/00000004.xhp#wiz_icon"/> -<paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Line</menuitem></paragraph> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Line</emph>.</paragraph> </section> <h2 id="hd_id9826349">Line</h2> <paragraph role="paragraph" id="par_id2334665">A line chart shows values as points on the y axis. The x axis shows categories. The y values of each data series can be connected by a line.</paragraph> diff --git a/source/text/schart/01/type_net.xhp b/source/text/schart/01/type_net.xhp index 5d80bb82dc..14a6465f92 100644 --- a/source/text/schart/01/type_net.xhp +++ b/source/text/schart/01/type_net.xhp @@ -35,13 +35,8 @@ </variable></h1> <paragraph role="paragraph" id="par_id40589">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/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Net</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_tabUI"/> - <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Net</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_toolbars"/> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> - <paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Net</menuitem></paragraph> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Net</emph>.</paragraph> </section> <h2 id="hd_id1391338">Net</h2> <paragraph role="paragraph" id="par_id7812433">A Net (or radar) chart displays data values as points connected by some lines, in a grid net that resembles a spider net or a radar tube display. Net charts are a useful way to display multivariate observations with an arbitrary number of variables.</paragraph> diff --git a/source/text/schart/01/type_ofpie.xhp b/source/text/schart/01/type_ofpie.xhp index 697f8e18af..9c9b6cac93 100644 --- a/source/text/schart/01/type_ofpie.xhp +++ b/source/text/schart/01/type_ofpie.xhp @@ -25,14 +25,9 @@ <paragraph id="par_id101747245869763" role="paragraph"></paragraph> </section> <section id="howtoget"> - <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Of-Pie</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_tabUI"/> - <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Of-Pie</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_toolbars"/> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> - <paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Of-Pie</menuitem></paragraph> - </section> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Of-Pie</emph>.</paragraph> +</section> <h2 id="hd_id5799432">Of-Pie</h2> <h3 id="hd_id331747246961706">Bar-of-pie</h3> <paragraph role="paragraph" id="par_id471715871882381"> diff --git a/source/text/schart/01/type_pie.xhp b/source/text/schart/01/type_pie.xhp index 95eff33d54..079cfa2122 100644 --- a/source/text/schart/01/type_pie.xhp +++ b/source/text/schart/01/type_pie.xhp @@ -36,14 +36,9 @@ </variable></h1> <paragraph id="par_id245979" role="paragraph">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/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - Pie</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_tabUI"/> - <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - Pie</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_toolbars"/> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> - <paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - Pie</menuitem></paragraph> - </section> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Pie</emph>.</paragraph> +</section> <h2 id="hd_id5799432">Pie Charts</h2> <paragraph id="par_id6549272" role="paragraph">A pie chart shows values as circular sectors of the total circle. The length of the arc, or the area of each sector, is proportional to its value.</paragraph> <h3 id="hd_id481747251791317">Pie</h3> diff --git a/source/text/schart/01/type_stock.xhp b/source/text/schart/01/type_stock.xhp index 2f24a96a37..dc71380d01 100644 --- a/source/text/schart/01/type_stock.xhp +++ b/source/text/schart/01/type_stock.xhp @@ -25,241 +25,282 @@ </topic> </meta> <body> -<bookmark 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> -<h1 id="hd_id966216"><variable id="type_stock"><link href="text/schart/01/type_stock.xhp">Chart Type Stock</link> -</variable></h1> - <paragraph id="par_id3516953" role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp"><emph>Chart Wizard</emph></link> you can choose a chart type.</paragraph> - <section id="howtoget"> - <embed href="text/schart/00/00000004.xhp#wiz"/> - </section> - <h2 id="hd_id5268410">Stock</h2> - <paragraph id="par_id61342" role="paragraph">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 id="par_id2131412" role="paragraph">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"> + <bookmark 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> + <h1 id="hd_id966216"><variable id="type_stock"><link href="text/schart/01/type_stock.xhp">Chart Type Stock</link></variable></h1> + <paragraph id="par_id3516953" role="paragraph">On the first page of the <link href="text/schart/01/wiz_chart_type.xhp"><emph>Chart Wizard</emph></link> you can choose a chart type.</paragraph> + <section id="howtoget"> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>Stock</emph>.</paragraph> +</section> + <h2 id="hd_id5268410">Stock Charts</h2> + <paragraph id="par_id61342" role="paragraph">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 id="par_id2131412" role="paragraph">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 id="par_id1022064" localize="false" role="tablehead">A</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1924192" localize="false" role="tablehead">B</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3258156" localize="false" role="tablehead">C</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3161412" localize="false" role="tablehead">D</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id5619373" localize="false" role="tablehead">E</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id6474501" localize="false" role="tablehead">F</paragraph> - </tablecell> + <tablecell></tablecell> + <tablecell> + <paragraph id="par_id1022064" localize="false" role="tablehead">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1924192" localize="false" role="tablehead">B</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3258156" localize="false" role="tablehead">C</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3161412" localize="false" role="tablehead">D</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id5619373" localize="false" role="tablehead">E</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id6474501" localize="false" role="tablehead">F</paragraph> + </tablecell> </tablerow> <tablerow> - <tablecell> - <paragraph id="par_id7411725" localize="false" role="tablehead">1</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph id="par_id1933957" role="tablecontent">Transaction volume</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1274452" role="tablecontent">Opening price</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id5044404" role="tablecontent">Low (bottom price)</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3892635" role="tablecontent">High (top price)</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id4641865" role="tablecontent">Closing price</paragraph> - </tablecell> + <tablecell> + <paragraph id="par_id7411725" localize="false" role="tablehead">1</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1933957" role="tablecontent">Transaction volume</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1274452" role="tablecontent">Opening price</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id5044404" role="tablecontent">Low (bottom price)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3892635" role="tablecontent">High (top price)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id4641865" role="tablecontent">Closing price</paragraph> + </tablecell> </tablerow> <tablerow> - <tablecell> - <paragraph id="par_id7684560" localize="false" role="tablehead">2</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3998840" role="tablecontent">Monday</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7675099" localize="false" role="tablecontent">2500</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7806329" localize="false" role="tablecontent">20</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id5589159" localize="false" role="tablecontent">15</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id9936216" localize="false" role="tablecontent">25</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7953123" localize="false" role="tablecontent">17</paragraph> - </tablecell> + <tablecell> + <paragraph id="par_id7684560" localize="false" role="tablehead">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3998840" role="tablecontent">Monday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7675099" localize="false" role="tablecontent">2500</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7806329" localize="false" role="tablecontent">20</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id5589159" localize="false" role="tablecontent">15</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id9936216" localize="false" role="tablecontent">25</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7953123" localize="false" role="tablecontent">17</paragraph> + </tablecell> </tablerow> <tablerow> - <tablecell> - <paragraph id="par_id4013794" localize="false" role="tablehead">3</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1631824" role="tablecontent">Tuesday</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7271645" localize="false" role="tablecontent">3500</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2136295" localize="false" role="tablecontent">32</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id4186223" localize="false" role="tablecontent">22</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1491134" localize="false" role="tablecontent">37</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2873622" localize="false" role="tablecontent">30</paragraph> - </tablecell> + <tablecell> + <paragraph id="par_id4013794" localize="false" role="tablehead">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1631824" role="tablecontent">Tuesday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7271645" localize="false" role="tablecontent">3500</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2136295" localize="false" role="tablecontent">32</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id4186223" localize="false" role="tablecontent">22</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1491134" localize="false" role="tablecontent">37</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2873622" localize="false" role="tablecontent">30</paragraph> + </tablecell> </tablerow> <tablerow> - <tablecell> - <paragraph id="par_id2374034" localize="false" role="tablehead">4</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1687063" role="tablecontent">Wednesday</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id8982207" localize="false" role="tablecontent">1000</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7074190" localize="false" role="tablecontent">15</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id5452436" localize="false" role="tablecontent">15</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id9527878" localize="false" role="tablecontent">17</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id6342356" localize="false" role="tablecontent">17</paragraph> - </tablecell> + <tablecell> + <paragraph id="par_id2374034" localize="false" role="tablehead">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1687063" role="tablecontent">Wednesday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id8982207" localize="false" role="tablecontent">1000</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7074190" localize="false" role="tablecontent">15</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id5452436" localize="false" role="tablecontent">15</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id9527878" localize="false" role="tablecontent">17</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id6342356" localize="false" role="tablecontent">17</paragraph> + </tablecell> </tablerow> <tablerow> - <tablecell> - <paragraph id="par_id166936" localize="false" role="tablehead">5</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id6826990" role="tablecontent">Thursday</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id6897183" localize="false" role="tablecontent">2200</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7003387" localize="false" role="tablecontent">40</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id4897915" localize="false" role="tablecontent">30</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3105868" localize="false" role="tablecontent">47</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3908810" localize="false" role="tablecontent">35</paragraph> - </tablecell> + <tablecell> + <paragraph id="par_id166936" localize="false" role="tablehead">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id6826990" role="tablecontent">Thursday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id6897183" localize="false" role="tablecontent">2200</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7003387" localize="false" role="tablecontent">40</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id4897915" localize="false" role="tablecontent">30</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3105868" localize="false" role="tablecontent">47</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3908810" localize="false" role="tablecontent">35</paragraph> + </tablecell> </tablerow> <tablerow> - <tablecell> - <paragraph id="par_id9461653" localize="false" role="tablehead">6</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id9239173" role="tablecontent">Friday</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2656941" localize="false" role="tablecontent">4600</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1481063" localize="false" role="tablecontent">27</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id7921079" localize="false" role="tablecontent">20</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id636921" localize="false" role="tablecontent">32</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2799157" localize="false" role="tablecontent">31</paragraph> - </tablecell> + <tablecell> + <paragraph id="par_id9461653" localize="false" role="tablehead">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id9239173" role="tablecontent">Friday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2656941" localize="false" role="tablecontent">4600</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1481063" localize="false" role="tablecontent">27</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id7921079" localize="false" role="tablecontent">20</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id636921" localize="false" role="tablecontent">32</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2799157" localize="false" role="tablecontent">31</paragraph> + </tablecell> </tablerow> - </table> + </table> - <paragraph id="par_id3004547" role="paragraph">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 id="par_id6401867" role="paragraph">Depending on the chosen variant, you do not need all columns.</paragraph> - <h2 id="hd_id18616">Stock Chart Variants</h2> - <paragraph id="par_id6138492" role="paragraph">Choose the <emph>Stock</emph> chart type on the first page of the <link href="text/schart/01/wiz_chart_type.xhp"><emph>Chart Wizard</emph></link>. Then select one of the four variants.</paragraph> - <h2 id="hd_id4569231">Type 1</h2> - <paragraph id="par_id291451" role="paragraph">Based on <emph>low</emph> and <emph>high</emph> column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line.</paragraph> - <paragraph id="par_id3341776" role="paragraph">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> - <h2 id="hd_id5947141">Type 2</h2> - <paragraph id="par_id1911679" role="paragraph">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> - <h2 id="hd_id9364909">Type 3</h2> - <paragraph id="par_id4473403" role="paragraph">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> - <h2 id="hd_id4313791">Type 4</h2> - <paragraph id="par_id4331797" role="paragraph">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 id="par_id4191717" role="paragraph">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> - <h2 id="hd_id2318796">Setting the Data Source</h2> - <h2 id="hd_id399182">Charts based on its own data</h2> - <paragraph id="par_id5298318" role="paragraph">To change the data series of a chart having its own data, choose <link href="text/schart/01/03010000.xhp"><emph>Chart Data Table</emph></link> from the <emph>View</emph> menu or from the context menu of the chart in edit mode.</paragraph> - <paragraph id="par_id7588732" role="paragraph">In an embedded chart data table, the data series are always organized in columns.</paragraph> - <paragraph id="par_id95828" role="paragraph">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 <emph>Move Series Right</emph> to change the column order. Close the chart data table. Now use the <emph>Chart Type</emph> dialog to change to the stock chart variant.</paragraph> - <paragraph id="par_id6182744" role="paragraph">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 id="par_id3496200" role="paragraph">Do not write the name of a data series in a row. Write the name into the field above the role name.</paragraph> - <paragraph id="par_id7599108" role="paragraph">The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order.</paragraph> - <h2 id="hd_id888698">Charts based on Calc or Writer tables</h2> - <paragraph id="par_id3394573" role="paragraph">You can choose or alter a data range on the second page of the <emph>Chart Wizard</emph> or in the <link href="text/schart/01/wiz_data_range.xhp"><emph>Data Range</emph></link> dialog. For fine tuning use the <link href="text/schart/01/wiz_data_series.xhp"><emph>Data Series</emph></link> dialog.</paragraph> - <paragraph id="par_id7594225" role="paragraph">To specify a data range do one of the following:</paragraph> - <list type="ordered"> + <paragraph id="par_id3004547" role="paragraph">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 id="par_id6401867" role="paragraph">Depending on the chosen variant, you do not need all columns.</paragraph> + <h2 id="hd_id18616">Stock Chart Variants</h2> + <paragraph id="par_id6138492" role="paragraph">Choose the <emph>Stock</emph> chart type on the first page of the <link href="text/schart/01/wiz_chart_type.xhp"><emph>Chart Wizard</emph></link>. Then select one of the four variants.</paragraph> + <h2 id="hd_id4569231">Stock Chart Type 1</h2> + <paragraph id="par_id291451" role="paragraph">Based on <emph>low</emph> and <emph>high</emph> column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line.</paragraph> + <paragraph id="par_id3341776" role="paragraph">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> + <table id="tab_id761747393380181"> + <tablerow> + <tablecell> + <paragraph id="par_id621747393380184" role="paragraph"><image src="chart2/res/stock_52x60.svg" id="img_id801747393380186" width="0.6252in" height="0.5417in"><alt id="alt_id761747393380189">Icon Stock Chart Type 1</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id431747393380193" role="paragraph">Stock Chart Type 1</paragraph> + </tablecell> + </tablerow> + </table> + <h2 id="hd_id5947141">Stock Chart Type 2</h2> + <paragraph id="par_id1911679" role="paragraph">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> + <table id="tab_id191747393651798"> + <tablerow> + <tablecell> + <paragraph id="par_id21747393651801" role="paragraph"><image src="chart2/res/stockblock_52x60.svg" id="img_id761747393651804" width="0.6252in" height="0.5417in"><alt id="alt_id931747393651806">Icon Stock Chart Type 2</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231747393651811" role="paragraph">Stock Chart Type 2</paragraph> + </tablecell> + </tablerow> + </table> + <h2 id="hd_id9364909">Stock Chart Type 3</h2> + <paragraph id="par_id4473403" role="paragraph">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> + <table id="tab_id661747393746872"> + <tablerow> + <tablecell> + <paragraph id="par_id701747393746874" role="paragraph"><image src="chart2/res/stockcolumns_52x60.svg" id="img_id291747393746877" width="0.6252in" height="0.5417in"><alt id="alt_id941747393746879">Icon Stock Chart Type 3</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id151747393746883" role="paragraph">Stock Chart Type 3</paragraph> + </tablecell> + </tablerow> + </table> + <h2 id="hd_id4313791">Stock Chart Type 4</h2> + <paragraph id="par_id4331797" role="paragraph">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 id="par_id4191717" role="paragraph">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> + <table id="tab_id731747393843884"> + <tablerow> + <tablecell> + <paragraph id="par_id581747393843886" role="paragraph"><image src="chart2/res/stockcolumnsattach_52x60.svg" id="img_id451747393843888" width="0.6252in" height="0.5417in"><alt id="alt_id631747393843891">Icon Stock Chart Type 4</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id211747393843895" role="paragraph">Stock Chart Type 4</paragraph> + </tablecell> + </tablerow> + </table> + <h2 id="hd_id2318796">Setting the Data Source</h2> + <h2 id="hd_id399182">Charts based on its own data</h2> + <paragraph id="par_id5298318" role="paragraph">To change the data series of a chart having its own data, choose <link href="text/schart/01/03010000.xhp"><emph>Chart Data Table</emph></link> from the <emph>View</emph> menu or from the context menu of the chart in edit mode.</paragraph> + <paragraph id="par_id7588732" role="paragraph">In an embedded chart data table, the data series are always organized in columns.</paragraph> + <paragraph id="par_id95828" role="paragraph">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 <emph>Move Series Right</emph> to change the column order. Close the chart data table. Now use the <emph>Chart Type</emph> dialog to change to the stock chart variant.</paragraph> + <paragraph id="par_id6182744" role="paragraph">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 id="par_id3496200" role="paragraph">Do not write the name of a data series in a row. Write the name into the field above the role name.</paragraph> + <paragraph id="par_id7599108" role="paragraph">The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order.</paragraph> + <h2 id="hd_id888698">Charts based on Calc or Writer tables</h2> + <paragraph id="par_id3394573" role="paragraph">You can choose or alter a data range on the second page of the <emph>Chart Wizard</emph> or in the <link href="text/schart/01/wiz_data_range.xhp"><emph>Data Range</emph></link> dialog. For fine tuning use the <link href="text/schart/01/wiz_data_series.xhp"><emph>Data Series</emph></link> dialog.</paragraph> + <paragraph id="par_id7594225" role="paragraph">To specify a data range do one of the following:</paragraph> + <list type="ordered"> <listitem> - <paragraph id="par_id5081637" role="paragraph">Enter the data range in the text box.</paragraph> - <paragraph id="par_id9759514" role="paragraph">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 id="par_id1614429" role="paragraph">As long as the syntax is not correct, %PRODUCTNAME shows the text in red.</paragraph> + <paragraph id="par_id5081637" role="paragraph">Enter the data range in the text box.</paragraph> + <paragraph id="par_id9759514" role="paragraph">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 id="par_id1614429" role="paragraph">As long as the syntax is not correct, %PRODUCTNAME shows the text in red.</paragraph> </listitem> - </list> - <list type="ordered"> + </list> + <list type="ordered"> <listitem> - <paragraph id="par_id1589098" role="paragraph">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> + <paragraph id="par_id1589098" role="paragraph">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 id="par_id8746910" role="paragraph">Click one of the options for data series in rows or in columns. </paragraph> - <paragraph id="par_id9636524" role="paragraph">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> - <h2 id="hd_id5675527">Fine Tuning the Data Ranges of Table Based Stock Charts</h2> - <paragraph id="par_id3486434" role="paragraph">You can organize data series and edit the source for parts of single data series on the third page of the <emph>Chart Wizard</emph> or on the page <emph>Data Series</emph> in the <emph>Data Range</emph> dialog.</paragraph> - <h2 id="hd_id3068636">Organize Data Series</h2> - <paragraph id="par_id2480849" role="paragraph">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 id="par_id4181951" role="paragraph">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 id="par_id2927335" role="paragraph">To remove a data series, select the data series in the list and click <emph>Remove</emph>.</paragraph> - <paragraph id="par_id2107303" role="paragraph">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> - <h2 id="hd_id4071779">Setting Data Ranges</h2> - <paragraph id="par_id7844477" role="paragraph">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 id="par_id6478469" role="paragraph">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 id="par_id9038972" role="paragraph">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 id="par_id7985168" role="paragraph">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> - <h2 id="hd_id876186">Legend</h2> - <paragraph id="par_id3939634" role="paragraph">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 id="par_id2377697" role="paragraph">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 id="par_id2188787" role="paragraph">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph> - <section id="relatedtopics"> + </list> + <paragraph id="par_id8746910" role="paragraph">Click one of the options for data series in rows or in columns. </paragraph> + <paragraph id="par_id9636524" role="paragraph">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> + <h2 id="hd_id5675527">Fine Tuning the Data Ranges of Table Based Stock Charts</h2> + <paragraph id="par_id3486434" role="paragraph">You can organize data series and edit the source for parts of single data series on the third page of the <emph>Chart Wizard</emph> or on the page <emph>Data Series</emph> in the <emph>Data Range</emph> dialog.</paragraph> + <h2 id="hd_id3068636">Organize Data Series</h2> + <paragraph id="par_id2480849" role="paragraph">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 id="par_id4181951" role="paragraph">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 id="par_id2927335" role="paragraph">To remove a data series, select the data series in the list and click <emph>Remove</emph>.</paragraph> + <paragraph id="par_id2107303" role="paragraph">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> + <h2 id="hd_id4071779">Setting Data Ranges</h2> + <paragraph id="par_id7844477" role="paragraph">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 id="par_id6478469" role="paragraph">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 id="par_id9038972" role="paragraph">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 id="par_id7985168" role="paragraph">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> + <h2 id="hd_id876186">Legend</h2> + <paragraph id="par_id3939634" role="paragraph">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 id="par_id2377697" role="paragraph">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 id="par_id2188787" role="paragraph">Select one of the position options. When the chart is finished, you can specify other positions using the Format menu.</paragraph> + <section id="relatedtopics"> + <paragraph role="paragraph" id="par_id731747249615264" localize="false"><embedvar href="text/schart/01/choose_chart_type.xhp#choose_chart_type" markup="ignore"/></paragraph> <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> + </section> +</body> </helpdocument> diff --git a/source/text/schart/01/type_xy.xhp b/source/text/schart/01/type_xy.xhp index e074f49820..c11ef0107f 100644 --- a/source/text/schart/01/type_xy.xhp +++ b/source/text/schart/01/type_xy.xhp @@ -37,17 +37,11 @@ <bookmark_value>variances in charts</bookmark_value> <bookmark_value>standard deviation in charts</bookmark_value> </bookmark><comment>mw changed xy to XY (2x)</comment> -<h1 id="hd_id9346598"><variable id="type_xy"><link href="text/schart/01/type_xy.xhp">Chart Type XY (Scatter)</link> -</variable></h1> +<h1 id="hd_id9346598"><variable id="type_xy"><link href="text/schart/01/type_xy.xhp">Chart Type XY (Scatter)</link></variable></h1> <paragraph role="paragraph" id="par_id2003845">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/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph role="paragraph" id="par_id281715882742258">Choose <menuitem>Insert - Chart - Chart Type - XY (Scatter)</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_tabUI"/> - <paragraph role="paragraph" id="par_id281715882937791">Choose <menuitem>Insert - Chart - Chart Type - XY (Scatter)</menuitem></paragraph> - <embed href="text/shared/00/00000004.xhp#from_toolbars"/> - <embed href="text/schart/00/00000004.xhp#wiz_icon"/> - <paragraph role="paragraph" id="par_id821715883408073">- then in the <menuitem>Chart Wizard</menuitem> choose <menuitem>Chart Type - XY (Scatter)</menuitem></paragraph> + <embed href="text/schart/00/00000004.xhp#wiz"/> + <paragraph role="paragraph" id="par_id791747395583502">Then choose <emph>XY (Scatter)</emph>.</paragraph> </section> <h2 id="hd_id7757194">XY (Scatter)</h2> <paragraph role="paragraph" id="par_id5977965">An XY chart in its basic form is based on one data series consisting of a name, a list of x‑values, and a list of y‑values. Each value pair (x|y) is shown as a point in a coordinate system. The name of the data series is associated with the y‑values and shown in the legend.</paragraph> diff --git a/source/text/schart/main0503.xhp b/source/text/schart/main0503.xhp index 30f5f3a6b9..5eec164f03 100644 --- a/source/text/schart/main0503.xhp +++ b/source/text/schart/main0503.xhp @@ -1,6 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - <!-- * This file is part of the LibreOffice project. * @@ -18,11 +16,10 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - <helpdocument version="1.0"> <meta> <topic id="textschartmain0503xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">$[officename] Chart Features</title> +<title id="tit">$[officename] Chart Features</title> <filename>/text/schart/main0503.xhp</filename> </topic> <history> @@ -30,16 +27,14 @@ </history> </meta> <body> - - <section id="features"> <h1 id="hd_id3150543"><link href="text/schart/main0503.xhp">$[officename] Chart Features</link></h1> - <paragraph role="paragraph" id="par_id3150868" xml-lang="en-US">Charts allow you to present data so that it is easy to visualize.</paragraph> + <paragraph role="paragraph" id="par_id3150868">Charts allow you to present data so that it is easy to visualize.</paragraph> </section> - <paragraph role="paragraph" id="par_id3146974" xml-lang="en-US">You can create a chart from source data in a Calc spreadsheet or a Writer table. When the chart is embedded in the same document as the data, it stays linked to the data, so that the chart automatically updates when you change the source data.</paragraph> - <h3 id="hd_id3153143">Chart Types</h3> - <paragraph role="paragraph" id="par_id3151112" xml-lang="en-US">Choose from a variety of 3D charts and 2D charts, such as bar charts, line charts, stock charts. You can change chart types with a few clicks of the mouse.</paragraph> + <paragraph role="paragraph" id="par_id3146974">You can create a chart from source data in a Calc spreadsheet or a Writer table. When the chart is embedded in the same document as the data, it stays linked to the data, so that the chart automatically updates when you change the source data.</paragraph> + <h3 id="hd_id3153143" localize="false"><embedvar href="text/schart/01/choose_chart_type.xhp#choose_chart_type" markup="ignore"/></h3> + <paragraph role="paragraph" id="par_id3151112">Choose from a variety of 3D charts and 2D charts, such as bar charts, line charts, stock charts. You can change chart types with a few clicks of the mouse.</paragraph> <h3 id="hd_id3149665">Individual Formatting</h3> - <paragraph role="paragraph" id="par_id3156441" xml-lang="en-US">You can customize individual chart elements, such as axes, data labels, and legends, by right-clicking them in the chart, or with toolbar icons and menu commands.</paragraph> + <paragraph role="paragraph" id="par_id3156441">You can customize individual chart elements, such as axes, data labels, and legends, by right-clicking them in the chart, or with toolbar icons and menu commands.</paragraph> </body> </helpdocument>