Forum Discussion
Solved
How to build a dashboard with Excel
I'm about to start building a dashboard with MS Project data, but not having done it before I thought I’d ask some questions here. Requirement is to show last week vs this week's data - currently on...
- Hi John - yeah, that was a bit vague.
In my head, i've seen and used many different dashboards, and they're all relatively similar. What we said vs what we did, generally.
Resource utilisation - supply vs demand. 100 max utilisation vs what they've actually assigned to
We use outline codes to distinguish teams / contarctor agencies - so i'd like to be able to use these to auto generate / update the page
I'll have a look at PlannersPlace suggestion (thanks!) and see what i like
I envisage just taking a copy and paste from Project (gantt view and resource usage view) each week, pasting it in and dashboards updating
Hi John - yeah, that was a bit vague.
In my head, i've seen and used many different dashboards, and they're all relatively similar. What we said vs what we did, generally.
Resource utilisation - supply vs demand. 100 max utilisation vs what they've actually assigned to
We use outline codes to distinguish teams / contarctor agencies - so i'd like to be able to use these to auto generate / update the page
I'll have a look at PlannersPlace suggestion (thanks!) and see what i like
I envisage just taking a copy and paste from Project (gantt view and resource usage view) each week, pasting it in and dashboards updating
In my head, i've seen and used many different dashboards, and they're all relatively similar. What we said vs what we did, generally.
Resource utilisation - supply vs demand. 100 max utilisation vs what they've actually assigned to
We use outline codes to distinguish teams / contarctor agencies - so i'd like to be able to use these to auto generate / update the page
I'll have a look at PlannersPlace suggestion (thanks!) and see what i like
I envisage just taking a copy and paste from Project (gantt view and resource usage view) each week, pasting it in and dashboards updating
Well to be honest it's still a bit vague, (I'm a detail oriented guy), but thanks for the feedback.
Copy and paste is of course always an option but if something like this can be automated with a macro, that's the path I'd take.
Let me know if you need further help.
John