Hello,
I’m need to create a Line Chat like this:
Note that there are space before and after of X Axis’ values
But, my chart is like this:
I tried to change the scale, it changed the values and it can’t happen.
I think there is an option to get a very near result.
Create line type chart adding a temporary labels and values prior and post the real labels and values for a temporary use, to force calc set properly the data ranges.
Add titles to axis and format X-axis as indicated by oweng, delete Legend.
After the chart is created delete the temporary labels/values .
@marosv - your trick with deleting the first and lost data point AFTER creating the chart is a pretty smart way.
I tried to ncluder empty cells in the data range and Calc neglected always the empty cells. Congratulations!
Thanks for this answer @mariosv. I did not think of manipulating the source data. Very good workaround. You can also edit the Y-axis to reduce the value range to 500-1000 as in the original question (Scale > Minimum / Maximum values).
@_edEr and @owen - I made a test and came to the conclusion that in Calc the chart @_edEr wants is not possible because in a line chart the position of the x-axis categories (15anos, 16anos,…) cannot not be placed between the little labels (little vertical strokes indicating the position of the x-axis values).
In the case of a column chart this is possible and Calc does it automatically.
From the mathematical point of view Calc creates the charts correct.
@_edEr - IMHO your first chart (with the spaces at start and end of the curve) is mathematically not correct for a line chart. The location of the data point (15anos/625) on the x-axis is not precise as it should.
I cannot read the name of the y-axis but I am of the impression that a column chart is mathematically the correct format.
First of all: @ROSt53 and @oweng, thanks for your answer.
This chart is not for me, is for a friend of mine.
About to use columns instead of lines: I tried, but this one still better and clearer. The first chart was made with MS Excel at school. In my home I don’t have it and I’m working in another company nowadays (and using just LibreOffice in both);
About “The location of the data point (15anos/625) on the x-axis is not precise as it should” by @ROSt53: I know that it could be more precise, but is not the idea. This one is just a “figure” for and table that describes all point.
This chart is just to compare 2 competitions, I have to do more 2 charts with the same idea. Untill now, I created as you see (2nd chart) and paste on Inkscape to “beautify”, and I add the spaces there. (is not what I would like to do, but works for now)
Again, I say thanks for your answer.