Need a quick assistance for a Gantt Chart in Excel

Moe87528

New Member
Joined
May 26, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,

After I enter a date range (start date and end date) for a certain task, I want to be able to physically enter each day a value; say 0 for not done and it would show it in red color, and 1 for done and it would show it green color. Also when I put either values 1 or 0, I want the data bar to show progress automatically, with 0 not affecting the data bar.

I have tried different methods but did not work, PLEASE HELP ME IN THIS !!!
 

Attachments

  • Capture.JPG
    Capture.JPG
    41 KB · Views: 8

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Dan_W

Board Regular
Joined
Jul 11, 2018
Messages
249
Office Version
  1. 365
Platform
  1. Windows
I don't know that this something that someone is going to be able to explain, but first, I'm not quite sure what it is that you want - what is it that will be showing in red/green? The date? the blocked out period of days?

" Also when I put either values 1 or 0, I want the data bar to show progress automatically, with 0 not affecting the data bar. " If something is either 1 or 0 (i.e., either True or False), then that means that the task is either complete or it's not - if it's complete, then there is any 'progress'... it's complete. It's 100% done. And if a value of 0 does not affect the data bar, how would it look different to the way it does now?

To you have any example of how you would like it to look? I'm having difficulty visualising it.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,007
Messages
5,526,248
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top