You are viewing the article How to Create a Bar Chart 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 12,913 times.
This wikiHow teaches you how to present data in Microsoft Excel more eye-catching and engaging with bar charts.
Steps
More data
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/93/Make-a-Bar-Graph-in-Excel-Step-1-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/93/Make-a- Bar-Graph-in-Excel-Step-1-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. Microsoft Excel has an icon similar to a white “E” on a green background.
- If you want to create a graph from existing data, double-click the Excel document containing the data to open it and go to the next step.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d9/Make-a-Bar-Graph-in-Excel-Step-2-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d9/Make-a- Bar-Graph-in-Excel-Step-2-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Blank workbook button (for a normal computer) or click the Excel Workbook button (for a Mac). Located at the top left of the window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/78/Make-a-Bar-Graph-in-Excel-Step-3-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/78/Make-a- Bar-Graph-in-Excel-Step-3-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Add labels to the X and Y axes of the graph. To do this, click in cell A1 (X-axis) and type a label, then do the same for cell B1 (Y-axis).
- For example, a chart that measures temperature for a week would have a “Days” cell in cell A1 and a “Temperature” cell in cell B1 .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b5/Make-a-Bar-Graph-in-Excel-Step-4-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b5/Make-a- Bar-Graph-in-Excel-Step-4-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter data for the X and Y axes of the graph. Enter a number or a word in column A or B along the X or Y axis, respectively.
- Example: Enter “Monday” in cell A2 and “70” in cell B2 , so it can be shown that the temperature reached 70 degrees on Monday.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a9/Make-a-Bar-Graph-in-Excel-Step-5-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a9/Make-a- Bar-Graph-in-Excel-Step-5-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Complete the data entry. Once the data entry is complete, you’re ready to use the data to create a bar chart.
Create a chart
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5a/Make-a-Bar-Graph-in-Excel-Step-6-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5a/Make-a- Bar-Graph-in-Excel-Step-6-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Select all data. To do this, click in cell A1 , hold down ⇧ Shift , and then click the bottom value in column B . That’s it, you’ve selected all your data.
- If in your graph there are various letters, numbers, and so forth, you can also just click on the top left cell in the data group and then click on the bottom right cell while holding down the ⇧ Shift key.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5c/Make-a-Bar-Graph-in-Excel-Step-7-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5c/Make-a- Bar-Graph-in-Excel-Step-7-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Insert tab. Located at the top of the Excel window, just to the right of the Home tab.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8b/Make-a-Bar-Graph-in-Excel-Step-8-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-8-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8b/Make-a- Bar-Graph-in-Excel-Step-8-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-8-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on the “Bar Chart” icon. This icon is in the “Chart” group at the bottom right of the Insert tab; like a series of vertical bars.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/29/Make-a-Bar-Graph-in-Excel-Step-9-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-9-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/29/Make-a- Bar-Graph-in-Excel-Step-9-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-9-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on the bar chart option. There will be many different templates available, depending on your operating system and whether you have purchased an Excel license, but some popular options include:
- 2-D Cpumn – Displays data as vertical bars.
- 3-D Cpumn – Represents data as a three-dimensional vertical bar.
- 2-D Bar – Show data as a simple graph with horizontal bars instead of vertical bars.
- 3-D Bar – Displays data as a three-dimensional horizontal bar.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f1/Make-a-Bar-Graph-in-Excel-Step-10-Version-4.jpg/v4-728px- Make-a-Bar-Graph-in-Excel-Step-10-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f1/Make-a- Bar-Graph-in-Excel-Step-10-Version-4.jpg/v4-728px-Make-a-Bar-Graph-in-Excel-Step-10-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}
Customize chart. Once you decide on a chart format, you can use the “Design” section near the top of the Excel window to choose a different template, change the colors, or change the chart type altogether.
- The “Design” window appears only when you select the chart. To select the chart, click on the chart.
- You can also click on the chart title to select and then enter a new title. The title is usually at the top of the chart’s window.
Advice
- Charts can be copied and pasted into other Microsoft Office programs such as Word or PowerPoint.
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 12,913 times.
This wikiHow teaches you how to present data in Microsoft Excel more eye-catching and engaging with bar charts.
Thank you for reading this post How to Create a Bar Chart in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: