Data Visualization Assignment: Excel Charts and Data Interpretation

This assignment demonstrates the creation and interpretation of various charts in Microsoft Excel, including column, bar, and pie charts. The solution begins by differentiating between column and bar charts, followed by the creation of column charts to visualize retail prices of grocery products, sales data of different product categories, and employee salary and age data. Pie charts are utilized to present the final test outcomes of students in mathematics and computing. The analysis includes comparisons between different data sets, such as comparing student performance in both subjects and highlighting the relationship between employee age, position, and salary. The assignment emphasizes the use of charts for data visualization and drawing meaningful conclusions from the presented data, providing a clear understanding of the data trends and relationships. References to external sources are also included. This solution is provided by a student and is available on Desklib, a platform offering various AI-based study tools for students.

CHARTS AND ANALYSIS

TABLE OF CONTENTS
1. Difference between column and bar chart..........................................................................1
2. Enclosed in excel sheet.......................................................................................................1
3. Creating column chart........................................................................................................1
4. Creating column chart with sales of every category..........................................................2
5. Creating column chart........................................................................................................2
6.1 Creating pie chart.............................................................................................................3
6.2 Creating column chart......................................................................................................4
REFERENCES................................................................................................................................5

1. Difference between column and bar chart
The column and bar chart both reflects data with application of rectangular bars which is
proportional to data value. However, its variation is in orientation as bar chart is designed
horizontally and column chart is vertically oriented (Column graphs vs. bar charts, 2019).
2. Enclosed in excel sheet
3. Creating column chart
In the above graph, cost and retial price has been plotted of various grocery products such
as cereal, milk, eggs, cheese, meat, pasta and juice whereas meat is very expensive among all
products. It has been observed that retail prices for each good is more than its cost price and
which good has the lowest or highest price.
1

4. Creating column chart with sales of every category
In the above chart, sales of each product is plotted with reference to number of units, list
price and discount given on every product. It had been clearly observed that health and beauty
products are leading and has list price of 800 with maximum discount of 100. The summer
clothes are least sold product as there listed price is 560 and discount of 30.
5. Creating column chart
2

The employees age, position and salary has been reflected, IT head has the highest annual
salary along with his age and experience because of highly qualified skills. In the same series,
administrator has the lowest annual salary and age. Further, Sarah and Tim both have similar
designation as QA executive and of same age profile but there annual compensation is different
as it might be due to experience and skills. Shaun is programmer of 34 age and annual salary is
of 28000 and Adam as IT specialist with 36 age with approx. similar salary of 35000 which is
appreciable.
6.1 Creating pie chart
In this pie chart, final test outcome of maths has been reflected of every student as Cloe
has attained highest marks as 90 and followed by Sarah and David among entire class and Simon
is at lowest with 55. In this subject, majority of students had attained more than 50%.
3

In this pie chart, final test outcome of computing has been reflected of every student as
Adam has attained highest marks as 85 followed by David and Cloe among entire class and
Simon is at lowest with 63. However, it could be evaluated that Simon is not laying focus on its
academics tutor could not be blamed.
6.2 Creating column chart
In the above scenario, final test results of both subject has been plotted which shows that
students have prepared very well as majority students gained more than 60% which is
appreciable. With other perspective, there turors are also giving high efforts which leads to great
performance. Furthermore, in computing students are highly efficient as compared to maths
majorly and it had been observed that Simon who hat attained highest marks in maths had gained
3rd position in computing. On the contrary, Adam had attained highest marks in computing is at
4th position in maths. While considering there aggregate, Cloe is at 1st positiion and David and
Sarah has maintained appropriate balance in both subject whereas they gained 2nd and 3rd position
respectively.
4

REFERENCES
Online
Column graphs vs. bar charts. 2019. [Online]. Available through <
https://www.thinkoutsidetheslide.com/column-graphs-vs-bar-charts-when-to-choose-each-
one/ >.
5