+ Reply to Thread
Results 1 to 2 of 2
  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
    2003 & 2007 & 2010
    Posts
    10,944
    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

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, 07:23 AM
  2. Assignment overDUE PLEASE PLEASE HELP!!
    By undergrad in forum Excel Worksheet 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 Worksheet Functions
    Replies: 10
    Last Post: 10-18-2006, 04: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.2.0