Solved

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

Posted on 2014-09-16
7
1,031 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
3 Use Cases for Connected Systems

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

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now