You are viewing the article How to Draw Charts in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 35,060 times.
In this article, the wikiHow will show you how to draw a diagram or chart in Microsoft Excel. You can draw diagrams from data from the Windows or Mac version of Microsoft Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b7/Create-a-Graph-in-Excel-Step-1-Version-4.jpg/v4-728px-Create- a-Graph-in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b7/Create-a-Graph-in- Excel-Step-1-Version-4.jpg/v4-728px-Create-a-Graph-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. The app icon is a white “X” on a green background.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/06/Create-a-Graph-in-Excel-Step-2-Version-4.jpg/v4-728px-Create- a-Graph-in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/06/Create-a-Graph-in- Excel-Step-2-Version-4.jpg/v4-728px-Create-a-Graph-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on Blank workbook . The option has a white box icon in the upper left corner of the screen.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/01/Create-a-Graph-in-Excel-Step-3-Version-4.jpg/v4-728px-Create- a-Graph-in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/01/Create-a-Graph-in- Excel-Step-3-Version-4.jpg/v4-728px-Create-a-Graph-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Specify the type of chart you want to draw. In Excel there are 3 basic chart types, each of which will fit a data type: [1] X Research Source
- Bar – Displays one or more sets of data in a vertical column. This chart is suitable for showing data differences over time or comparing two sets of similar data.
- Line – Displays one or more data sets as a horizontal line. This chart is suitable for showing the growth or decline of data over time.
- Pie (Pie chart) – Displays one or more data sets as a percentage of the population. This chart is suitable for showing the distribution of data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/08/Create-a-Graph-in-Excel-Step-4-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/08/Create-a-Graph-in- Excel-Step-4-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-4-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Give the chart a title. The header is the individual name of each piece of data, usually located in the first row of the spreadsheet, starting from cell B1 to the right.
- For example, to create a data set named “Number of light bulbs” and another set named “Electricity bill”, you type the number of light bulbs in cell B1 and Electricity bill in C1
- Always leave cell A1 blank.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fe/Create-a-Graph-in-Excel-Step-5-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fe/Create-a-Graph-in- Excel-Step-5-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-5-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Set chart labels. Chart labels to show rows of data in column A (starting at cell A2 ). For example, time data (“Day 1”, “Day 2”, etc.) is commonly used for labeling.
- For example, if you’re comparing your budget with a friend’s on a column chart, you can name each column by week or month.
- You should add a label for each row of data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Create-a-Graph-in-Excel-Step-6-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3c/Create-a-Graph-in- Excel-Step-6-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-6-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter data for the chart. Starting in the cell just below the first heading and just to the right of the first label (usually cell B2 ), enter the metric you want to use to graph.
- You can press Tab ↹ after typing data in 1 cell to enter data and switch to the right cell when you need to fill in data in multiple cells in the same row.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/71/Create-a-Graph-in-Excel-Step-7-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-7-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/71/Create-a-Graph-in- Excel-Step-7-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-7-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select data. Click and drag your mouse from the top left corner of the data group (for example column A1 ) to the bottom right corner, making sure both the title and the label are selected.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2f/Create-a-Graph-in-Excel-Step-8-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-8-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2f/Create-a-Graph-in- Excel-Step-8-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-8-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Insert button. This button is located at the top of the Excel window. This is to open the toolbar below the Insert tab.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a8/Create-a-Graph-in-Excel-Step-9-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a8/Create-a-Graph-in- Excel-Step-9-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-9-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the chart type. In the “Charts” section of the Insert toolbar, click on the avatar that corresponds to the chart you want to use. A menu with various options will appear.
- A bar chart is a series of vertical columns.
- A line chart is a picture of two or more curved lines.
- A pie chart is a pie chart divided into sections.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Create-a-Graph-in-Excel-Step-10-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Create-a-Graph-in- Excel-Step-10-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-10-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select a chart format. In the chart selection menu, click on the chart display version (e.g. 3D ) that you want to use in the Excel document. The chart will be created in the document.
- You can hover over each format to preview how the chart will look as you use the data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c2/Create-a-Graph-in-Excel-Step-11-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-11-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c2/Create-a-Graph-in- Excel-Step-11-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-11-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add a chart name. Double click on “Chart Title” at the top of the chart, then delete the “Chart Title” text and type the name of your chart there, then click in an empty area on the chart.
- On Mac, click the Design tab > Add Chart Element > Chart Title , click the location and type the chart name. [2] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/29/Create-a-Graph-in-Excel-Step-12-Version-3.jpg/v4-728px-Create- a-Graph-in-Excel-Step-12-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/29/Create-a-Graph-in- Excel-Step-12-Version-3.jpg/v4-728px-Create-a-Graph-in-Excel-Step-12-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Save document. You do the following:
- Windows – Click File > Save As , double click This PC , click a storage location on the left side of the window, type the name of the document in the “” field. File name” and click Save .
- Mac – Click File > Save As… , enter a document name in the “Save As” field, choose a save location by clicking in the “Where” dialog box. ” (Location) and click a folder, select Save .
Advice
- You can change the shape of the chart in the Design tab.
- If you don’t want to select a specific chart type, you can click Recommended Charts and select a chart from the Excel rollout.
Warning
- Some chart formats may not display all of the data or display it incorrectly. You need to choose a format that matches the data type.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 35,060 times.
In this article, the wikiHow will show you how to draw a diagram or chart in Microsoft Excel. You can draw diagrams from data from the Windows or Mac version of Microsoft Excel.
Thank you for reading this post How to Draw Charts in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: