+ Reply to Thread
Results 1 to 2 of 2

Show Data Lables show Amount & Persentage at the same time

  1. #1
    Registered User
    Join Date
    05-06-2008
    Posts
    55

    Show Data Lables show Amount & Persentage at the same time

    Hi All,

    I have a graph which shows $ amount over a period of years. But I would like the Label on each bar in the graph to show not only the dollar amount, but also the % it represents of the whole for each year. If you don't mind, please see the attached example. In this example 2001 should show labels on the domestic sales as $4,02483, and would also show 84%.

    Does anyone know how to format a chart to show the label in these two different ways?

    Thanks for the help and ideas.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,097
    You can link the data labels to cells, which contain all the information you want to display.

    This addin does all the hard work for you
    http://www.appspro.com/Utilities/ChartLabeler.htm

    I have also tweaked your chart a little to illustrate an alternative to your current layout.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

LinkBacks (?)

  1. Page
    Refback This thread
    10-04-2013, 06:27 AM

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sorting data based on time intervals
    By moonyboy99 in forum Excel General
    Replies: 6
    Last Post: 07-22-2008, 06:23 AM
  2. Assignment overDUE PLEASE PLEASE HELP!!
    By undergrad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2006, 12:34 AM
  3. Changing time format without losing data
    By lajones3 in forum Excel General
    Replies: 19
    Last Post: 11-21-2006, 05:43 PM
  4. time code data formatting
    By exceldoofus in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-18-2006, 03:44 AM

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