+ Reply to Thread
Results 1 to 4 of 4

Percentage bar chart in Excel 2010

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Percentage bar chart in Excel 2010

    barchart.xlsxHello,
    Im looking to create a bar chart in Excel 2010 where the totalnumber of widgets is 33 and the number produced so far is 11. The bar chart would be a single bar that represents the percentage complete (33%) with the chart maximum range being 100% which would represent the number 38.

    Ive included a mock up example of what the data and chart would look like

    Thanks so much
    Last edited by Victor Borzoi; 03-19-2013 at 09:43 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Percentage bar chart in Excel 2010

    Maybe use the 100% stacked column chart.

    Confused as to where 38 comes from, or is that just a typo of 33?
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-12-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Percentage bar chart in Excel 2010

    My bar chart is not working correctly. If I have 11 complete of a total of 33, the percentage should be 33%, likewise 25 complete out of 100 should be 25%, etc.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Percentage bar chart in Excel 2010

    You need to calculate the value and use a cluster column chart with the overlap set to 100%
    Attached Files Attached Files

+ 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