Question

You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs?

Answer 1

If you want to show your result in proportions then PIE CHART is best for you. It will give you division wise year wise proportions.

Well, we can also use pivot table. But it will not give you proportions it will only give you exact amounts. You can apply multiple filter in it.