ST.
XAVIER’S COLLEGE (AUTONOMOUS), KOLKATA
Department of Information Technology
B. Com Semester III
IT Skills for Business Practical 2024 under NEP 2020
Unit 3: Business Data Visualization and Dashboard Creation
Topics Covered: Creating, Formatting and Customizing Charts
(Bar, Column, Line, Pie, Scatter, Pivot)
Assignment 6
The objective of this practical assignment is to equip students with the skills necessary to effectively
visualize business data using various types of chart. Students will learn to create, format, and customize
bar, column, line, pie, scatter, and pivot charts to represent data distributions, trends, and comparisons. This
includes understanding how to select appropriate chart types, apply design elements, and utilize advanced
features for clear and more impactful presentation of data. This assignment enables students to be
proficient in using visualization tools of Spreadsheet to analyze and interpret business data.
Open a blank workbook and save it as Spreadsheet6_rollno.xlsx in your folder.
Bar Chart:
1. XYZ retail store recorded the sales data of different categories of items during the
last week. Add the following data in barchart_rollno sheet.
Items Sold Sales (INR)
Electronics 500000
Apparels 100000
Toys 22000
Sports Items 50000
Furnishing 150000
Home Decor 750000
Books 40000
Stationaries 5500
a. Compare sales data for different categories items sold using bar chart.
Format and label the chart.
b. Also, visualize the above data using column chart.
Line Chart:
2. Add the following region-wise monthly revenue data from January to May in
linechart_rollno sheet.
Jan Feb Mar Apr May
North 1300000 1450000 1200000 1500000 1350000
South 8500000 8750000 900000 1000000 950000
East 1000000 900000 1100000 950000 1000000
West 920000 1000000 1050000 1000000 1100000
• Analyze region-wise monthly revenue trends from January to May using line chart.
[use line with markers and do the formatting as required ].
Pie Chart:
3. A company lists the market share percentages of the following products: A,B, C, D,
E. Add the following data in piechart_rollno sheet.
Page 1 of 2
ST. XAVIER’S COLLEGE (AUTONOMOUS), KOLKATA
Department of Information Technology
B. Com Semester III
IT Skills for Business Practical 2024 under NEP 2020
Products Market Share(%)
A 27
B 8
C 20
D 35
E 10
• Show the market share (%) of different products using pie chart and do the
formatting as required.
Scatter Plot:
4. Add the following data in scatterplot_rollno sheet.
Year advertising expenses(X) number of items sold(Y)
2016 2500 800
2017 1500 900
2018 3200 750
2019 1800 950
2020 2504 670
2021 1965 1000
2022 3000 1200
2023 2200 1468
2024 2309 1300
• Visually display the relationship between advertising expenses and number of
items sold using scatter plot and do the formatting as required.
Pivot Chart:
5. Consider the project categories and sum of quarter 2(q2) revenue. Add the
following data in pivotchart_rollno sheet.
• Analyze quarter 2 revenue by project categories using pivot chart.
Reference Links:
[Link]
8a73-
b3fd5d5680c2#:~:text=Select%20data%20for%20the%20chart,best%20chart%20for%20the%20data.
********************************************************************************************
Page 2 of 2