This includes a total of three different tabs: Design, Layout, and Format.Įach tab from the Chart Tools ribbon area will let perform several different customizations. When you have the chart selected (click on the chart), Chart Tools will appear on the ribbon. The next thing we’re going to do is customize the chart to make it more appealing. Now your pie chart should show up on your spreadsheet. Once everything is selected, click the Insert ribbon and then click Pie and select whether you want a 2-D or a 3-D pie and which template. Be sure not to select the cells where you totaled things up. This literally means holding down the left mouse button and dragging a box around the data. Select the data that you want to include in the pie chart. You can make it look snazzy by styling it from the Home ribbon, but this won’t affect our pie chart. This is pretty easy, one column is your description of the numbers, and the other column is your numbers. Update: If you are running modern versions of Excel in the Microsoft 365 (formerly O365) subscription suite, read how to make pie charts in Excel.įirst, you’ll need to write your list of data in Excel. VBA Classes – My Online VBA Training Program 1.Make a Pie Chart in Microsoft Excel 2010 or 2007

If you are wondering how to use these templates, scroll all the way down the post 🙂 More Charting Resources Download the free MS Excel chart / graph templates So that you, the user can focus on your data and not on “why in the world anyone would design a default format like this…”, so go ahead and unleash the charting pro in you.

Move the legend to a meaningful location and adjust its size.

Adjust the fonts (to verdana in this case), remove annoying chart auto-font-scaling.

Change the default grid line format from intrusive solid black to a duller shade of dotted Grey.

Remove that ugly Grey color background from the chart.

These templates will take care of typical formatting activities like, Worry not! for you can become a charting superman (or elastigirl) by using these 73 free designer quality chart templates in literally no time (well, almost) Well, I will tell you my answer, its 293049430493 times 😉 How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore?

How do i make a pie chart in excel 2007