Solved

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

Posted on 2014-09-16
7
1,080 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

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.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 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