Progress matrix to be represented in Graph with % completion

Dear All,

I have a worksheet which i maintain simply in a matrix table to track activity completion against each SKU. I have 11 SKUs in total & there are 11 activities which are standard for each SKU.

I need to represent this table in a graphical format showing % completion against each SKU & also it should show overall % completion. Could be just an arbitrary approach.

File attached.

Thanks,
Mahesh

hi
some sort of column or stacked column seems most appropriate - maybe like the attached?

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.

Originally Posted by MaheshK5277

Dear All,

I have a worksheet which i maintain simply in a matrix table to track activity completion against each SKU. I have 11 SKUs in total & there are 11 activities which are standard for each SKU.

I need to represent this table in a graphical format showing % completion against each SKU & also it should show overall % completion. Could be just an arbitrary approach.

File attached.

Thanks,
Mahesh

One way of arriving at the desired outcome would be Conditional Formatting.
Format your cell for status "done" and fill it with desired color combinations.
A sample sheet is attached herewith.

---

Shashank

Dear All,

I can't thank each of you enough. All solutions are working & i will use which best suits the requirements.

Thanks you all!!!

Regards,
Mahesh