Results 1 to 6 of 6

Progress matrix to be represented in Graph with % completion

Threaded View

MaheshK5277 Progress matrix to be... 01-14-2020, 04:07 AM
NickyC Re: Progress matrix to be... 01-14-2020, 04:22 AM
Andy Pope Re: Progress matrix to be... 01-14-2020, 04:22 AM
eleleldimos Re: Progress matrix to be... 01-14-2020, 04:30 AM
shank_mis Re: Progress matrix to be... 01-14-2020, 04:53 AM
MaheshK5277 Re: Progress matrix to be... 01-14-2020, 06:40 AM
  1. #4
    Registered User
    Join Date
    04-29-2018
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    11

    Re: Progress matrix to be represented in Graph with % completion

    Hey Manish,

    I wrote some simple code to present this date, probably an easier way to do it but this works.
    For every cell there is an if formula that makes a 1 if the cell contains done, and 0 if there is anything else
    (you might want to apply data validation to ensure a typo doesn't cause any errors in this data)
    then the formula divides the total number of 1s by 11 to represent the % per SKU and per activity.
    This is easily represented in a bar chart although you might want to represent it differently.
    Let me know if you have any questions, I've attached an example below. Please mark this thread as solved if this solved your issue.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] show with a progress bar for completion of data in a range of cells
    By JJFletcher in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-06-2016, 01:32 PM
  2. Replies: 0
    Last Post: 02-06-2016, 08:39 AM
  3. Need formula: progress (% completion) between two dates
    By bsafra1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 09:53 AM
  4. Progress bar to show both percentage completion and time left
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-28-2014, 04:29 PM
  5. 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
  6. 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
  7. Matrix/array completion
    By Sebastian42 in forum Excel General
    Replies: 2
    Last Post: 12-03-2007, 04:00 PM

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