Solved

Excel Chart Bar of Pie Breakout

Posted on 2014-03-21
4
1,561 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 49

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 49

Accepted Solution

by:
Rgonzo1971 earned 500 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now