?
Solved

Excel Chart Bar of Pie Breakout

Posted on 2014-03-21
4
Medium Priority
?
1,699 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 52

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 52

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

765 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