Hi,
He maybe confusing the Pie of Pie chart type and bubble charts.
Anyhow the relationship described is not a built-in feature of any chart.
Using pie charts is not normally a good idea but to then size on against
another make the problems of reading pies even worse.
Cheers
Andy
MK wrote:
I have a boss that insists that it is possible to create a pie chart, and
then create another chart that is to scale of that chart. For example, I am
attempting to create a chart about revenues. Revenue essentially increased
52% between 2007 and 2008. He wants me to create a pie chart for 2007, and
then another chart for 2008 that is exactly 52% bigger. Is this possible to
do automatically? I feel like it isn't, but he is really stressing that it
has to be possible.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info