Solved

Excel Chart Bar of Pie Breakout

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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