Help needed : Multiple pie charts for a series

[pumba1991]

The data which we need to present is say, market share of various players for three years. It is possible to have this with excel? The option of making three different pie charts & then placing them side by side is a trick , but not intelligent solution!
Options?

 

[Jon Peltier]

I hesitate to help people with practices which are generally not considered best practices. But the usual problem when dealing with multiple pie charts, is getting the formatting the same in all of them. The easiest way is to make one chart, format it as desired, then freeze formatting changes. Make as mag copies of the chart as needed, and change the source data of the copies.

FWIW, Edward Tufte once said, "the only thing worse than a pie chart is several of them."

 

[pumba1991]

Thanks John! For the kind advise.
That is what is possible today by merely making multiple copies of the pie template & paste them,May not be the best option as there is no option!

I hesitate to help people with practices which are generally not considered best practices. But the usual problem when dealing with multiple pie charts, is getting the formatting the same in all of them. The easiest way is to make one chart, format it as desired, then freeze formatting changes. Make as mag copies of the chart as needed, and change the source data of the copies.

FWIW, Edward Tufte once said, "the only thing worse than a pie chart is several of them."

 

[Jon Peltier]

How many "players" in each pie? If it's more than 2 major and one or two minor, a series of pies will be hard to mentally integrate.

You could try one of these options:

An unstacked line chart
A clustered column chart
A 100% stacked column chart
A 100% stacked area chart