Description: 1. Click the "Create Chart" icon. A chart appears 2. Click the "Chart Type" icon. Select any of the "XY (Scatter)" options. A the chart will change to a scatter chart with dates on the X-axis 3. Click the data table icon. Note that there is no X-Axis column. The X-Axis data comes from the row number. Steps to Reproduce: See Desc. Actual Results: There is no way to specify the X-Axis values. Expected Results: Some way to enter X-Axis values. Reproducible: Always User Profile Reset: No Additional Info: Version: 6.1.2.1 Build ID: 6.1.2-1 CPU threads: 16; OS: Linux 4.18; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group threaded
Created attachment 145579 [details] What happens if I import a scatter plot from Calc
Created attachment 145580 [details] what happens if I create a chart in Writer
This chart is only an example. The easiest way to create a chart in Writer is to create a table with your data, select this table and click the icon. That gives you the chart wizard. You can create a XY chart from the default chart but it is not straightforward because this default chart is not designed as XY chart. First you need to change the X-axis format. In the Numbers tab, uncheck "Source format", then you can change the category from Date to Number (for example). Then you can change the chart type to XY and you see numbers on the x-axis instead of dates. Next steps are: edit the data table, remove all data, add series, type values, etc. Does that work for you ? Status set to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided. Best regards. JBF
Hi, thanks for getting back to me on this! > This chart is only an example. The easiest way to create a chart in Writer is to create a table with your data, select this table and click the icon. That gives you the chart wizard. This is interesting, I didn't know about this option. It isn't the most intuitive option, since I don't want a table, I only want a chart, but this is a good workaround. > First you need to change the X-axis format. In the Numbers tab, uncheck "Source format", then you can change the category from Date to Number (for example). Yes, this is true, but this doesn't fix the issue: the row number is now displayed as a number instead of a date, but it still is not possible to enter a x-value. Take a look at the column labels in my 2 screenshots: one has a "Data Labels", "X-Values", "Y-Values"x2; and the other has "Data Labels", "Y-Values"x2.
Did you read and try that: "Next steps are: edit the data table, remove all data, add series, type values, etc." The important words are: "add series". Status set to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided. Best regards. JBF
Yes, "add series" does add a new series with an "x-axis"
(In reply to tamasflaviu from comment #6) > Yes, "add series" does add a new series with an "x-axis" And what happens when you click on the "Insert Series" button? Attached is a screencopy of the result after having clicked this button. Status set to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided. Best regards. JBF
Created attachment 145712 [details] inserting series
(In reply to Jean-Baptiste Faure from comment #7) > (In reply to tamasflaviu from comment #6) > > Yes, "add series" does add a new series with an "x-axis" > > And what happens when you click on the "Insert Series" button? > > Attached is a screencopy of the result after having clicked this button. > > Status set to NEEDINFO, please set it back to UNCONFIRMED once requested > informations are provided. > > Best regards. JBF I should have said "Insert Series" instead of "Add Series". I don't know of any "Add series" button, and my version of libreoffice has a small bug with flickering tooltips that made it hard to read. I get the same results as you did in your screenshot. I do still think this is a usability bug, although it is different from what I initially thought was the problem. It would be nice if, upon changing the graph to scatter mode, all data series were converted to the 2-column X-Values Y-Values style.
This enhancement has been in UNCONFIRMED status for a while, moving it to NEW... Note to the reporter: Changing the status to NEW doesn't mean the enhancement is going to be implemented. In order to do so, either you implement it yourself, you find someone to do it for you or you get professional support < https://www.libreoffice.org/get-help/professional-support/ >