Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 15 May 2019 20:37:06 +0200What is the logic of XY (Scatter) charts?https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/I understand that XY or scatter charts require data on the X-axis as well as the Y-axis.
What I don't understand is what the Calc 4.2 User Guide says:
"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."
The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis?
By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart.
The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.
So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
[C:\fakepath\Margarine syrup butter chart 5-14-19.ods](/upfiles/15578837657184411.ods)
Wed, 15 May 2019 03:30:26 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/Comment by Grantler for <p>I understand that XY or scatter charts require data on the X-axis as well as the Y-axis. </p>
<p>What I don't understand is what the Calc 4.2 User Guide says:</p>
<p>"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."</p>
<p>The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis? </p>
<p>By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart. </p>
<p>The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.</p>
<p>So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
<a href="/upfiles/15578837657184411.ods">C:\fakepath\Margarine syrup butter chart 5-14-19.ods</a> </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=193977#post-id-193977The months are plain text, no numeric values. Therefore XY scatter works like simple line chart.
.
Instead of **`Jan`** write **`01.01.2019`** (format depends on your locale) and transform the other cell contents into **numeric values** you will see the difference. If there are "irregular"/uneven time spaces the XY scatter will "spread" them in sort of equal/proportional mode...Wed, 15 May 2019 08:12:38 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=193977#post-id-193977Comment by robleyd for <p>I understand that XY or scatter charts require data on the X-axis as well as the Y-axis. </p>
<p>What I don't understand is what the Calc 4.2 User Guide says:</p>
<p>"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."</p>
<p>The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis? </p>
<p>By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart. </p>
<p>The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.</p>
<p>So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
<a href="/upfiles/15578837657184411.ods">C:\fakepath\Margarine syrup butter chart 5-14-19.ods</a> </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=193988#post-id-193988Also, this [Wikipedia article](https://en.wikipedia.org/wiki/Scatter_plot) on Scatter plots may help with the concept.Wed, 15 May 2019 10:52:07 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=193988#post-id-193988Comment by catbill for <p>I understand that XY or scatter charts require data on the X-axis as well as the Y-axis. </p>
<p>What I don't understand is what the Calc 4.2 User Guide says:</p>
<p>"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."</p>
<p>The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis? </p>
<p>By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart. </p>
<p>The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.</p>
<p>So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
<a href="/upfiles/15578837657184411.ods">C:\fakepath\Margarine syrup butter chart 5-14-19.ods</a> </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194014#post-id-194014Thank you, Grantler. I should have noticed that about the dates, especially since I said in the first sentence that the X-axis contains data.Wed, 15 May 2019 15:49:25 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194014#post-id-194014Comment by catbill for <p>I understand that XY or scatter charts require data on the X-axis as well as the Y-axis. </p>
<p>What I don't understand is what the Calc 4.2 User Guide says:</p>
<p>"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."</p>
<p>The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis? </p>
<p>By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart. </p>
<p>The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.</p>
<p>So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
<a href="/upfiles/15578837657184411.ods">C:\fakepath\Margarine syrup butter chart 5-14-19.ods</a> </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194050#post-id-194050Thank you, robleyd. After reading the other comments, the article makes more sense.Wed, 15 May 2019 20:37:06 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194050#post-id-194050Answer by Regina for <p>I understand that XY or scatter charts require data on the X-axis as well as the Y-axis. </p>
<p>What I don't understand is what the Calc 4.2 User Guide says:</p>
<p>"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."</p>
<p>The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis? </p>
<p>By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart. </p>
<p>The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.</p>
<p>So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
<a href="/upfiles/15578837657184411.ods">C:\fakepath\Margarine syrup butter chart 5-14-19.ods</a> </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?answer=194001#post-id-194001XY-charts are used in cases, which require a coordinate system as you have used it in school mathematics. The data is considered to be given as point with two coordinates. The x-axis is a true number line. That it the difference to a line chart, where the x-axis is a category axis. So you can label an x-axis in a line chart with months, which is not possible in an XY-chart. The label of an x-axis in an XY-chart mark a single point on the axis, in a line-chart the label marks an interval. Only for xy-charts the equation of a regression curve is meaningful.Wed, 15 May 2019 13:01:49 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?answer=194001#post-id-194001Comment by catbill for <p>XY-charts are used in cases, which require a coordinate system as you have used it in school mathematics. The data is considered to be given as point with two coordinates. The x-axis is a true number line. That it the difference to a line chart, where the x-axis is a category axis. So you can label an x-axis in a line chart with months, which is not possible in an XY-chart. The label of an x-axis in an XY-chart mark a single point on the axis, in a line-chart the label marks an interval. Only for xy-charts the equation of a regression curve is meaningful.</p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194046#post-id-194046Thank you for being so clear.Wed, 15 May 2019 20:31:03 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194046#post-id-194046Answer by ve3oat for <p>I understand that XY or scatter charts require data on the X-axis as well as the Y-axis. </p>
<p>What I don't understand is what the Calc 4.2 User Guide says:</p>
<p>"While constructing the chart, if you choose Data Range > Data series in rows, the first row of data represents the X-axis. The rest of the rows of data are then compared against the first of row data. Figure 39 shows a comparison of three currencies with the Japanese Yen. Even though the table presents the monthly series, the chart does not. In fact the Japanese Yen does not appear; it is merely used as the constant series that all the other data series are compared against."</p>
<p>The example in the user guide shows four rows of data. Only three data series are represented in the chart because they are all compared to the first row of data. The user guide says "the first row of data represents the X-axis." What does it mean to say that the data is represented in the X-axis? </p>
<p>By contrast, when I create an XY chart (attached), I have not seen the behavior described. When there are three rows of data, three data series appear in the chart. </p>
<p>The guide says that this works for data in rows. But wouldn't it work the same for data in columns? In the attached file, I created XY charts for data in columns and for data in rows. I saw no difference.</p>
<p>So, I would appreciate some insights about how data is treated in XY charts. Is the description in the user guide correct? If not, what does it say that is incorrect?
<a href="/upfiles/15578837657184411.ods">C:\fakepath\Margarine syrup butter chart 5-14-19.ods</a> </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?answer=193968#post-id-193968Without referring directly to the User Guide myself and going by your quotation, I beieve that what the Guide says is correct. The Yen does not appear as a data series because it is the **independent** variable against which the other (possibly) **dependent** variables are compared.
In your chart, you actually do have four series rather than just three, the independent series being Jan, Feb, Mar ... , against which the other three (dependent) series are compared. Does this make sense??
And, Yes, it works for both rows and columns, as you have well illustrated.
X-Y scatter charts are very useful, especially when the data has precise values and are complex in nature, not easily represented in simple bar charts or bubble charts. You see them often illustrating scientific and engineering studies. Wed, 15 May 2019 03:57:51 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?answer=193968#post-id-193968Comment by catbill for <p>Without referring directly to the User Guide myself and going by your quotation, I beieve that what the Guide says is correct. The Yen does not appear as a data series because it is the <strong>independent</strong> variable against which the other (possibly) <strong>dependent</strong> variables are compared. </p>
<p>In your chart, you actually do have four series rather than just three, the independent series being Jan, Feb, Mar ... , against which the other three (dependent) series are compared. Does this make sense?? </p>
<p>And, Yes, it works for both rows and columns, as you have well illustrated. </p>
<p>X-Y scatter charts are very useful, especially when the data has precise values and are complex in nature, not easily represented in simple bar charts or bubble charts. You see them often illustrating scientific and engineering studies. </p>
https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194049#post-id-194049The idea that the X-axis is independent variables is what I was missing. Now I understand this better. Thank you.Wed, 15 May 2019 20:35:21 +0200https://ask.libreoffice.org/en/question/193967/what-is-the-logic-of-xy-scatter-charts/?comment=194049#post-id-194049