1,325
edits
Changes
Jump to navigation
Jump to search
Line 158:
Line 158: − + − + + +
→Preparing charts and graphs
File:LO_Calc_8_Graph_of_rainfall_with_data.png|Inserting charts
File:LO_Calc_8_Graph_of_rainfall_with_data.png|Inserting charts
</gallery>
</gallery>
#Select the data (columns A and B) and select "Insert --> chart" option. You will get the chart wizard. You can select Bar chart to get a Bar chart of the rainfall. You should experiment with different graphical formats to learn.
#Select the data (columns A and B) and select "Insert --> Chart" option. You will get the chart wizard. You can select Bar chart to get a Bar chart of the rainfall. You should experiment with different graphical formats to learn about all the other charts.
#Inserting charts - You can prepare charts and show it alongside the data
#Choose the Data Range. In this example it is A2 to B15.
#Click on "Data series" column name on the left and on the right side modify the "Range for name" as done in the above image (Data Series image). At first it will show you the name of the column as "Column B". But if you want to modify it as the name of the column as mentioned in the spreadsheet then click on the "Name" in the "Data Ranges" table. Click on small icon which says "Select Data Range" --> A small window appears where you must click on the Column B1. Automatically it will consider the clicked column as the name for that field. Click "Next".
#In the Last window Give the title if you want it to be appeared on the top of the chart. Click "Finish".
==== Working with Pivot tables ====
==== Working with Pivot tables ====