Comments on Interactive Project Dashboard|Dashboards & Charts|Excel Forum|My Online Training Hub

Dear Myanda,

Thanks for the Project Dashboard Tutorials, it's really helpful and it's Great I have liked it and have spread the word to my friends colleagues to watch all your videos and subscribe.

I tried to recreate the sheet on my own and added my tasks and dates which I use in my company. However I am facing the issues below.

1) the scroll bar is not going till the end date as mu Project starts in Feb or Jan 20 and expected to finish in Nov'20.

2) also the bar below the dates does not pop up for Completion, In Progress, Not Started.

3) Would really be helpful if we can monitor the real time as I have added the completion date so that we can compare with the End date whether this project finished on time or it overlapped.

3) Also the Complete % when I refresh it doesn't change.

Please find attached my spreadsheet (I don't have Office 365 version) please advise.

Also I am attaching another excel Dashboard just for your reference (it's simply made by someone and I am following the same currently, (But this can be done individual Project-wise not for all Projects).

Thanks once again your spreadsheet is superb and the dialect is some simply as anyone an understand it, thanks for helping all.

Regards

Shabbir