This simplifies the pie, while the viewer can still see what the smaller sizes comprise of.įor example, in the chart shown below, the larger slices are visible in the main pie, while the smaller ones are grouped together into a single pie and then projected onto a bar chart, where you can still see the individual portions. However, as the number of categories increases, the pie chart starts becoming too complex to read.Ī ‘Bar of pie chart’ can be quite useful in such cases, as it lets you move the smaller slices of the pie to a separate stacked bar chart.
How to Convert a Pie Chart to a Bar of Pie ChartĪ pie chart is the best option when you want to visualize portions of a small number of categories (around 2-5).Benefits of Using a Bar of Pie Chart in Excel.
0 kommentar(er)
