Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1474
  • Last Modified:

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

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
HSI_guelph
Asked:
HSI_guelph
  • 4
  • 2
1 Solution
 
prequel_serverCommented:
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
 
HSI_guelphAuthor Commented:
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
 
prequel_serverCommented:
what year of SSRS are you using?
0
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
HSI_guelphAuthor Commented:
2008
0
 
ValentinoVBI ConsultantCommented:
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
 
HSI_guelphAuthor Commented:
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
 
HSI_guelphAuthor Commented:
Thank you very much for confirming this!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now