How Do You Create A Chart In Excel
A picture is worth of yard words; a chart is worth of g sets of information. In this tutorial, we are going to learn how nosotros can utilise graph in Excel to visualize our information.
What is a chart?
A nautical chart is a visual representative of information in both columns and rows. Charts are usually used to analyse trends and patterns in data sets. Let'southward say y'all have been recording the sales figures in Excel for the past three years. Using charts, yous can easily tell which twelvemonth had the well-nigh sales and which yr had the to the lowest degree. You can also draw charts to compare set targets confronting bodily achievements.
We will use the following information for this tutorial.
Note: we will be using Excel 2013. If you have a lower version, then some of the more than avant-garde features may non exist bachelor to you.
Particular | 2012 | 2013 | 2014 | 2015 |
---|---|---|---|---|
Desktop Computers | 20 | 12 | 13 | 12 |
Laptops | 34 | 45 | forty | 39 |
Monitors | 12 | x | 17 | 15 |
Printers | 78 | 13 | xc | 14 |
Types of Charts in MS Excel
Unlike scenarios crave different types of charts. Towards this end, Excel provides a number of chart types that yous can work with. The type of chart that you choose depends on the type of data that you want to visualize. To help simplify things for the users, Excel 2013 and to a higher place has an option that analyses your data and makes a recommendation of the chart type that you lot should apply.
The following tabular array shows some of the almost commonly used Excel charts and when yous should consider using them.
S/Northward | Nautical chart Type | WHEN SHOULD I USE IT? | |
---|---|---|---|
1 | Pie Chart | When you desire to quantify items and prove them equally percentages. | |
2 | Bar Chart | When you want to compare values across a few categories. The values run horizontally | |
3 | Column nautical chart | When y'all want to compare values beyond a few categories. The values run vertically | |
four | Line chart | When you desire to visualize trends over a period of time i.due east. months, days, years, etc. | |
5 | Philharmonic Chart | When you want to highlight different types of information | |
The importance of charts
- Allows you to visualize data graphically
- It's easier to analyse trends and patterns using charts in MS Excel
- Like shooting fish in a barrel to interpret compared to data in cells
Step past step case of creating charts in Excel
In this tutorial, we are going to plot a simple column chart in Excel that will display the sold quantities against the sales twelvemonth. Below are the steps to create nautical chart in MS Excel:
- Open up Excel
- Enter the data from the sample data table above
- Your workbook should now look as follows
To get the desired chart you take to follow the following steps
- Select the information you lot want to represent in graph
- Click on INSERT tab from the ribbon
- Click on the Cavalcade chart driblet downwards button
- Select the chart blazon you want
Yous should be able to see the following chart
Tutorial Exercise
When you lot select the chart, the ribbon activates the following tab
Try to apply the different chart styles, and other options presented in your chart.
Download the above Excel Template
Summary
Charts are a powerful way of graphically visualizing your information. Excel has many types of charts that you tin apply depending on your needs.
Provisional formatting is too another power formatting characteristic of Excel that helps usa easily see the information that meets a specified condition
Source: https://www.guru99.com/visualizing-data-using-charts-in-excel.html
Posted by: dominguesmazing.blogspot.com
0 Response to "How Do You Create A Chart In Excel"
Post a Comment