In the attached I have changed Milestone names font to red by:



Clicking for example on TEST 11
Right click and select Format Data Labels
Select Text Options
Solid fill
Select color

Under Format, Shape Styles you can change to proper text, remove outline etc.

By the way - the reason that I used the other template was that there with this one seems to be a problem with some data labels (TEST 1,2,3,4,5,6,8, 9 and 10 are missing), at least on my system.

Attached Files

Timeline with milestones_2.xlsx (20.3 KB, 10 views)

With a lot of activities/milestones of varying data length a spreadsheet template is proving to be a huge PITA to maintain formatting. Label locations have to be constantly altered (to keep from running into each other) as data changes/are added while certain vector lines from the axis to a label tend to get obliterated requiring further formatting which in turn has a knock on effect.

Frankly, a simple spreadsheet list: date, label is probably where I'm ending up.

Thanks again for the help.

Mark