+ Reply to Thread
Results 1 to 3 of 3

pie cchart data labels

  1. #1
    Forum Contributor
    Join Date
    05-13-2009
    Location
    London, England
    MS-Off Ver
    Excel XP
    Posts
    174

    pie cchart data labels

    Hi,

    I have this problem where the data labels in the pie shift in weird ways and are difficult to read. Data is dynamic, and charts automatically get updated everyday, which is why the data labels move around everyday creating this problem.
    Is there a macro that can be written to always keep data labels at a certain spot realtive to its portion of the pie?

    any suggestions would be great

    thanks

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: pie cchart data labels

    Hi,

    I'm afraid I can't help you with a macro, but your problem is one of the operational reasons why pie charts are bad. There are lots of other reasons to avoid pie charts and create bar charts instead. See this recent blog post from Jon Peltier ... http://peltiertech.com/WordPress/pie-chart-quiz/ and check out his other articles and tutorials. Might be an eye opener .

    cheers

  3. #3
    Forum Contributor
    Join Date
    05-13-2009
    Location
    London, England
    MS-Off Ver
    Excel XP
    Posts
    174

    Re: pie cchart data labels

    very interesting articles there, thanks for the link...
    bar charts are definitely more useful, but what can we do sometimes clients love these silly pie charts

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1