• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

to do list - progress chart

M

Maqsood

New Member
Please see the attached sheet. I need the progress chart in the sheet to do the following
1) if the check box is ticked in Activity status 1, the graph should show 100 percent (with green color).
2) if checked in Activity 2, the graph should reduce the percentage from 100% to 80% (and should have orange color)
3) if checked in Activity 3, the graph should further reduce.
how do I do that? I tried to give negative weightages, but still it didn't work.

Thanks
Maqs Abdul Rahiman
 

Attachments

Hi ,

It is not clear what should happen for each checkbox.

1. Does each checkbox have a weightage on its own , independent of the other checkboxes ? If so , where are these weightages listed ?

2. If the checkboxes are related , then what will happen for all the possible combinations ? Because they are checkboxes , they are not mutually exclusive ; thus , with 7 checkboxes , there are so many combinations ; how do we deal with all of them ?

Narayan
 
Hi,

if checkbox in activity 2 in ticked, it will automatically check the one in activity 1. Similarly if checkbox is activity 3 is checked it would automatically check activity 1 and activity 2. so it does with activity 4, 5, 6 & 7. this is how the VBA coding is set in the sheet. (thats my requirement)

regarding the weightages, activity 1 if checked should show a 100 % progress (green color). that is working fine in the attached sheet. but if activity 2 is checked, the progress chart should reduce to 80% (orange color) which means that the weigtage for this activity should be the difference between the weightage in activity 1 & 20%. in the same way if activity 3 i checked ot should further reduce to 60% (red color)which means that the weigtage for this activity should be the difference between the weightage in activity 1, activity 2 & 20%. the weightage need to be fixed in such a way that the chart progress reduce from 100% to below.

to answer to question no. 2. with all the 7 checkbox ticked, the chart should have a 0% progress or can even me -ve percentage.

hope its clear now.

Thanks
Maqs
 
Hi Narayan,

Thank you. the progress chart works fine. but the VBA code that was assigned for the checkbox is not working now.
(that is if checkbox in activity 2 in ticked, it will automatically check the one in activity 1. Similarly if checkbox is activity 3 is checked it would automatically check activity 1 and activity 2. so it does with activity 4, 5, 6 & 7. this is how the VBA coding is set in the sheet.)

Thnaks
Maqs
 
Hi ,

I don't see why it should not work , since I have in no way modified any code.

It works at my end on the file that I uploaded.

Narayan
 
You must log in or register to reply here.
Back
Top