Charting Examples using actual COVID-19 Statistics – Pie Chart
Enter the following table into Excel:
Highlight the range A2:B10. Click Insert, Recommended Charts, and select Pie Chart.
A pie chart is a statistical graphic, which is divided into slices which represent numerical proportion.
The chart left as the above is still not providing the user with enough information.
Add chart elements, Data labels and select Outside end.
However, the legend is still not making the chart easy to read.
Add chart elements, Data labels and select More data label options. On the right hand pane. Tick the box next to Category name. Therefore the category name and the value appears next to the pie slice.
You can now click on the legend below and delete this as all the details are shown on the pie chart.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets and Index to Excel VBA Level 1 Free Lessons
Gallery
