Sant Rawool Maharaj, Mhavidyalay
Subject: Information technology in business
management-1
Project name: Drawing charts
Student’s name: Anamica Bagave
Class: S.Y B.M.S
Roll no: 01
Teacher’s name: Prof.S.S Sawant
Academic year: 2018-2019
Teacher’s signature
DRAWING
CHARTS
INTRODUCTION
It can often be difficult to interpret Excel workbooks that
contain a lot of data.
Charts allow you to illustrate your workbook data
graphically, which make it easy to visualize comparisons
and trends.
Charts are used to display sequence of numeric data.
This numeric data can be represented in graphical form.
This format makes easier to understand huge quantities of
data and the relationship between different sequences of
data.
To create a chart in excel, we have to first enter the
numeric data for the chart on a worksheet. Then we can
plot that data into a chart by selecting the chart type.
TYPES OF CHARTS IN EXCEL
Excel provides you different types of charts that suit your
purpose. Based on the type of data, you can create a chart. You
can also change the chart type later.
1. Column chart
A column chart typically displays the categories along the
horizontal (category) axis and values along the vertical
(value) axis. To create a column chart, arrange the data in
columns or rows on the worksheet.
A column chart has following sub-types:
Clustered column
Stacked column
100% Stacked column
3-D Clustered column
3-D Stacked column
3-D 100% Stacked column
3-D Column
2. Line chart
Line charts can show continuous data over time on a
evenly scaled axis. Therefore, they are ideal for showing
trends in data at equal intervals, such as months, quarters
or years.
A line chart has following sub-types:
Line
Stacked line
100% stacked line
Line with markers
Stacked line with markers
100% stacked line with markers
3-D line
3. Pie chart
Pie charts show the size of items in one data series,
proportional to the sum of the items. The data points in a
pie chart are shown as a percentage of the whole pie. To
create a pie chart, arrange the data in one column or row
on the worksheet.
A pie chart has the following sub-types:
Pie
3-d pie
Pie of pie
Bar of pie
4. Doughnut chart
A doughnut chart shows the relationship of parts to a
whole. It is similar to a pie chart with the only difference
that a doughnut chart can contain more than one series,
whereas, a pie chart can contain only one data series.
A doughnut chart contains rings and each ring
representing one data series. To create a doughnut chart,
arrange the data in columns or rows on a worksheet.
5. Bar chart
Bar charts illustrate comparisons among individual items.
In a bar chart, the categories are organized along the
vertical axis and the values are organized along the
horizontal axis. To create a bar chart, arrange the data in
columns or rows on the worksheet.
Bar chart has the following sub-types:
Clustered bar
Stacked bar
100% stacked bar
3-D clustered bar
3-D stacked bar
3-D 100% stacked bar
6. Area chart
Area chart can be used to plot the change over time and
draw attention to the total value across a trend. By
showing the sum of the plotted values, an area chart also
shows the relationship of part to the whole. To create an
area chart, arrange the data in columns or rows on the
worksheet.
An area chat has the following sub-types:
Area
Stacked area
100% stacked area
3-D area
3-D Stacked area
3-D 100% stacked area
7. XY (Scatter) chart
XY (scatter) charts are typically used for showing and
comparing numeric values, like scientific, statistical, and
engineering data.
A scatter chart has two value axes-
Horizontal (x) value axis
vertical (y) value axis
It combines x and y values into single data points and
display them into irregular intervals, or clusters. To
create a scatter chart, arrange the data in columns
and rows in the worksheet.
Place the x values in one row or column, and then
enter the corresponding y values in the adjacent
rows or columns.
8. Bubble chart
Bubble chart is like a scatter chart with an additional third
column to specify the size of the bubbles it shows to
represent the data points in the data series.
A bubble chart has the following subtypes:
Bubble
Bubble with 3-D effect
9. Stock chart
As the name implies, stock charts can show fluctuations in
stock prices. However, a stock chart can also be used to
show fluctuations in other data, such as daily rainfall or
annual temperatures.
To create stock chart, arrange the data in columns or rows
in specific order on the worksheet. For example, to create
a simple high-low-close stock chart, arrange your data
with high-low and close entered as column headings, in
that order.
A stock has the following subtypes:
High-low-close
Open-High-low-close
volume-High-low-close
volume-open-High-low-close
10. Surface chart
A surface chart is useful when you want to find the
optimum combinations between two sets of data. As in a
topographic map, colors and pattern indicate area in the
same range of values.
A surface chart has the following sub-types:
3-D surface
Wireframe 3-D surface
Contour
Wireframe contour
11. Radar chart
Radar chart compare the aggregate values of several data
series. To create a radar chart, arrange the data in
columns and rows on the worksheet.
A radar chart has the following sub-types:
Radar
Radar with makers
Filled radar
12. Combo chart
Combo charts combine two or more chart types to make
the data easy to understand, especially when the data is
widely varied. It is shown with a secondary axis and is
even easier to read.to create a combo chart, arrange the
data in columns and rows on the worksheet.
Combo charts has the following sub-types:
Clustered column-line
Clustered column-line on secondary axis
Stacked area-clustered column
Custom combination
STEPS FOR CREATING CHARTS
For example in a line chart:
Step 1: Create data set. Select the data set.
Step 2: Click on the insert tab, then in the charts group, click on the line
symbol.
Step 3: Then click on line with marker.
Here our output will be as follows:
CHANGING TYPES OF CHARTS
Step 1: First select the chart.
Step 2: On the design tab, in the type group, click the change chart type
symbol.
Step 3: Select the desired chart and click on ok.
Conclusion
