0:00
Most people think pie charts are limited to a single set of values
0:03
but here is a way to create a pie chart based on two or more columns of values
0:08
To see how this works, follow these steps. First, select the range and insert a pie chart
0:15
Right-click on the pie and select Format Data Series. This action will open the Format Data Series pane
0:21
In the Series Options section, choose the secondary axis radio button. Then use the pie explosion slider to set the explosion to 40%
0:29
It creates a separated pie effect. Now, select each slice of pie in turn and drag them back to the center of the pie
0:36
Remember that two slow clicks will select an individual piece of the pie. Now, click on the outer part of the pie and
0:43
In the Format Data Series, choose the secondary axis radio button and adjust the pie explosion slider to 150% to create a separated pie effect
0:53
This action reduces the pie's size while separating the slices. Again, select each slice of newly exploded pie in turn and drag them back to the center of the pie
1:02
To improve the visibility of a pie chart, you can adjust the angle of first slice slider for each series in the Format Data Series pane
1:10
This allows you to rotate the slices for better clarity and presentation. Thank you for watching my tutorial
1:17
If you found it helpful, please like, subscribe, and share my video with others
