Charts

Hi Silviya,

It was nice to meet you on Tuesday's course. Thank you for your contributions to the session.

To create a pie of pie chart, the best way to arrange your data is with your labels down one column and the corresponding values down the next column.

What really helps is when you sort the values from largest to smallest. This way, you group higher and lower values together.

The reason most users want to use a pie of pie chart is to show the lower (smaller) values in the second pie. This is because those slices in the main pie are really small.

Once you have your values sorted, select all the data and insert a pie of pie chart. Initially, Excel might not add all the correct items to the second chart.

To fix this, right-click in the second chart, then select Format Data Series. In the panel on the right, go to the setting 'Split Series By' and select 'Value'. In the 'Value less than' box, set the maximum size for the items you want to show in the second chart.

All data points lower than your set maximum will show in the second chart. Keep adjusting this maximum value until you are satisfied with your chart.

I hope this helps.

Kind regards
Marius Barnard
STL