All Questions
Tagged with gantt-chart vba
19
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
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 ...
- 47
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
1
vote
1
answer
116
views
Visio shape (Gantt Bar) not updating with automation
I'm trying to automate the updating of some GANTT bars with a button setting the beginning date at 2w before now and ending date at 10w after now.
Problem is that it actually work and changes the data ...
- 11
-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 ...
- 73
0
votes
0
answers
167
views
Setting colors for gant-chart based on percentage values (Excel)
I created a gantt-chart in excel which contains different projects and their planned start and end dates.
I want to modify this chart in the following way:
there is a changing percentage value, ...
0
votes
0
answers
382
views
How to create a Gantt chart [VBA] using cell borders
I would like to have a gantt style chart in my project by adding in VBA border to specific cells like here:
I tried with this script :
Public Sub DisegnaLineeGantt(ByVal riga As Long)
Dim ...
- 47
0
votes
1
answer
604
views
VBA to highlight cells based on current time of day
I have a row of cells repeating "1st shift", "2nd shift", and "3rd shift". The top row on the sheet is the dates throughout the year. I already have code to open the file to a specific date (always ...
- 1
0
votes
1
answer
1k
views
How do I display Tool-tip on an excel column chart contained in a sheet that is protected(UserInterfaceOnly)?
I have a stacked column chart with many series and with legend etc. I am having to display a tooltip when the mouse hovers over the series and the good thing is I achieved that using code from Here.
...
- 453
0
votes
1
answer
2k
views
How to Delete only extra Legend Entries that are not needed in a stacked bar chart(Gantt) in Excel VBA?
I found the question "Deleting legend entries with blank series name using VBA" here Very similar to the problem I'm Having but with a twist.
I have two buttons, "Load Chart" and "Clear Chart" like ...
- 453
1
vote
1
answer
216
views
VBA Dynamic Comment Creation
I'm trying to improve my GANTT chart in Excel with VBA. For now, I'm only using conditional formatting, but I need to show the project payment values, dates and status within a comment box which will ...
- 11
-1
votes
1
answer
78
views
Color a specific range of cells in the same row
Similar to a Gantt Chart but not quite the same, I'm trying to color a variable range of cells on the same row.
As you can see I have a variable number of tasks and a variable start and end for each ...
- 3
0
votes
2
answers
6k
views
Link Excel Chart Axis Scale to Values in Cells
I have this Gantt Chart and i'm looking at Planned Vs Actual dates.
the problem is that the chart wont sync the start/end date.
i'm trying to link the max/min values to the cell with VBA but it wont ...
- 194
1
vote
0
answers
94
views
excel vba button move to chosen cell
I have a BIG Excel table (Daily Gantt Chart)
and I need a button use which I can choose date.
like a Vlookup but instead of bringing the data to me, I want to go to the data.
like a Ctrl + F , but ...
- 194
2
votes
1
answer
6k
views
MS Project to Excel Gantt Chart using VBA
I'm trying to export some tasks from MS Project to Excel using a VBA script in Project. So far I am able to export the data I want with no issue and it opens in Excel just fine. What I'm trying to do ...
- 45