VBA Classes – My Online VBA Training Program 1. 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 Now, click 'Insert' and then click on the 'Pie' logo at the top of excel. Then, highlight the data you want to display in pie chart form. 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. Feel free to label each column of data excel will use those labels as titles for your pie chart.

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.

Click on the drop-down menu of the pie chart from the list of the charts.

Change the default grid line format from intrusive solid black to a duller shade of dotted Grey Creating Pie of Pie Chart in Excel: Follow the below steps to create a Pie of Pie chart: 1.

Remove that ugly Grey color background from the chart.

Step 4: Click on the pie icon that is within the 2-D pie icons. Step 3: Now, in the charts group, you need to click on the Insert Pie or Doughnut Chart option.

These templates will take care of typical formatting activities like, Once you have all your data in place, follow these steps to create a pie chart: Step 1: Select the whole dataset. 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?

Create pie chart in excel 2007