Microsoft Project is a better tool than excel to create a project but in some companies, I don’t have this tool so as a workaround, I created something similar in excel to follow up the project from the initiation until the completion. In fact, it is just a chart showing the progress of each stage of a project.
Following the steps:
Now that I have my chart, the next step is to align it with my table, so here, it is up to me, I can put bigger the row for the table, make bigger the chart, etc. To make bigger the bars of the chart:
What I like to do, it is to put the full sheet with the blank colour and make the chart transparent without outline so when I select the row of the stage 5, for instance, it will highlight the full picture.
Other thing I like to do, it is to put a begin date in a cell and each time I change the start date, by clicking on the update, the chart will update the stages. For that, I have to create a macro and save the file as xlsm. If you are interested, below the VBA code:
Sub test()
' change xxx by the chart name and change B2 by the date cell
With ActiveSheet.ChartObjects("xxx").Chart.Axes(xlValue)
On Error Resume Next
.MinimumScale = Range("B2").Value
End With
End Sub
To know the name of your chart, select your chart and go to “format -> selection pane”.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...