Combining pie charts and scatter plots...

[Kevin Mike]

Is there anyway to plot pie charts on a scatter plot similar in
function to a bubble chart? Put another way if I plot revenue and
margin data on a standard scatter plot, can I turn the data point (or
the "bubble") into a pie chart showing relative market share?

 

[Jim Gordon MVP]

Hi Kevin,

I fiddled with this, but did not find a direct way to accomplish your goal.

However, you can make 2 graphs from the same data then superimpose one upon
the other. Set transparency on the walls and graph elements of the graph on
top so you can see through it and view them both simultaneously.