Hello all,

I am trying to put together two pie charts to represent sales for two corresponding years. One year has higher sales than the other, and I would like to show that with the physical size of the pie charts. Is there an easy way to have the diameter or total area of a pie chart correspond to a specific number?

For example, if the sales for year 1 were $200 million and sales for year 2 were $100 million, is there a way to make chart 1 appear exactly 2 times larger (area) than the pie chart for year 2?

It sounds simple, but some searching on the internet has made it sound like this is not easy to do. Thank you for any help!