In spreadsheets, you can create graphs to visualize the data better and more transparently. In the section "Insert" you can find the button used to create a chart.
You can add the graph straight to the cell or above them. If you add it above cells, you have more options to show your data.
When you are creating a graph, you need to choose the type of graph you want to use:
Then you need to choose the range of the data that your graph should present and decide if you want to use the left column of your data table as xAxis and whether you want to use the top row as a legend. You also need to decide if you will use your rows or columns as a data series.
Then you can modify your data series in the section "Series":
Here you can choose the range of the series, the color it should have on the graph, whether you want to have visible labels or not, and eventually, the shape of the markers.
Moreover, in the section "Extras" you can choose options for your legend, change the scale, choose the range and title for X and Y axes, the start and end points for the Y axis, and the steps between the following lines.
In the end, you get the chosen graph that presents your data:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article