Pie of Pie Chart

G

GSingh

Here is the dat
Above A- 6.3
BBB- to BBB+ 8.0
Below BBB- 27.9
Non Rated 57.8
Investment Grade 16.4
Non-Investment Grade 83.6

The last two are to be shown on the second chart of pie of pie chart. I tried but it created a new category "other" on its own in the first chart. Can some one tell me how to do it right? OR is it a glitch in EXCEL
 
T

Tushar Mehta

XL works as intended. Once the pie-of-pie chart is created, double-
click the plotted series in the chart. In the resulting dialog box,
select the Options tab. With the 'Split series by' set to Position,
set the number of positions to 2.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top