Join Now: [Link] Downloaded from [Link].
in ®
Practicals 2022-2023 LibreOffice Calc
PRACTICAL - 8
Preparation of Pie Chart
Draw a PIE CHART for the following data on Vehicles registered in the Motor
Vehicles Department during 2021-2022 in a city.
Vehicle AUTO TWO HEAVY
BUS TRUCK CAR
Type RICKSHAW WHEELER VEHICLE
No. of
1710 6500 14000 11000 28000 995
Vehicles
AIM
To prepare a PIE chart by using LibreOffice Calc spreadsheet
PROCEDURE
Step 1 : Open LibreOffice Calc spreadsheet
Applications → Office → LibreOffice Calc
Step 2 : Enter the given details in respective cells as below:
Step 3 : Select the data range A1:G2 to prepare Column chart.
Then Go to INSERT Menu → CHART
Prepared by Harikumar.A, HSST HG Commerce, V.V.H.S.S, Thamarakulam, Alappuzha Dist:
Join Now: [Link] Downloaded from [Link] ®
Practicals 2022-2023 LibreOffice Calc
A Chart Wizard window appears.
a) Chart Type: Here select the chart type as PIE Chart. Click Next button
b) Data Range : (A1:G2 range already selected) Click Next button
c) Data Series : (Here we can customise data ranges for individual data series) Click
on Next button
d) Chart Elements : Title, Legend and Grid Settings
Title : VEHICLES REGISTERED
Subtitle : 2021-2022
and click FINISH button to insert chart
OUTPUT
harikumarmavelikara7@[Link]
Prepared by Harikumar.A, HSST HG Commerce, V.V.H.S.S, Thamarakulam, Alappuzha Dist: