Adding Status marker in Burndown Report

Question

Hi all,&nbsp;first time poster and new user to Microsoft project.&nbsp;I have created a Burndown report and I am wanting to add in a Status Marker or todays date marker to my report that will move with time . Can this be done?&nbsp;Or do I need to manually insert a shape and create my own marker? And then I will have to move it every time I status or need to show the report to anyone?&nbsp;Thanks!&nbsp;

john-project · Answer

Michelleblogs,Don't hold your breath waiting for me to come back with something, I've got several things "on my plate".I like Ismet's suggestion of using a secondary axis as it shows a nice vertical marker which may not be that easy to produce with a manually drawn line.John

ismet_kocaman · Answer

It works the same way as the MS Excel charts. There are plenty of resources on the internet that explain how to do it. Hope this helps.

john-project · Answer

Michelleblogs,Can it be done? Possibly, but to automate the process (e.g. dynamically move the marker with the current date or status date) requires some VBA. I've never done something like that before so I'd have to do more research.&nbsp;John

michelleblogs · Answer

John-project&nbsp;&nbsp;hey John! Okay great, gives me some hope! Will be interesting to know if and how it can be done - thanks in advance for your help&nbsp;&nbsp;thanks&nbsp;

ismet_kocaman · Answer

Michelleblogs&nbsp;I believe John can do it by VBA. I've used secondary axis once for this purpose (see the red one) but it has to be adjusted manually.&nbsp;

Forum Discussion

Adding Status marker in Burndown Report

6 Replies

Resources