source/text/schart/01/type_stock.xhp | 187 +++++++++++++++++------------------
1 file changed, 93 insertions(+), 94 deletions(-)
New commits:
commit 713ded95232e2ffd01bced075b48d7705c14e75b
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon May 12 19:52:53 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue May 13 12:58:41 2025 +0200
Mute l10n for table with numbers on Stock charts
+ Refactor
+ visual enhancement for the table
Change-Id: Ic1385eb9baaf996c676cced7639abd245b36103b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/185238
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/schart/01/type_stock.xhp
b/source/text/schart/01/type_stock.xhp
index f3155f2d53..2f24a96a37 100644
--- a/source/text/schart/01/type_stock.xhp
+++ b/source/text/schart/01/type_stock.xhp
@@ -20,241 +20,240 @@
<meta>
<topic id="textschart01type_stockxhp" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Chart Type Stock</title>
+ <title id="tit">Chart Type Stock</title>
<filename>/text/schart/01/type_stock.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id2959990"><bookmark_value>stock charts</bookmark_value>
- <bookmark_value>chart types;stock</bookmark_value>
- <bookmark_value>data sources;setting for stock charts</bookmark_value>
+<bookmark branch="index" id="bm_id2959990"><bookmark_value>stock
charts</bookmark_value>
+<bookmark_value>chart types;stock</bookmark_value>
+<bookmark_value>data sources;setting for stock charts</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<paragraph xml-lang="en-US" id="hd_id966216" role="heading"
level="1"><variable id="type_stock"><link
href="text/schart/01/type_stock.xhp">Chart Type Stock</link>
-</variable></paragraph>
- <paragraph xml-lang="en-US" 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>
+<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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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>
-</tablecell>
- <tablecell>
- <paragraph xml-lang="en-US" id="par_id1022064"
role="tablehead">A</paragraph>
+ <paragraph id="par_id1022064" localize="false"
role="tablehead">A</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1924192"
role="tablehead">B</paragraph>
+ <paragraph id="par_id1924192" localize="false"
role="tablehead">B</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3258156"
role="tablehead">C</paragraph>
+ <paragraph id="par_id3258156" localize="false"
role="tablehead">C</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3161412"
role="tablehead">D</paragraph>
+ <paragraph id="par_id3161412" localize="false"
role="tablehead">D</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id5619373"
role="tablehead">E</paragraph>
+ <paragraph id="par_id5619373" localize="false"
role="tablehead">E</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id6474501"
role="tablehead">F</paragraph>
+ <paragraph id="par_id6474501" localize="false"
role="tablehead">F</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7411725"
role="tablecontent">1</paragraph>
+ <paragraph id="par_id7411725" localize="false"
role="tablehead">1</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1933957"
role="tablecontent">Transaction volume</paragraph>
+ <paragraph id="par_id1933957" role="tablecontent">Transaction
volume</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1274452"
role="tablecontent">Opening price</paragraph>
+ <paragraph id="par_id1274452" role="tablecontent">Opening
price</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id5044404"
role="tablecontent">Low (bottom price)</paragraph>
+ <paragraph id="par_id5044404" role="tablecontent">Low (bottom
price)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3892635"
role="tablecontent">High (top price)</paragraph>
+ <paragraph id="par_id3892635" role="tablecontent">High (top
price)</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id4641865"
role="tablecontent">Closing price</paragraph>
+ <paragraph id="par_id4641865" role="tablecontent">Closing
price</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7684560"
role="tablecontent">2</paragraph>
+ <paragraph id="par_id7684560" localize="false"
role="tablehead">2</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3998840"
role="tablecontent">Monday</paragraph>
+ <paragraph id="par_id3998840"
role="tablecontent">Monday</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7675099"
role="tablecontent">2500</paragraph>
+ <paragraph id="par_id7675099" localize="false"
role="tablecontent">2500</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7806329"
role="tablecontent">20</paragraph>
+ <paragraph id="par_id7806329" localize="false"
role="tablecontent">20</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id5589159"
role="tablecontent">15</paragraph>
+ <paragraph id="par_id5589159" localize="false"
role="tablecontent">15</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id9936216"
role="tablecontent">25</paragraph>
+ <paragraph id="par_id9936216" localize="false"
role="tablecontent">25</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7953123"
role="tablecontent">17</paragraph>
+ <paragraph id="par_id7953123" localize="false"
role="tablecontent">17</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id4013794"
role="tablecontent">3</paragraph>
+ <paragraph id="par_id4013794" localize="false"
role="tablehead">3</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1631824"
role="tablecontent">Tuesday</paragraph>
+ <paragraph id="par_id1631824"
role="tablecontent">Tuesday</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7271645"
role="tablecontent">3500</paragraph>
+ <paragraph id="par_id7271645" localize="false"
role="tablecontent">3500</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id2136295"
role="tablecontent">32</paragraph>
+ <paragraph id="par_id2136295" localize="false"
role="tablecontent">32</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id4186223"
role="tablecontent">22</paragraph>
+ <paragraph id="par_id4186223" localize="false"
role="tablecontent">22</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1491134"
role="tablecontent">37</paragraph>
+ <paragraph id="par_id1491134" localize="false"
role="tablecontent">37</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id2873622"
role="tablecontent">30</paragraph>
+ <paragraph id="par_id2873622" localize="false"
role="tablecontent">30</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id2374034"
role="tablecontent">4</paragraph>
+ <paragraph id="par_id2374034" localize="false"
role="tablehead">4</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1687063"
role="tablecontent">Wednesday</paragraph>
+ <paragraph id="par_id1687063"
role="tablecontent">Wednesday</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id8982207"
role="tablecontent">1000</paragraph>
+ <paragraph id="par_id8982207" localize="false"
role="tablecontent">1000</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7074190"
role="tablecontent">15</paragraph>
+ <paragraph id="par_id7074190" localize="false"
role="tablecontent">15</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id5452436"
role="tablecontent">15</paragraph>
+ <paragraph id="par_id5452436" localize="false"
role="tablecontent">15</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id9527878"
role="tablecontent">17</paragraph>
+ <paragraph id="par_id9527878" localize="false"
role="tablecontent">17</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id6342356"
role="tablecontent">17</paragraph>
+ <paragraph id="par_id6342356" localize="false"
role="tablecontent">17</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id166936"
role="tablecontent">5</paragraph>
+ <paragraph id="par_id166936" localize="false"
role="tablehead">5</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id6826990"
role="tablecontent">Thursday</paragraph>
+ <paragraph id="par_id6826990"
role="tablecontent">Thursday</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id6897183"
role="tablecontent">2200</paragraph>
+ <paragraph id="par_id6897183" localize="false"
role="tablecontent">2200</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7003387"
role="tablecontent">40</paragraph>
+ <paragraph id="par_id7003387" localize="false"
role="tablecontent">40</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id4897915"
role="tablecontent">30</paragraph>
+ <paragraph id="par_id4897915" localize="false"
role="tablecontent">30</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3105868"
role="tablecontent">47</paragraph>
+ <paragraph id="par_id3105868" localize="false"
role="tablecontent">47</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id3908810"
role="tablecontent">35</paragraph>
+ <paragraph id="par_id3908810" localize="false"
role="tablecontent">35</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id9461653"
role="tablecontent">6</paragraph>
+ <paragraph id="par_id9461653" localize="false"
role="tablehead">6</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id9239173"
role="tablecontent">Friday</paragraph>
+ <paragraph id="par_id9239173"
role="tablecontent">Friday</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id2656941"
role="tablecontent">4600</paragraph>
+ <paragraph id="par_id2656941" localize="false"
role="tablecontent">4600</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id1481063"
role="tablecontent">27</paragraph>
+ <paragraph id="par_id1481063" localize="false"
role="tablecontent">27</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id7921079"
role="tablecontent">20</paragraph>
+ <paragraph id="par_id7921079" localize="false"
role="tablecontent">20</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id636921"
role="tablecontent">32</paragraph>
+ <paragraph id="par_id636921" localize="false"
role="tablecontent">32</paragraph>
</tablecell>
<tablecell>
- <paragraph xml-lang="en-US" id="par_id2799157"
role="tablecontent">31</paragraph>
+ <paragraph id="par_id2799157" localize="false"
role="tablecontent">31</paragraph>
</tablecell>
</tablerow>
</table>
- <paragraph xml-lang="en-US" 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 xml-lang="en-US" id="par_id6401867"
role="paragraph">Depending on the chosen variant, you do not need all
columns.</paragraph>
+ <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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" id="par_id7588732" role="paragraph">In an
embedded chart data table, the data series are always organized in
columns.</paragraph>
- <paragraph xml-lang="en-US" id="par_id95828" role="paragraph">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 xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" id="par_id7594225" role="paragraph">To
specify a data range do one of the following:</paragraph>
+ <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 xml-lang="en-US" id="par_id5081637"
role="paragraph">Enter the data range in the text box.</paragraph>
- <paragraph xml-lang="en-US" 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 xml-lang="en-US" 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">
<listitem>
- <paragraph xml-lang="en-US" 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 xml-lang="en-US" id="par_id8746910" role="paragraph">Click
one of the options for data series in rows or in columns. </paragraph>
- <paragraph xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" id="par_id2927335" role="paragraph">To
remove a data series, select the data series in the list and click
<emph>Remove</emph>.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2107303" role="paragraph">To add a
data series, select one of the existing data series and click <emph>Add</emph>.
You get an empty entry below the selected one, which has the same type. If you
have no price data series or no volume data series, you must first select a
range for these series in the <emph>Data Range</emph> dialog.<comment>Regina:
The behavior is odd, but I don't know a better solution. Therefore I have not
written an issue.</comment></paragraph>
+ <paragraph 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 xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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 xml-lang="en-US" 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 xml-lang="en-US" 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 xml-lang="en-US" 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>
+ <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">
<embed href="text/shared/guide/chart_insert.xhp#chart_insert"/>
<embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
@@ -263,4 +262,4 @@
<embed
href="text/schart/01/wiz_chart_elements.xhp#wiz_chart_elements"/>
</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
