+ Reply to Thread
Results 1 to 5 of 5

Progress bar chart

  1. #1
    Registered User
    Join Date
    05-20-2021
    Location
    Bahrain
    MS-Off Ver
    Office 16
    Posts
    3

    Progress bar chart

    Hi,

    I'm trying to create progress bar chart in excel. So it will look like a progress bar of achieved amounts (colored in blue) overlapped with total amounts (colored in grey). The blue bar will be shorter than the latter and will be on top of the grey bar.

    The details are as follows:

    The vertical axis has 10 categories/titles based on the following:
    Series A is the values of achieved amounts (e.g. 23% 61%), linked to B1:B10 and is colored in blue
    Series B is the total amount (100%), linked to B11 and is colored in grey.

    A1:A10 will be the category/titles names.

    I need help with the following:

    I need Series B to be shown 10x but only linked to a single cell which is the total of 100% from B11.

    I hope this doesn't require the use of VBA or other developer options.

    Appreciate the help!

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

    Re: Progress bar chart

    Why can you not use 10x 100% for series B? Why only a single cell.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-20-2021
    Location
    Bahrain
    MS-Off Ver
    Office 16
    Posts
    3

    Re: Progress bar chart

    hi andy, i know i can do that but it needs to be done with 1 cell only as a template for work.

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

    Re: Progress bar chart

    You can add a series and reference B11 10 times
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-20-2021
    Location
    Bahrain
    MS-Off Ver
    Office 16
    Posts
    3

    Re: Progress bar chart

    perfect, thanks andy!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bar Chart - Progress Bar
    By AndreaEL in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-16-2017, 08:04 AM
  2. Progress Chart Help
    By coffee-ill in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2016, 01:34 PM
  3. Progress Chart
    By gotmic in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2016, 07:37 AM
  4. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 01-08-2014, 02:40 AM
  5. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 12:41 PM
  6. Progress chart
    By ijacobs in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-16-2013, 02:13 AM
  7. Progress bar in chart
    By Georgios in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-27-2007, 11:25 AM

Tags for this Thread

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