Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2015, 08:57 PM
chickasaw chickasaw is offline Pie chart showing more than one data label Windows XP Pie chart showing more than one data label Office 2007
Novice
Pie chart showing more than one data label
 
Join Date: Feb 2010
Posts: 4
chickasaw is on a distinguished road
Default Pie chart showing more than one data label

I have a pie chart that is showing one of the slices with 3 different leader lines pointing to a single slice. The data it's pulling from in Excel 2010 is correct. Two of the leader lines should be pointing to different slices of the pie.



There are two slices of the pie with no data label and when I hover over them it's showing the values that is pointing to the wrong slice with the 3 different leader lines. So all the slices are there, just incorrect data labels/leader lines identifying the slices.

I can't figure out where to correct this. This is a pie chart that I have used several times with no problems.

Thank you for any suggestions you may have!
Reply With Quote
  #2  
Old 03-10-2015, 07:12 AM
gebobs gebobs is offline Pie chart showing more than one data label Windows 7 64bit Pie chart showing more than one data label Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Please attach your sheet.
Reply With Quote
  #3  
Old 03-10-2015, 07:27 PM
chickasaw chickasaw is offline Pie chart showing more than one data label Windows 7 64bit Pie chart showing more than one data label Office 2010 64bit
Novice
Pie chart showing more than one data label
 
Join Date: Feb 2010
Posts: 4
chickasaw is on a distinguished road
Default Pie Chart slices

I figured it out. The slices were too small. In 3D (exploded) it looks wrong. Using a 1D pie chart the leader lines are pointing to the correct slices. This particular pie chart has 25 slices and I wonder if there is a limit to how many slices a 3D pie chart can support. Also, the leader lines points to the side, lower point of the pie and you cannot see the precise point where it's pointing since the slices are too small. Another work around was to remove the problem data labels and insert text boxes and place where needed.
Reply With Quote
Reply

Tags
data labels, leader lines, pie charts



Similar Threads
Thread Thread Starter Forum Replies Last Post
place a label for special point in a chart expert4knowledge Excel Programming 0 01-02-2015 05:46 AM
How to add data label individually in a stacked-bar chart? officeboy09 Excel 0 10-17-2013 01:26 AM
Display a label character in a data cell markg2 Excel 9 09-07-2013 05:56 AM
Showing unscheduled tasks on Gantt chart jaworski_m Project 0 11-20-2011 12:37 AM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft