Tracy van der Schyff

#Office365Challenge Excel – Pie and Doughnut Charts. The next couple of posts will be all about the charts available in Excel. Today we’ll look at Pie and Doughnut Charts

Now before I talk about inserting a Pie chart, I’d like to share a photo with you. I found this on a site called Information is Beautiful years ago and it has always inspired me to think of data in a different way. Which is most probably why I love Infographics so much. I hope they don’t mind me sharing the photo and all credit to the crazy, amazing artist who came up with this:

Back to Excel:

Highlight the data you want to include in your graph – this should include row and column headings. The title of he graph is never included, it should be added manually.

Click on the Insert Tab (1) and Under Charts / Pie Charts (2), select the type of chart you would like to use. The options include 2-D and 3-D Pie charts as well as Doughnuts. Go to more Pie charts (3) for more options:

Here you can hover over another type to see a preview:

Keep in mind, that once the chart is inserted, you can go to the Design Tab (1), Add Chart Elements (2) to make changes to your chart title, labels and legends:

See you tomorrow for a look at Area Charts.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.