About this workbook
Enter milestone and task information in the Milestones and Tasks worksheets. To chart
milestones along the timeline, enter 0 in the no. column, then, update the label position to
be "below" to avoid overlapping labels.
The position column in the milestone table, charts milestones within the task chart either on
the same row or in stacked rows. To chart them on the same row, enter the same number in
this column for each milestone. To chart them on different rows, enter different numbers.
Sample data charts all milestones along the row position of 2.
Guide for screen readers
There are 5 worksheets in this workbook:
About
Milestones
Tasks
Gantt Chart
Dynamic Chart Data (Hidden)
The instructions for each worksheet are in the A column starting in cell A1 of each worksheet.
They are written with hidden text. Each step guides you through the information in that row.
Each subsequent step continues in cell A2, A3, and so on, unless otherwise explicitly directed.
For example, instruction text might say "continue to cell A6" for the next step.
Hidden text will not print.
To remove these instructions from any worksheet, simply delete column A.
Dynamic Chart Data (Hidden)
Do not delete or modify content in the Hidden worksheet. Doing so could compromise the
integrity of the Gantt Charting.
Data may appear blank, dates may appear to be incorrect, do not fill in, edit, delete or
otherwise modify the data or you risk overwriting formulas and breaking the chart graphing
capability.
The DynamicMilestone table allows for 15 milestones to be charted. To chart more than 15,
simply expand the table to accommodate your number. Remember, only add the actual
milestone data in the Chart Data worksheet.
Tips
Page 1 of 5
By default, milestones are charted on row 1 of the Gantt Chart using the Position column in
the Chart Data worksheet, starting in cell C5. To chart milestones on different rows, simply
change the number.
The default setting is to highlight today's date in the Gantt Chart. To no longer highlight
Today's date, simply select "no" in the Chart Data worksheet in cell D2.
The Gantt Chart date timeline is charted with a gap of 5 dates between them. To change this,
select the timeline in the Gantt Chart worksheet and select Format Axis. Change the Major
unit from 5 to 1 or 10, for example.
This is the last instruction in this worksheet.
Page 2 of 5
th
fu
ert
ta
he
sk
r
sins
ta
tr
bl
uc
Date tracking Gantt chart
etio
is
ns.
Select option No in cell D2 if you do not want to highlight today's date in the Gantt Chart worksheet.
in
In CellTrack
cel today's
D2, select date? Down
ALT+Arrow Yesfor options.
l
G3
. Milestones
G4
th The position
ro This column column, charts
ug should be milestones Enter the date for a Enter a milestone description in this
h ordered within the task milestone in this column. These descriptions will appear in
J4.
A2 sequentially. chart. column. the chart.
1. No. Position Date Milestone
1 1 1/5/2024 Ticketing System and Observation
2 2 Milestone 2
3 3 Milestone 3
4 4 Milestone 4
5 5 Milestone 5
6 6 Milestone 6
Note, the default number of milestones to chart is 15. Adding new milestones requires a change in the hidden wo
TheTo
next
addinstruction is in cell add
more Milestones, A26.a new row above this one.
A note is in cell G26.
This is the last instruction in this worksheet.
Page 3 of 5
th
fu
e
rt
ta
he
sk
rs
ins
ta
tr
bl
uc
eDate tracking Gantt chart
tio
is
ns.
in
cel
l
G3
. Tasks
Enter the start
date for each
This column task below. For Enter the end date
should be best results sort for each task or
ordered this column in activity below, in Enter tasks and/or activities in this
sequentially. ascending order. this column. column.
No. Start Date End Date Task
Test Case Document Reviews and
1 4/17/2024 5/3/2024 Update
2 5/7/2024 5/31/2024 Hotline Testing (Cycle 1) (Prod & DR)
3 6/3/2024 6/25/2024 Hotline Testing (Cycle 2) (Prod & DR)
4 6/25/2024 7/9/2024 Hotline Testing (Cycle 3) (Prod & DR)
5
6
7
To add more Tasks, add a new row above this one.
tio
n
in
thi
s
w
or
ks
he
et.
Test Case Document
Reviews and Update
Hotline Testing (Cycle 1)
(Prod & DR)
Hotline Testing (Cycle 2)
(Prod & DR)
Hotline Testing (Cycle 3)
(Prod & DR)
24 24 24 24 4 4 24 24 24 24 4 4 24 24 24 24 4
/20 /20 /20 /20 /2 02 /2 02 /20 /20 /20 /20 /2 02 /2 02 /20 /20 /20 /20 /2 02
4/1
3
4/1
8
4/2
3
4/2
8 5/3 5/8 5/1
3
5/1
8
5/2
3
5/2
8 6/2 6/7 6/1
2
6/1
7
6/2
2
6/2
7 7/2
Page 5 of 5
