All Questions
Tagged with gantt-chart excel
46
questions
0
votes
1
answer
61
views
How to border cells based on where the user click?
I have a Gantt chart in an excel sheet. Everything works, but I would like to improve it by entering a vba code that would put borders around the range of cells in the graph that is concerned by the ...
0
votes
0
answers
39
views
Excel Gantt Chart Drop Down Menus
I am creating a Gantt chart that will encompass all of the marketing activities for my org. My goal is to create a central dashboard that can toggle in between subjects and populate cells based on ...
0
votes
0
answers
64
views
Gannt chart - Multiple task bar in one row
I am using excel to create Gantt chart. I was wondering it is possible to have multiple sub-tasks bar (as in green and yellow - should be in the same row as green) on a single row? My problem is a ...
0
votes
2
answers
112
views
Gantt Chart on Excel - How to modify conditional formatting to work
I am trying to get my conditional formatting to work but failing.
In Row 13, the task starts 22/07/2022 and finishes 24/07/2022. This is in week beginning 18/07/2022, so I want this cell to be ...
0
votes
2
answers
415
views
Display week number of each month instead of days
I am preparing a tracker to list week number of each month. But, I could only get the weeks with days.
I have something like this.
And I want to change to this so the section automatically update the ...
0
votes
0
answers
53
views
Clicking on a cell and a singular, different cell is highlighted in the active row
My excel sheet/ gantt chart covers a yearly plan, making the amount of columns quite large. Is there a way to click on a cell in the "item_in_plan" bars and highlight the "task" ...
0
votes
0
answers
192
views
Excel Formula for Progress shading based on percentage
I want my gantt chart to have a "show progress" option and shade the pink bars with a dark blue. The main columns I'm working with are start date, end date, work days, and percentage ...
0
votes
1
answer
532
views
VBA create gantt chart with day/hour/minute timestamps
I am attempting to create a gantt chart from a start timestamp and end timestamp column.
So far, I have the code that creates the dates as columns with a Zero hour and minute timestamp:
You will ...
0
votes
0
answers
74
views
VBA Gantt Chart, Parent-activities dictionary
I am brand new to VBA and would need your help on a personal project.
I want to create a custom Gantt chart on Excel VBA.
Excel version is Microsoft® Excel® for Microsoft 365 MSO (Version 2208 Build ...
-1
votes
1
answer
633
views
How to count how many cells have background color in excel
Is there a non VBA way to count how many cells have background color?
In this particular case I'm looking to automate a gantt diagram:
The goal is to fill a cell with any background the user likes, ...
2
votes
2
answers
1k
views
How to indicate expected dates and actual dates in a Gantt chart?
I am trying to create a Gantt chart which involves planned and actual start/end dates. I would like same tasks to overlap like:
So far this is my code.
import plotly.figure_factory as ff
import ...
0
votes
1
answer
115
views
Pause Conditional Formatting but keep the last changes
I have a GANTT chart in excel on one sheet that uses conditionally formatting to conditionally fill 7 different colors for about 50 rows over about 120 periods(columns) per month.
As you can imagine, ...
0
votes
2
answers
68
views
MS Excel: Match Value With Two Criterias & Distribute Them Across a Timeline
I'm not very well versed with Macros and could use a little help. I have a dataset with three columns,
Customer ID
Date of Purchase
Amount
I want to plot this on a linear timeline, date wise, to ...
0
votes
0
answers
222
views
Trying to create a dynamic gant chart in excel using conditional formatting when reference against an activities dates and times
I'm trying to get one of my excel sheets to produce a gantt chart to aid in the user in understanding when activities take place, and their connection with each other.
So far i've managed to get the ...
-1
votes
3
answers
2k
views
Generate summary gantt chart from detailed activities
I want to create a gantt chart summary that shows a person´s whole "busy" and "free" schedule by day and in a single row, from a detailed gantt chart with a list of activities of ...