+ Reply to Thread
Results 1 to 2 of 2

Showing persentage as label

  1. #1
    Registered User
    Join Date
    02-22-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Showing persentage as label

    Hi,
    I have a 100% stacked column (which shows bars in the chart( which show me bars (for each month) by deviding each bar in three parts showing the requests served in each month on time, not on time, finished early. Now if for one month i have 4 requests served on time, 4 early and 4 late, my bar is devided in 3 parts equally. If i select value to be showed as label, i can see it but i want to display percentage as label, in this example, i want to see 33% in each part of my bar. Can i do this without first calculating the percentage and mapping to my chart? if yes then how?

    Thanks

    Salman

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Showing persentage as label

    Salman, in general, charts will only show data that you prepare in a table. They can't summarise or calculate.

    For more advice on your issue, please post a sample file and explain what you would like to achieve.

    cheers

+ 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