InterServer Web Hosting and VPS

How to Create Pie Chart in Excel

We live in a digitalized world. Data has become a part of our lives and a part of business issues. Businesses produce a lot of data on their performance each day, which is why it makes sense to visualize the data in different forms for easy understanding. One such form of data visualization is Pie Chart . Pie Chart can also be considered as a special version of Bar Graph, but differs from the latter on various grounds. In this article, we will understand how to create Pie Chart in Microsoft Excel 2016.

Pie Chart

Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.

To create a pie chart of the 2017 data series, execute the following steps.

1. Select the range A1:D2.

Select Data Series in Excel

https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-1987061359047735&output=html&h=280&slotname=2884421292&adk=3370245685&adf=491445963&pi=t.ma~as.2884421292&w=336&lmt=1636210981&rafmt=12&psa=1&format=336×280&url=https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fpie-chart.html&flash=0&wgl=1&uach=WyJXaW5kb3dzIiwiOC4wLjAiLCJ4ODYiLCIiLCI5NS4wLjQ2MzguNjkiLFtdLG51bGwsbnVsbCwiNjQiXQ..&dt=1636249574455&bpp=6&bdt=1940&idt=7174&shv=r20211103&mjsv=m202111020101&ptt=9&saldr=aa&abxe=1&cookie=ID%3D7bdac4d896077692-22c9baa630cb0073%3AT%3D1636243636%3ART%3D1636243636%3AS%3DALNI_MYSm0cGfe3jzoQeF5_T_QK1Hpy5SQ&prev_fmts=0x0&nras=1&correlator=7537591197617&frm=20&pv=1&ga_vid=13165688.1636243627&ga_sid=1636249582&ga_hid=243897990&ga_fc=1&u_tz=60&u_his=1&u_h=768&u_w=1366&u_ah=738&u_aw=1366&u_cd=24&adx=208&ady=500&biw=1349&bih=635&scr_x=0&scr_y=0&eid=31063183%2C21067496&oid=2&pvsid=3451765735872036&pem=63&ref=https%3A%2F%2Fwww.google.com%2F&eae=0&fc=1920&brdim=0%2C0%2C0%2C0%2C1366%2C0%2C0%2C0%2C1366%2C635&vis=2&rsz=%7C%7CaeEr%7C&abl=CA&pfx=0&fu=256&bc=31&ifi=2&uci=a!2&fsb=1&xpc=w8u8lI2z30&p=https%3A//www.excel-easy.com&dtd=7190

2. On the Insert tab, in the Charts group, click the Pie symbol.

Insert Pie Chart

3. Click Pie.

Click Pie

Result:

Pie Chart in Excel

4. Click on the pie to select the whole pie. Click on a slice to drag it away from the center.

Result:

Exploded Slice

Note: only if you have numeric labels, empty cell A1 before you create the pie chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically creates the correct chart. After creating the chart, you can enter the text Year into cell A1 if you like.https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-1987061359047735&output=html&h=280&slotname=2529116896&adk=2919002958&adf=3372842255&pi=t.ma~as.2529116896&w=336&lmt=1636210981&rafmt=12&psa=1&format=336×280&url=https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fpie-chart.html&flash=0&wgl=1&adsid=ChEI8M-YjAYQ2Ozu7er9wMj6ARI5AKDLW9QVmk8eipVexDl6Fd8tpSitjSdfJz5y0Jsq3R0MemYWTr8BjqikCuh1gthhlwoq6e0S6cve&uach=WyJXaW5kb3dzIiwiOC4wLjAiLCJ4ODYiLCIiLCI5NS4wLjQ2MzguNjkiLFtdLG51bGwsbnVsbCwiNjQiXQ..&dt=1636249574462&bpp=2&bdt=1947&idt=7204&shv=r20211103&mjsv=m202111020101&ptt=9&saldr=aa&abxe=1&cookie=ID%3D7bdac4d896077692-22c9baa630cb0073%3AT%3D1636243636%3ART%3D1636243636%3AS%3DALNI_MYSm0cGfe3jzoQeF5_T_QK1Hpy5SQ&prev_fmts=0x0%2C336x280&nras=1&correlator=7537591197617&frm=20&pv=1&ga_vid=13165688.1636243627&ga_sid=1636249582&ga_hid=243897990&ga_fc=1&u_tz=60&u_his=1&u_h=768&u_w=1366&u_ah=738&u_aw=1366&u_cd=24&adx=208&ady=2062&biw=1349&bih=635&scr_x=0&scr_y=0&eid=31063183%2C21067496&oid=2&psts=AGkb-H9ge-QJu2taCdqWfAkS4EKRuKQ00dimk3yzsrsgtaaIs7PuboHXYLRxi2iM49mInOGYfg5DoKrY6OevHvc&pvsid=3451765735872036&pem=63&ref=https%3A%2F%2Fwww.google.com%2F&eae=0&fc=1920&brdim=0%2C0%2C0%2C0%2C1366%2C0%2C0%2C0%2C1366%2C635&vis=1&rsz=%7C%7CaeEbr%7C&abl=CA&pfx=0&fu=256&bc=31&jar=2021-11-06-18&ifi=3&uci=a!3&btvi=1&fsb=1&xpc=AAFkG4CTwj&p=https%3A//www.excel-easy.com&dtd=43668

