Package_html_media.mk | 1 source/media/helpimg/schart/CategoryProperties.png |binary source/text/schart/00/00000004.xhp | 8 + source/text/schart/01/wiz_data_series.xhp | 103 ++++++++++++--------- 4 files changed, 70 insertions(+), 42 deletions(-)
New commits: commit 8dee39a0fae12660e982dc74cea1d29721bdc946 Author: Olivier Hallot <[email protected]> AuthorDate: Thu Jul 10 10:42:41 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Thu Jul 10 16:00:14 2025 +0200 tdf#167137 Explain the use of "Property Mapping" in Charts + refactor + added image Change-Id: I947af17ec8f30086e5dc309c45d000becd4cee32 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/187640 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/Package_html_media.mk b/Package_html_media.mk index 176fa67f28..c1f67653c5 100644 --- a/Package_html_media.mk +++ b/Package_html_media.mk @@ -178,6 +178,7 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE helpimg/sbasic/While_statement.svg \ helpimg/sbasic/With_statement.svg \ helpimg/sbasic/Write_statement.svg \ + helpimg/schart/CategoryProperties.png \ helpimg/scalc/coordinates-to-polar-01.svg \ helpimg/scalc/calczoomslider.png \ helpimg/sdraw/area-fill-none-same-vs-background.png \ diff --git a/source/media/helpimg/schart/CategoryProperties.png b/source/media/helpimg/schart/CategoryProperties.png new file mode 100644 index 0000000000..b59210b133 Binary files /dev/null and b/source/media/helpimg/schart/CategoryProperties.png differ diff --git a/source/text/schart/00/00000004.xhp b/source/text/schart/00/00000004.xhp index 2319f2f6a9..b3329345df 100644 --- a/source/text/schart/00/00000004.xhp +++ b/source/text/schart/00/00000004.xhp @@ -226,9 +226,13 @@ </section> </section> <section id="wiz_ranges"> - <paragraph role="paragraph" id="par_id2985320">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_id2985320">Choose <emph>Insert - Chart - Data Series...</emph></paragraph> <paragraph role="paragraph" id="par_id1096530">Double-click a chart, then choose <emph>Format - Data Ranges</emph></paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id701752152110626">Choose <menuitem>Insert - Chart - Data Series...</menuitem></paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <embed href="text/schart/00/00000004.xhp#wiz_icon"/> </section> <paragraph role="paragraph" id="par_id733359"><variable id="smlp">In the Chart Type dialog of a Line chart or XY chart that displays lines, choose Smooth in the Lines type drop-down, then click the Properties button.</variable></paragraph> <paragraph role="paragraph" id="par_id8513095"><variable id="stlp">In the Chart Type dialog of a Line chart or XY chart that displays lines, choose Stepped in the Lines type drop-down, then click the Properties button.</variable></paragraph> diff --git a/source/text/schart/01/wiz_data_series.xhp b/source/text/schart/01/wiz_data_series.xhp index af8f8dddec..f1aa9e403d 100644 --- a/source/text/schart/01/wiz_data_series.xhp +++ b/source/text/schart/01/wiz_data_series.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,79 +16,105 @@ * 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="textschart01wiz_data_seriesxhp" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Chart Wizard - Data Series</title> +<title id="tit">Chart Wizard - Data Series</title> <filename>/text/schart/01/wiz_data_series.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id8641621"><bookmark_value>order of chart data</bookmark_value> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/> +<bookmark branch="index" id="bm_id8641621"><bookmark_value>order of chart data</bookmark_value> <bookmark_value>data series</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id6124149" xml-lang="en-US" level="1"><variable id="wiz_data_series"><link href="text/schart/01/wiz_data_series.xhp">Chart Wizard - Data Series</link> -</variable></paragraph> -<paragraph role="paragraph" id="par_id9651478" xml-lang="en-US">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can change the source range of all data series separately, including their labels. You can also change the range of the categories. You can first select the data range on the Data Range page and then remove unnecessary data series or add data series from other cells here.</paragraph> -<paragraph role="tip" id="par_id6326487" xml-lang="en-US">If there seem to be too many options on this page, just define the data range on the Chart Wizard - Data Range page and skip this page.</paragraph> +<h1 id="hd_id6124149"><variable id="wiz_data_series"><link href="text/schart/01/wiz_data_series.xhp">Chart Wizard - Data Series</link> +</variable></h1> +<paragraph role="paragraph" id="par_id9651478">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can change the source range of all data series separately, including their labels. You can also change the range of the categories asn well as the properties of the categories, such as colors. You can first select the data range on the Data Range page and then remove unnecessary data series or add data series from other cells here.</paragraph> +<tip id="par_id6326487">If there seem to be too many options on this page, just define the data range on the Chart Wizard - Data Range page and skip this page.</tip> <section id="howtoget"> <embed href="text/schart/00/00000004.xhp#wiz_ranges"/> </section> -<paragraph role="paragraph" id="par_id686361" xml-lang="en-US">This dialog is only available for charts based on a Calc or Writer table.</paragraph> +<paragraph role="paragraph" id="par_id686361">This dialog is only available for charts based on a Calc or Writer table.</paragraph> <embed href="text/shared/00/00000001.xhp#ShiftF1"/> <h2 id="hd_id9241615">Organizing data series</h2> -<paragraph role="paragraph" id="par_id7159337" 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_id7159337">In the Data Series list box you see a list of all data series in the current chart.</paragraph> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id4921720" xml-lang="en-US">To organize the data series, select an entry in the list.</paragraph> +<paragraph role="paragraph" id="par_id4921720">To organize the data series, select an entry in the list.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id6627094" 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_id6627094">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_id2926419" xml-lang="en-US">Click Remove to remove the selected entry from the Data Series list.</paragraph> +<paragraph role="paragraph" id="par_id2926419">Click Remove to remove the selected entry from the Data Series list.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id4443800" xml-lang="en-US">Use the Up and Down arrow buttons to move the selected entry in the list up or down. 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_id4443800">Use the Up and Down arrow buttons to move the selected entry in the list up or down. 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_id9777520">Editing data series</h2> <list type="ordered"> <listitem> -<paragraph role="paragraph" id="par_id1474654" 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_id4855189" 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_id1474654">Click an entry in the list to view and edit the properties for that entry.</paragraph> +<paragraph role="paragraph" id="par_id4855189">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_id9475081" xml-lang="en-US">Click an entry, then edit the contents in the text box below. </paragraph> -<paragraph role="paragraph" id="par_id4695272" xml-lang="en-US">The label next to the text box states the currently selected role. </paragraph> +<paragraph role="paragraph" id="par_id9475081">Click an entry, then edit the contents in the text box below. </paragraph> +<paragraph role="paragraph" id="par_id4695272">The label next to the text box states the currently selected role. </paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id3931699" 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_id8626667" xml-lang="en-US">If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.</paragraph> +<paragraph role="paragraph" id="par_id3931699">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_id8626667">If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id5971556" xml-lang="en-US">The range for a data role, like Y-Values, must not include a label cell.</paragraph> -<h2 id="hd_id7622608">Editing categories or data labels</h2> +<paragraph role="paragraph" id="par_id5971556">The range for a data role, like Y-Values, must not include a label cell.</paragraph> +<h2 id="hd_id7622608">Editing data labels</h2> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id9222693" xml-lang="en-US">Enter or select a cell range that will be used as text for categories or data labels. <comment>UFI: red text means what?</comment></paragraph> +<paragraph role="paragraph" id="par_id9222693">Enter or select a cell range that will be used as text for categories or data labels. <comment>UFI: red text means what?</comment></paragraph> </listitem> </list> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/tp_DataSource" id="bm_id1830" localize="false"/> -<paragraph role="paragraph" id="par_id9500106" xml-lang="en-US">Depending on the chart type, the texts are shown on the X axis or as data labels. </paragraph><comment>Regina: If you enter a range here, the check box "First column as label" (assumed data series in columns) on the Data Range page of the dialog is marked automatically and if you erase the entry in the input field, it is unchecked automatically.</comment><comment>data series list box</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/LB_SERIES" id="bm_id1831" localize="false"/><paragraph role="paragraph" id="par_id5201879" xml-lang="en-US"><ahelp hid="." visibility="hidden">Shows a list of all data series in the chart. Click an entry to view and edit that data series. Click <emph>Add</emph> to insert a new series into the list after the selected entry.</ahelp></paragraph><comment>data ranges list box</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/LB_ROLE" id="bm_id6718649" localize="false"/><paragraph role="paragraph" id="par_id2571794" xml-lang="en-US"><ahelp hid="." visibility="hidden">Shows all the data ranges used by the data series that is selected in the Data Series list box. Each data range shows the role name and the source range address.</ahelp></paragraph><comment>range for ... & shrinky</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/EDT_RANGE" id="bm_id1857051" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/IMB_RANGE_MAIN" id="bm_id8336741" localize="false"/><paragraph role="paragraph" id="par_id2254402" xml-lang="en-US"><ahelp hid="." visibility="hidden">Shows the source range address from the second column of the Data Range list box. You can change the range in the text box or by dragging in the document. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><comment>categories & shrinky</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/EDT_CATEGORIES" id="bm_id9499496" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/IMB_RANGE_CAT" id="bm_id4844508" localize="false"/><paragraph role="paragraph" id="par_id2419507" xml-lang="en-US"><ahelp hid="." visibility="hidden">Shows the source range address of the categories (the texts you can see on the x-axis of a category chart). For an XY-chart, the text box contains the source range of the data labels which are displayed for the data points. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><comment>add button</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/BTN_ADD" id="bm_id5381328" localize="false"/><paragraph role="paragraph" id="par_id1091647" xml-lang="en-US"><ahelp hid="." visibility="hidden">Adds a new entry below the current entry in the Data Series list. If an entry is selected, the new data series gets the same chart type.</ahelp></paragraph><comment>Remove button</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/BTN_REMOVE" id="bm_id2036805" localize="false"/><paragraph role="paragraph" id="par_id8831446" xml-lang="en-US"><ahelp hid="." visibility="hidden">Removes the selected entry from the Data Series list.</ahelp></paragraph><comment>^ up button</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/BTN_UP" id="bm_id2141788" localize="false"/><paragraph role="paragraph" id="par_id7022309" xml-lang="en-US"><ahelp hid="." visibility="hidden">Moves up the selected entry in the Data Series list.</ahelp></paragraph><comment>v down button</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_DataSource/BTN_DOWN" id="bm_id5013885" localize="false"/><paragraph role="paragraph" id="par_id2844019" xml-lang="en-US"><ahelp hid="." visibility="hidden">Moves down the selected entry in the Data Series list.</ahelp></paragraph> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/tp_DataSource" id="bm_id1830" localize="false"/> +<paragraph role="paragraph" id="par_id9500106">Depending on the chart type, the texts are shown on the X axis or as data labels. </paragraph><comment>Regina: If you enter a range here, the check box "First column as label" (assumed data series in columns) on the Data Range page of the dialog is marked automatically and if you erase the entry in the input field, it is unchecked automatically.</comment><comment>data series list box</comment> + +<h2 id="hd_id721752153151130">Editing properties of the categories</h2> +<paragraph role="paragraph" id="par_id91752153157052">Each category entry can have a fill color and a border color.</paragraph> +<paragraph role="paragraph" id="par_id731752153161890">You can edit the fill color and border color properties of the categories. The colors are defined by a range of cells with the same size of the category range.</paragraph> +<paragraph role="paragraph" id="par_id121752153167074">The colors values are expressed by their red, green, blue components (RGB) combined by the COLOR() function.</paragraph> +<note id="par_id191752153873768">Data ranges for border color and fill can only be specified for column, bar, pie, bubble, and column and line charts.</note> +<h3 id="hd_id971752153581399">Setting Category Fill Color</h3> +<list type="ordered"> + <listitem> + <paragraph id="par_id691752152644728" role="listitem">Click on <emph>Fill Color</emph> entry in the list.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id281752152744204" role="listitem">In the <emph>Range for Fill Color</emph> box, enter the cell ranges of the categories fill color values.</paragraph> + </listitem> +</list> +<h3 id="hd_id81752153642574">Setting Category Border Color</h3> +<list type="ordered"> + <listitem> + <paragraph id="par_id531752153439773" role="listitem">Click on <emph>Border Color</emph> entry in the list.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id21752153442981" role="listitem">In the <emph>Range for Border Color</emph> box, enter the cell ranges of the categories fill color values.</paragraph> + </listitem> +</list> +<h3 id="hd_id571752153945879">Example</h3> +<paragraph role="paragraph" id="par_id411752153964161"> + <image src="media/helpimg/schart/CategoryProperties.png" id="img_id511752153964163" width="616px" height="230px"><alt id="alt_id901752153964166">Set category fill color</alt></image> +</paragraph> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/LB_SERIES" id="bm_id1831" localize="false"/><paragraph role="paragraph" id="par_id5201879"><ahelp hid="." visibility="hidden">Shows a list of all data series in the chart. Click an entry to view and edit that data series. Click <emph>Add</emph> to insert a new series into the list after the selected entry.</ahelp></paragraph><comment>data ranges list box</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/LB_ROLE" id="bm_id6718649" localize="false"/><paragraph role="paragraph" id="par_id2571794"><ahelp hid="." visibility="hidden">Shows all the data ranges used by the data series that is selected in the Data Series list box. Each data range shows the role name and the source range address.</ahelp></paragraph><comment>range for ... & shrinky</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/EDT_RANGE" id="bm_id1857051" localize="false"/> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/IMB_RANGE_MAIN" id="bm_id8336741" localize="false"/><paragraph role="paragraph" id="par_id2254402"><ahelp hid="." visibility="hidden">Shows the source range address from the second column of the Data Range list box. You can change the range in the text box or by dragging in the document. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><comment>categories & shrinky</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/EDT_CATEGORIES" id="bm_id9499496" localize="false"/> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/IMB_RANGE_CAT" id="bm_id4844508" localize="false"/><paragraph role="paragraph" id="par_id2419507"><ahelp hid="." visibility="hidden">Shows the source range address of the categories (the texts you can see on the x-axis of a category chart). For an XY-chart, the text box contains the source range of the data labels which are displayed for the data points. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><comment>add button</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_ADD" id="bm_id5381328" localize="false"/><paragraph role="paragraph" id="par_id1091647"><ahelp hid="." visibility="hidden">Adds a new entry below the current entry in the Data Series list. If an entry is selected, the new data series gets the same chart type.</ahelp></paragraph><comment>Remove button</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_REMOVE" id="bm_id2036805" localize="false"/><paragraph role="paragraph" id="par_id8831446"><ahelp hid="." visibility="hidden">Removes the selected entry from the Data Series list.</ahelp></paragraph><comment>^ up button</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_UP" id="bm_id2141788" localize="false"/><paragraph role="paragraph" id="par_id7022309"><ahelp hid="." visibility="hidden">Moves up the selected entry in the Data Series list.</ahelp></paragraph><comment>v down button</comment> +<bookmark branch="hid/modules/schart/ui/tp_DataSource/BTN_DOWN" id="bm_id5013885" localize="false"/><paragraph role="paragraph" id="par_id2844019"><ahelp hid="." visibility="hidden">Moves down the selected entry in the Data Series list.</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"/>
