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
The months are plain text, no numeric values. Therefore XY scatter works like simple line chart.
.
Instead of
Jan
write01.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...Also, this Wikipedia article on Scatter plots may help with the concept.
Thank you, Grantler. I should have noticed that about the dates, especially since I said in the first sentence that the X-axis contains data.
Thank you, robleyd. After reading the other comments, the article makes more sense.