You are viewing the article How to Create a 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,495 times.
In this article, WikiHow will show you how to create visual data visualizations in Microsoft Excel using pie charts.
Steps
More data
- If you want to create a chart from existing data, double-click the Excel document containing the data to open it and proceed to the next step.
- For example, if you create a chart for your budget, cell B1 is titled something similar to “2017 Budget”.
- You can also enter a label for clarity in cell A1 – for example, “Budget allocation”.
- For the budget example above, you could write “Car expenses” in cell A2 and then enter “1000 USD” in cell B2 .
- The pie chart templates will automatically determine the percentages for you.
Create a chart
- If your data is in columns marked with letters, numbers, etc. otherwise, click the top left cell in the data group and then click the bottom right cell while holding down ⇧ Shift .
- 2-D Pie – Create a simple pie chart showing color-coded sections of data.
- 3-D Pie – Uses a three-dimensional pie chart that displays color-coded data.
- You can preview the options here by hovering over the different chart patterns.
- To view the Design tab, you must select the chart by clicking on it.
Advice
- You can copy the chart and paste it into other Microsoft Office products (such as Word or PowerPoint).
- If you want to create charts for multiple groups of data, repeat this process for each group. Once the chart is displayed, click and drag the chart out of the center area of the Excel document to prevent the latter from overlapping the previous one.
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,495 times.
In this article, WikiHow will show you how to create visual data visualizations in Microsoft Excel using pie charts.
Thank you for reading this post How to Create a 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: