Learn how to make a bar in Gantt chart. You will be able to answer a question on how do you make a bar on a Gantt chart or how do you add timeline to a Gantt chart? You will also learn how to create a timeline chart in Excel and how to change the Gantt chart timeline in Excel.

Here the steps outline on the video.

Create Gantt chart timeline bar.
1) Select timeline area.
2) Home ~ Style ~ Conditional Formatting ~ New Rule
3) Use formula to determine which cells to format
4) =AND(F$3＞=$D5,F$3＜=$E5)
5) Format
6) Fill
7) Select color
8) OK
9) OK

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google

свернуть