Let’s create one more cool pie chart.

5. Select the range A1:D1, hold down CTRL and select the range A3:D3.

Select Non-adjacent Cells

6. Create the pie chart (repeat steps 2-3).

7. Click the legend at the bottom and press Delete.

8. Select the pie chart.

9. Click the + button on the right side of the chart and click the check box next to Data Labels.

Add Data Labels

10. Click the paintbrush icon on the right side of the chart and change the color scheme of the pie chart.

Change Pie Chart Colors

Result:

Pie Chart with Data Labels

11. Right click the pie chart and click Format Data Labels.

12. Check Category Name, uncheck Value, check Percentage and click Center.

Format Data Labels

Result:

Pie Chart with Percentages

Note: right click the data labels and click Font to change the font size and font color of the data labels.https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-1987061359047735&output=html&h=280&slotname=4005850092&adk=660647165&adf=2345183727&pi=t.ma~as.4005850092&w=336&lmt=1636210981&rafmt=12&psa=1&format=336×280&url=https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fpie-chart.html&flash=0&wgl=1&adsid=ChEI8M-YjAYQ2Ozu7er9wMj6ARI5AKDLW9QVmk8eipVexDl6Fd8tpSitjSdfJz5y0Jsq3R0MemYWTr8BjqikCuh1gthhlwoq6e0S6cve&uach=WyJXaW5kb3dzIiwiOC4wLjAiLCJ4ODYiLCIiLCI5NS4wLjQ2MzguNjkiLFtdLG51bGwsbnVsbCwiNjQiXQ..&dt=1636249574464&bpp=2&bdt=1950&idt=7204&shv=r20211103&mjsv=m202111020101&ptt=9&saldr=aa&abxe=1&cookie=ID%3D7bdac4d896077692-22c9baa630cb0073%3AT%3D1636243636%3ART%3D1636243636%3AS%3DALNI_MYSm0cGfe3jzoQeF5_T_QK1Hpy5SQ&prev_fmts=0x0%2C336x280%2C336x280&nras=1&correlator=7537591197617&frm=20&pv=1&ga_vid=13165688.1636243627&ga_sid=1636249582&ga_hid=243897990&ga_fc=1&u_tz=60&u_his=1&u_h=768&u_w=1366&u_ah=738&u_aw=1366&u_cd=24&adx=208&ady=4793&biw=1349&bih=635&scr_x=0&scr_y=2277&eid=31063183%2C21067496&oid=2&psts=AGkb-H9ge-QJu2taCdqWfAkS4EKRuKQ00dimk3yzsrsgtaaIs7PuboHXYLRxi2iM49mInOGYfg5DoKrY6OevHvc%2CAGkb-H97aM1Lxnr5EYs-R1KxwGJbib9fCYlldh1kNtKVwdNZdC9C6yOdswlWEPpQRAnaFU2ZszaTlHB0X5s&pvsid=3451765735872036&pem=63&ref=https%3A%2F%2Fwww.google.com%2F&eae=0&fc=1920&brdim=0%2C0%2C0%2C0%2C1366%2C0%2C1366%2C738%2C1366%2C635&vis=1&rsz=%7C%7CaeEbr%7C&abl=CA&pfx=0&fu=256&bc=31&jar=2021-11-06-18&ifi=4&uci=a!4&btvi=2&fsb=1&xpc=jkS4UrtnLr&p=https%3A//www.excel-easy.com&dtd=49556

Other Method

Conclusions

In the real world, a pie chart is a visual representation in which a circle is divided into slices to illustrate numerical proportion. Pie Chart has been used in various software and devices since long back. But in Excel 2013, Microsoft is displaying a pie chart in a whole new way. Let’s discuss how to create a pie chart easily in Excel.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *