How to create a pie chart
The pie chart is used to graph parts of a whole, the total of our numbers must be 100%. The pie chart is, unfortunately, one of the most use charts, you see them often in newspapers and magazines. You shouldn't use them at all, in my opinion, they are hard to read and not that useful.
How to build
- Select the cell range that contains the values you want to chart.
- Go to tab "Insert" on the ribbon.
- Click the "Pie or Doughnut Chart" button.
- Click the "Pie Chart" button.
Improve the pie chart
There are a few things we can do to make the pie chart a little easier to read.
Add data labels
- Right click on chart to open a menu.
- Click on "Add Data Labels".
- Select the data labels and change the font size.
Sort values
- Right-click on one of the chart data source values.
- Click "Sort" then click "Sort Largest to Smallest".
The chart pies are now sorted from largest to smallest and the data labels show how large they are.
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
How to use mouse hover on a worksheet [VBA]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
Change chart data range using a Drop Down List [VBA]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above […]
Color chart columns based on cell color
This article demonstrates macros that automatically changes the chart bar colors based on the corresponding cell, the first example is […]
How to create an interactive Excel chart [VBA]
This article describes how to create an interactive chart, the user may click on a button or multiple buttons and […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
