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.
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
- 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.
- 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 .
- Example: Enter “Monday” in cell A2 and “70” in cell B2 , so it can be shown that the temperature reached 70 degrees on Monday.
Create a chart
- 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.
- 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.
- 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.
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: