Created attachment 170219 [details] Image of problem Column Chart Bugs: 1) Does not show X-axis selected values (1-11 is wrong, should be -2.5 -2 ...)? 2) Fails to take ranges as series arguments (displays range name Tfrequency in orange) 3) Cannot edit source of X-axis values
Created attachment 170220 [details] Spreadsheet containing example
I forgot, one more bug: 4) Using first row of column does not seem to work...
Typo, try again: 4) Using first row of column as label does not seem to work.
Created attachment 170222 [details] ODS corrected with Excel now displays as intended
The problem is with labeling of x-axis. If you don not specify a range to be used for labeling of the categories, Calc just numbers labels (and hence categories) using integer values. Do the following: - Double click the chart (Edit mode) - Right click and select Data Ranges -> Tab: Data Series - In field "Categories" select $Sheet1.$H$21:$H$31 - Click OK and you see the same result as per Excel. Therefore: Not a bug
Created attachment 170585 [details] Modification of sample file for NAB reasoning Please see the attachment, which is a modification of the ODS sample file by means of LibreOffice.
Thanks Uwe for explaining (1) - how to get the x-axis numerical labeling sorted (). It is incredibly well hidden... Can you address the other issues, especially (2). Input a range name for one of the series data range, and you'll see it accepts the name, shows it in orange, but does not work. Thanks!
(In reply to Dave Nadler from comment #7) > > Can you address the other issues, especially (2). > Input a range name for one of the series data range, 2) You cannot use named ranges in charts. It is not supposed to work and there is no documentation stating that this can be done. Hence the lack of this functionality is not to be considered a bug but qualifies for an enhancement request. However, such request already exits - see tdf#66250 "Use a Named range as data source for Chart" (Aside: This also shows, why you should file one bug report per problem and not using kind of a collective bug report summarizing multiple problems within a single bug report) 3) Obviously a sonsequence of you initial problem unter 1). If you do not define a data range for the categories and leave it to LibreOffice to number categories, then there is of course no way to change 'em. If you define the categories as explained in my previous comment, then you can edit them.