+ Reply to Thread
Results 1 to 2 of 2

Reformatting data labels for Excel pie charts

  1. #1
    Registered User
    Join Date
    12-20-2005
    Posts
    69

    Reformatting data labels for Excel pie charts

    Hi, I was wondering if there is any way that I can present data labels for a series within a pie chart in the following format:

    [Category Name] ([Value]) [Percentage]

    So an example would be:

    New Business (120) 64%

    I have looked within the options and it only seems to give you the option to separate by comma or space etc, I can't seem to find a way to put brackets just around the value part. Is there a way around this? Also, is there any way to put a formula within a chart title?

    Thanks,

    Ben

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Reformatting data labels for Excel pie charts

    Simplest thing to do is use formula to build the required information and use that as the category labels.
    Then you just use normal data labels and display Category.

    Rather than formula in title you link the title to a cell. The cell contains the required formula.
    http://www.andypope.info/tips/tip001.htm
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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