Excel Forum

Comments on Interactive Project Dashboard

Shabbir P

New Member

Members

Forum Posts: 1

Member Since:
June 27, 2020

Offline

June 27, 2020 - 8:47 pm

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

Mynda Treacy

Admin

Forum Posts: 4769

Member Since:
July 16, 2010

Offline

June 29, 2020 - 12:23 pm

Hi Shabbir,

Welcome to our forum! It's great to see you're able to make use of the techniques. Answers to your questionsL

1. You have 235 days in your date range, but the scroll bar maximum is set to 100. You need to set the maximum above the number of days you have in your date range. e.g. 250 to allow for growth, or more if you think it will grow further.

2. I don't know what you're referring to. The bar chart in columns N:R and rows 2:4 is showing task progress for me and it updates when I select different items in the Slicers.

3. You'd need to add another date field to your source data for target completion date. You could then use conditional formatting to highlight tasks that are overdue.

4. I can't reproduce this issue. It refreshed for me.

Mynda