Using slices instead of pies is another simple and intuitive visualization trick. Just make all the X and Y co-ordinates as same. Change the X and Y co-ordinates to align the bubbles at bottom.Ĭoncentric circles can be a good alternative to pie chart and they are very easy to do using excel’s built in bubble chart. Convert the pie values in to a bubble chart.

You can do them by using Excel’s bubble chart.

Here we will see 9 creative ways to alter your pie charts so that they can start a conversation.īottom aligned bubbles are a new fad in visualization. Well, you don’t really want them to like your charts, you want them to like your insights, your ideas.īut, to get there, you need to shake up your audience, so that they take notice of what your charts are saying.Ī simple trick for achieving this is showing charts in different formats (while retaining the meaning). You thought your audience are going to love it.īut your pie charts failed to evoke any response. You have included several pie charts since they are easy to digest. You have analyzed the data so well to arrive at some really amazing conclusions. Our learners tell us that they save an average of 32 minutes a day with our Excel training courses.You have made an impressive presentation with lots of data and charts. Our next available online course is on 21st March and our next classroom course is 4th April.

Wanting to analyse Excel data more effectively? We have an intensive full-day Advanced Excel Level 3 course.

The next available online course is 23rd February, or join us in the classroom on 22nd February.

If you are comfortable with using Excel and creating formulas, take a look at our Intermediate Excel Core Level 2 course.

Join us online on the 14th March or in the classroom at Happy on 24th February.

If you are new to Excel, take a look at our Beginner Excel Core Level 1 course.

And our new online learning programme is just as interactive as our classroom sessions. Happy has high-quality, learner-focused Excel training courses for all skill levels, designed to improve your confidence and productivity. Improve your productivity in Excel with happy

Create pie chart in excel 2016