+ 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

    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
    Essex, UK
    MS-Off Ver
    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

    I have also tweaked your chart a little to illustrate an alternative to your current layout.
    Attached Files Attached Files

+ 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


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