?
Solved

Excel Chart Bar of Pie Breakout

Posted on 2014-03-21
4
Medium Priority
?
1,776 Views
Last Modified: 2014-03-26
I have a table for which I want to create a pie chart with a further breakout of a single segment to show additional detail.

A sample spreadsheet is attached.

Ideally the purple that's displaying as 'Other' in the chart would be titled 'Central' and the breakout bar on the right would have 4 sections corresponding to the 'Child', 'Other', 'Mother' and 'Interim' that compose the 'Central' pie segment.

How can the data be setup differently to attain this result?  Am I missing something in the chart settings or data selection?

Secondly, is it possible to have breakouts on two of the larger pie segments on one graph?

I'd be appreciative of any help.


Thanks,

Artie
Sample-Chart-Book.xlsx
0
Comment
Question by:Rick_Preiss
  • 2
  • 2
4 Comments
 
LVL 54

Expert Comment

by:Rgonzo1971
ID: 39945576
Hi,

Could you explain tell which cells (with address eg B2) should be in the pie chart and which in the bar chart keeping in  mind that the bar chart represents one of the element of the pie chart.

Regards
0
 

Author Comment

by:Rick_Preiss
ID: 39945605
I'm looking for the sum of all the columns B:D in the pie and the breakout of one of those columns, D2:D5 in the bar.

Is there not a way to create a pie segement from the sum of one column without using a sum data row?
0
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39945712
Hi

the chart is thought to use the bar char to distinguish Others if too small

but you can do what you want by getting the data in line

example in file

 

You will have to change the label text for Others to Central and split the serie for the last 4 items

Regards
ChartEE20140321.jpg
Sample-Chart-BookV1.xlsx
0
 

Author Closing Comment

by:Rick_Preiss
ID: 39958093
Thanks!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question