LibreOffice Calc - plot a basic graph

Solution 1:

Sometimes copying numbers from another softwares into LibreOffice or using other keyboard layouts rather than English make numbers to be seen as numbers but act as text. Hence you won't get your desired charts or calculations. So, first please check your numbers to be numbers rather than text.

If everything is ok with your data, you can draw your graph/chart using XY (Scatter) chart:

Select your data

Picture of data selected in LibreOffice Calc

Then from the Insert menu select Chart. In the Chart wizard window select XY (Scatter) as Chart type and choose the desired chart look on the top right side of window. You can also select Sort by X values checkbox if you want your data to be sorted by increasing the X values.

Picture of Chart wizard dialog in LibreOffice Calc

You can change any other desired options in chart wizard and finally press Finish to see the final chart.

Picture of sample XY (Scatter) chart in LibreOffice Calc