 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / April 2008Extra Slice in Pie in Pie chart
I have created a Pie in Pie chart, but excel has added an extra slice in the first chart. And then Excel has taken the data I need for the extra pie, and used that data and the separate date and put them in the other pie chart. How do I get my main date back into the first pie chart and only have the data that shows how the main data is broken down. If you're not too confused, please help. Thanks Hi, Have a read of this article on pie of pies to understand how it works and how you need to setup your data. http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471 Cheers Andy  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info >I have created a Pie in Pie chart, but excel has added an extra slice in >the [quoted text clipped - 6 lines] > > Thanks After reading the article, and following it step by step, I still end up with an extra wedge in the large pie. I only have two set of values I need for the smaller pie, not three. Could that be the problem? > Hi, > [quoted text clipped - 15 lines] > > > > Thanks Hi, The second pie is based on some part of your data and the 'Others' section it represents will automatically be created. It almost sounds like you don't need a pie of pie. Can you provide example of the data/category names you have and what should be in each pie, Bearing in mind the main pie will have to have a minimum of 2 slices. Cheers Andy > After reading the article, and following it step by step, I still end up with > an extra wedge in the large pie. I only have two set of values I need for [quoted text clipped - 19 lines] >>> >>>Thanks SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info I appreciate your advice. In spending quite some time, I realized that the supervisor who had given me the data, had included the data twice; therefore not allowing me to get rid of the extra wedge. Thank you for your help and the article, it was very helpful and will help with other charts. Lisa > Hi, > [quoted text clipped - 32 lines] > >>> > >>>Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.