Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 24 Jul 2018 04:01:42 +0200XY scatter keeps duplicating X-axis values when pulling dateshttps://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/I'm trying to create a simple XY scatter that tracks monthly net worth over the course of one year (Y-axis is value, x-axis is each month).
The data source is simple: two rows. Row one is the list of months and row two contains the numeric values ($10, $20, etc.). However, regardless of what I do with the X-axis format, it refuses to stop duplicating month labels.
How can I get the X axis to only have 12 values, labeled by month? Forcing X-axis to start in January and end in December, with a major interval of 1 still gives me duplicated months.
Interestingly, the chart works if it displays the months as simple numbers (1 through 12), but not when it is pulling info from a DATE formatted cell.
Please see the following album for the sample chart: https://imgur.com/a/G7VSFO0/
Thanks in advance!Sun, 22 Jul 2018 23:48:33 +0200https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/Comment by ve3oat for <p>I'm trying to create a simple XY scatter that tracks monthly net worth over the course of one year (Y-axis is value, x-axis is each month).</p>
<p>The data source is simple: two rows. Row one is the list of months and row two contains the numeric values ($10, $20, etc.). However, regardless of what I do with the X-axis format, it refuses to stop duplicating month labels.</p>
<p>How can I get the X axis to only have 12 values, labeled by month? Forcing X-axis to start in January and end in December, with a major interval of 1 still gives me duplicated months.</p>
<p>Interestingly, the chart works if it displays the months as simple numbers (1 through 12), but not when it is pulling info from a DATE formatted cell.</p>
<p>Please see the following album for the sample chart: <a href="https://imgur.com/a/G7VSFO0/">https://imgur.com/a/G7VSFO0/</a></p>
<p>Thanks in advance!</p>
https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?comment=161337#post-id-161337I can't solve the problem (my test produces a graph even worse than yours!), but I can suggest un-checking Automatic for the minor interval count and changing the value to "1".Mon, 23 Jul 2018 03:26:19 +0200https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?comment=161337#post-id-161337Answer by Mike Kaganski for <p>I'm trying to create a simple XY scatter that tracks monthly net worth over the course of one year (Y-axis is value, x-axis is each month).</p>
<p>The data source is simple: two rows. Row one is the list of months and row two contains the numeric values ($10, $20, etc.). However, regardless of what I do with the X-axis format, it refuses to stop duplicating month labels.</p>
<p>How can I get the X axis to only have 12 values, labeled by month? Forcing X-axis to start in January and end in December, with a major interval of 1 still gives me duplicated months.</p>
<p>Interestingly, the chart works if it displays the months as simple numbers (1 through 12), but not when it is pulling info from a DATE formatted cell.</p>
<p>Please see the following album for the sample chart: <a href="https://imgur.com/a/G7VSFO0/">https://imgur.com/a/G7VSFO0/</a></p>
<p>Thanks in advance!</p>
https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?answer=161359#post-id-161359It is normal. XY treats its X axis as numerical value, and date is a numerical value with day as the base unit. What you need is Line (Points and Lines) type.
![image description](/upfiles/15323292984177047.png)Mon, 23 Jul 2018 09:01:46 +0200https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?answer=161359#post-id-161359Comment by Kan for <p>It is normal. XY treats its X axis as numerical value, and date is a numerical value with day as the base unit. What you need is Line (Points and Lines) type.</p>
<p><img alt="image description" src="/upfiles/15323292984177047.png"></p>
https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?comment=161435#post-id-161435Can't believe I never thought about changing the chart type! This worked perfectly, thank you. Just changed the type and put the first row in the "categories" field.Tue, 24 Jul 2018 02:32:52 +0200https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?comment=161435#post-id-161435Comment by ve3oat for <p>It is normal. XY treats its X axis as numerical value, and date is a numerical value with day as the base unit. What you need is Line (Points and Lines) type.</p>
<p><img alt="image description" src="/upfiles/15323292984177047.png"></p>
https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?comment=161440#post-id-161440I never thought of it either and I'm not sure I would have. Learn something every day!! Thanks to @mike-kaganskiTue, 24 Jul 2018 04:01:42 +0200https://ask.libreoffice.org/en/question/161329/xy-scatter-keeps-duplicating-x-axis-values-when-pulling-dates/?comment=161440#post-id-161440