Scribd
Upload
38 views4 pages

Creating Bar and Pie Charts in Excel

This document discusses different types of charts that can be created in Excel, including bar graphs, horizontal graphs, pie charts, and line graphs. It provides instructions for creating each chart type in Excel and examples of how they could be used for descriptive or trend analysis of sales data. Bar graphs are used to display large textual labels, horizontal graphs are the horizontal version of column charts, pie charts show the contribution of each value to a total, and line graphs can represent trends over time.

Uploaded by

Djordje
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
38 views4 pages

Creating Bar and Pie Charts in Excel

This document discusses different types of charts that can be created in Excel, including bar graphs, horizontal graphs, pie charts, and line graphs. It provides instructions for creating each chart type in Excel and examples of how they could be used for descriptive or trend analysis of sales data. Bar graphs are used to display large textual labels, horizontal graphs are the horizontal version of column charts, pie charts show the contribution of each value to a total, and line graphs can represent trends over time.

Uploaded by

Djordje
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CHART

A Chart Is A Powerful Tool That Allow You To Visually Display Data In A Variety Of
Different Chart Formats Such As Bar, Column, Pie, Line, Area, Doughnut, Scatter,
Surface, Or Radar Charts. With Excel, It Is Easy To Create A Chart.
Here Are Some Of The Types Of Charts That You Can Create Inn Excel.

Bar graph
A Bar Graph Is A Two Or Three –Dimensional Representation Of
Data From The Simplest To The Most Complex. Use A Bar Chart If
You Have Large Text Labels.
To Create A Bar Chart, Execute The Following Step:-
1. Select The Range Of The Data.
2. On The Insert Tab, In The Chart Group Click The Column Symbol.
3. Click Clustered Bar.

 Descriptive analysis for sales.


CHART
Horizontal graph
A horizontal graph basically a two or three dimensional representation of the [Link] is
the horizontal version of the column chart.

Descriptive analysis for region wise sales (horizontal graph).

Pie chart
A pie chart is a type of graph that displays data in a
circular graph. The pieces of the graph are proportional to
the fraction of the whole in each. In other words pie chart
are used to displays the contribution of each value (slice)
to a total (pie).pie chart always use one data series.
To create the pie chart execute the following steps:
1. Select the range
2. On the insert tab, in the charts group, click the pie
symbol.
3. Click pie
CHART
4. Click on the pie to select the whole
pie. Click on a slice to drag it away
from the center.

Descriptive analysis of sales for each


means (pie chart).

Line graph
A line chart is a graph that shows a series of data points
connected by straight lines. It is a graphical object used to
CHART
represent the data in the excel spreadsheet. You can use a line chart when: you want to
show a trend over a time (such as days, months or years).
To create the line graph execute the following steps:
1. Select the range
2. On the insert tab, in the charts group, click the line symbol.
3. Click line with markers.

Trend analysis of sales for each means (line graph).

You might also like