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
Solved

Move the position of the data label inside the pie slice?

Posted on 2014-09-16
7
1,129 Views
Last Modified: 2014-09-17
Is it possible to move the position of the label within the pie slice?  Being in the middle of the slice makes the labels overlap and hard to read, as seen below.  If the labels could be shifted towards the outside of the slice there would be less overlap.  I've tried putting the labels outside the slices and they just look like a warped spider.   on the Chart Series Labels properties I found an attribute after Font that is called Position and it seems like that would be what I need.  But the options don't seem to do anything, except for Outside which moves the labels outside the chart like the demented spider.  

All replies are greatly appreciated!!

pie chartChart Series Label properties
0
Comment
Question by:HSI_guelph
  • 4
  • 2
7 Comments
 
LVL 3

Expert Comment

by:prequel_server
ID: 40325527
On the design surface, right-click the chart and select Show Data Labels.
Open the Properties pane. On the View tab, click Properties.
On the design surface, click the chart. The properties for the chart are displayed in the Properties pane.
In the General section, expand the CustomAttributes node. A list of attributes for the pie chart is displayed.
Select a value for the PieLabelStyle property.
0
 

Author Comment

by:HSI_guelph
ID: 40325994
I have the Properties window open and pinned by default.  The chart doesn't have a CustomAttributes node.  The Chart Series does but the only options are Inside, Outside, Disabled and an Expression.
0
 
LVL 3

Expert Comment

by:prequel_server
ID: 40326041
what year of SSRS are you using?
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 

Author Comment

by:HSI_guelph
ID: 40327991
2008
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 40328043
As far as I know this is not possible.  The "outside" setting is about the only option to keep the labels readable on a pie, and that indeed looks like a weird spider.

But... have you considered using a different type of chart, such as column chart?  Pie charts are not the best invention as far as data analysis is concerned.  Well, there are some situation were they do serve their purpose.

The following (incl. the links in the intro of the article) should be an interesting read if you're interested in optimizing your data visualisation skills: Why Tufte is Flat-Out Wrong about Pie Charts
0
 

Author Comment

by:HSI_guelph
ID: 40328888
I'll check out that article, thanks!  I thought a pie chart would be good when comparing sections of a larger item in percentages.  Such as how an employee's billable hours are broken up between various projects.  A table can say you spent 80% of the last month working on Project X but a pie chart sums it up so nicely.  I am to start looking at 2012 and how upgrading will affect my reports so I hope maybe it will be possible in that version.
0
 

Author Closing Comment

by:HSI_guelph
ID: 40328892
Thank you very much for confirming this!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 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