Graphs and Charts

A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Pie, Line charts. With Excel, it is easy to create a chart. Here are some of the types of charts that you can create in Excel.


1. 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 category. In other words, each slice of the pie is relative to the size of that category in the group as a whole.



Pie charts to show you how a whole is divided into different parts. You might, for example, want to show how a budget had been spent on different items in a particular year.  
 

  
2. Bar Chart

A bar graph (also known as a bar chart or bar diagram) is a visual tool that uses bars to compare data among categories. A bar graph may run horizontally or vertically. The important thing to know is that the longer the bar, the greater its value. Bar graphs consist of two axes.

Bar graphs to show numbers that are independent of each other. Example data might include things like the number of people who preferred each of Chinese takeaways, Indian takeaways and fish and chips.

Read more at: https://www.skillsyouneed.com/num/graphs-charts.html

Bar graphs to show numbers that are independent of each other. Example data might include things like the number of people who preferred each of Chinese takeaways, Indian takeaways and fish and chips.

Bar graphs to show numbers that are independent of each other. Example data might include things like the number of people who preferred each of Chinese takeaways, Indian takeaways and fish and chips.

Read more at: https://www.skillsyouneed.com/num/graphs-charts.html

 

3. Line Graph

A line graph, also known as a line chart, is a type of chart used to visualize the value of something over time. For example, a finance department may plot the change in the amount of cash the company has on hand over time. The line graph consists of a horizontal x-axis and a vertical y-axis.

Line graphs show you how numbers have changed over time. They are used when you have data that are connected, and to show trends, for example, average night time temperature in each month of the year. 

Trend Graph : 

Trends 

A trend is a pattern in a set of results displayed in a graph.

1. In the graph above, although there is not a straight line increase in figures, overall the trend here is that sales are increasing.

  The trend is that sales are decreasing or dropping.

 WATERFALL CHART

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based.