Forum Discussion
Michelleblogs
Sep 27, 2022Copper Contributor
Adding Status marker in Burndown Report
Hi all, first time poster and new user to Microsoft project. 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...
John-project
Sep 28, 2022Silver Contributor
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.
John
- MichelleblogsSep 28, 2022Copper Contributor
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
thanks
- John-projectSep 28, 2022Silver ContributorMichelleblogs,
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_kocamanSep 28, 2022Brass Contributor
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.
- MichelleblogsSep 28, 2022Copper Contributor
Hey Ismet,
that could be a great work around for the interim! How do you add a secondary axis in the Burndown reports in Microsoft project? sorry super new to the applicationthanks.