+ Reply to Thread
Results 1 to 2 of 2

Chart

  1. #1
    Registered User
    Join Date
    06-01-2007
    Posts
    2

    Chart

    I have a stack chart with x-axis as the date and y-axis as the # of reviews. Their are 2 types of reviews. I want the data labels to show as percentages of the #of reviews. Please help! I can not figure out how to do it without changing the y axis to percentages as well (not what I need.)

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    A Bodge

    I might have a bodge that could help.

    Set your data series' to display data labels,
    click on a data label, now click again
    (not a double click but two seperate single clicks)
    The data label is now surrounded by a box.

    In the fx box (toward the top of the page) you can now type in anything to replace the label text,

    this includes a cell address so you can use EXCEL to calculate the % for you.

    Mark.

+ 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