Solved

Excel Chart Bar of Pie Breakout

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

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 50

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

839 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