I’m finding it very difficult to make a very simple chart. I have two data columns that I have selected, then I go to the chart symbol and select the type of the chart (bar chart) and then click on “first column as axis label”, the result is that there is an empty chart, where the label of the axis is a combination of the first and second column by row. Obviously I want one row to be the x axis and the other row to be the other axis. When I go to data series it’s empty. I’m really not understanding what’s wrong, and by the way, this seems so user unfriendly.
Bar charts only have one value axis (horizontal) while the other axis has “categories” classes for which one row or column of your source range is used to get designators. These are not interpreted as numbers even if they are numeric.
If I create a bar chart regarding these facts, I don’t experience any problem.
To explain your issue to more detail, please attach an example spreadsheet demonstrating it.
See also:
simpleBarChart.ods (18.1 KB)
BaseMunicipioTaxaAnr.ods (20.5 KB)
Hey, thanks for the quick reply, I saw your example and what I’m trying to do is a chart that has the horizontal axis as “categories” and the other one as values. This is the table I’m using, basically I’m trying to make a chart out of column C and H.
All your “values” seem to be text. What language settings did you use? When I open the sheet, the cells’ language (for number recognition) is Default - English(UK)
, but this setting requires to use the point as the decimal separator.
Regarding the content I would assume your setting for the cells (not necessarily for the UI or otherwise) should be Portuguese (Brazil).
To convert erronously imported text expected to be interpreted as numbers, I used the F&R tool with RegEx. Other means available.
See attached result:
BaseMunicipioTaxaAnr_returned.ods (21.7 KB)
Hey thanks again for the effort. I changed the laguage to Portuguese and marked all the columns, but in “data series” column C and D do not even appear, so I’m again not getting the result I want. Using the graph you sent me, I could actually make a chart similar to what I intended, but it would be nice to understand how to do it.
BaseMunicipioTaxaAnr.ods (20.2 KB)
Please be sure that my comment is not intended to sound unkindly. (I’m not a native speaker of English.)
The thread is touching more than one very fundamental aspects of the usage of Calc.
The basics like the need of distinguishing text from numbers, and the effects of language settings should be explained in the guides and can’t be teached privatissime to every new user
How charts can be created and edited is also described in the Calc guide.
Study the new attachment and the explanations contained therein. I can’t offer more support.
simpleBarChartIterum.ods (96.7 KB)