Want to create comparative pie charts in same chart

Hi Grasor,

first of all, you shouldn't use pie charts for this. Why?

#1: Pie charts with more than two or three wedges are not suitable to compare values. The human eye cannot judge the size of a wedge very well. Use horizontal bars instead, because it's very easy for the eye to see the different lengths of bars.
Your data has 11 data points, which is way too much for a pie chart.

#2: your data shows percentages for the year 1999. If you graph these numbers in a pie chart, you'll have a nice round pie with 10 wedges. But the chart will be misleading, since the numbers add up to only 70% (of the market share, since the category "other" is missing) and the wedges will be bigger than they should. Using a horizontal bar chart, you can leave out any product category without affecting the information value of the chart.

Read up on pie charts on Jon Peltier's blog http://peltiertech.com/WordPress/ and many other good sources on the web.

Your other problem was: how to put two charts into one, so you can easily copy and paste a complete set to Word. You do not have to jump through any hoops to force Excel to make two charts in one panel. Just make two charts, place them side by side, remove the chart borders and create a border on the Excel cells surrounding the two charts. Then, highlight the Excel cells that contain the two charts and copy/paste into Word as one.

HTH