Project Management

Please login or join to subscribe to this thread

Can you create speedometer on dashboard by MS project software?

linkedin twitter facebook   Estimating  
avatar
Riyadh Salih Saskatchewan, Canada
If the answer is No then what other software you suggest to use to create dashboard with speedometer, I tried it with Excel but it is very hard, looking for easier dashboard where it will move the dial as more input values added
Sort By:
< 1 2 3 >
avatar
Drew Craig Sr. Agile & Product Coach| Vanguard Philadelphia, Pa, United States
Apr 30, 2018 5:58 PM
Replying to Sante Delle-Vergini, PhD
...
It seems the links you provided in a post disappeared, yet others remain. Great links by the way for the dashboard, thanks Andrew.
I misread the request.as a need within MS Project only. But, hey, thanks! :)
avatar
Riyadh Salih Saskatchewan, Canada
Sante, I put the following info in the speedometer

What is the project budget? 750,000
How complete is the project? 65%
How complete should the project be? 70%
How much has the project spent? $510,000

Budget at completion 750,000
Actual costs 510,000
Earned value 487,500
Planned value 525,000
Cost variance -22,500
Schedule variance -37,500
Cost performance index 0.96
Schedule performance index 0.93
Estimate at completion 784,615
Estimate to complete 274,615
To-complete performance index (BAC) 1.09
To-complete performance index (EAC) 0.96
Variance at completion -34,615
...
1 reply by Sante Delle-Vergini, PhD
May 01, 2018 4:14 AM
Sante Delle-Vergini, PhD
...
Great, and what does the speedometer look like? ;-)
avatar
Riyadh Salih Saskatchewan, Canada
Apr 29, 2018 3:05 PM
Replying to Andrey Volodin
...
why would you need a speedometer on the dashboard of MS project?
It seems that you are speaking about charts in a form of a speedometer or gauge.
Google search returns many results on that combination of words.
What I like most from a random search is https://developers.google.com/chart/intera...s/gallery/gauge
or
https://stackoverflow.com/questions/309474...tom-gauge-chart
and
https://answers.microsoft.com/en-us/msoffi...8d-55e01a20ee1b

Otherwise you may refer to:
https://docs.microsoft.com/en-us/power-bi/...al-gauge-charts
https://answers.microsoft.com/en-us/msoffi...8d-55e01a20ee1b
https://www.youtube.com/watch?v=cObyWhe2wMw
Andrey, thanks for sharing all those links
It is so cool
avatar
Sante Delle-Vergini, PhD Senior Project Manager| Infosys Melbourne, Victoria, Australia
May 01, 2018 1:13 AM
Replying to Riyadh Salih
...
Sante, I put the following info in the speedometer

What is the project budget? 750,000
How complete is the project? 65%
How complete should the project be? 70%
How much has the project spent? $510,000

Budget at completion 750,000
Actual costs 510,000
Earned value 487,500
Planned value 525,000
Cost variance -22,500
Schedule variance -37,500
Cost performance index 0.96
Schedule performance index 0.93
Estimate at completion 784,615
Estimate to complete 274,615
To-complete performance index (BAC) 1.09
To-complete performance index (EAC) 0.96
Variance at completion -34,615
Great, and what does the speedometer look like? ;-)
< 1 2 3 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

"A noble spirit enbiggens the smallest man"

- Jebediah Springfield

ADVERTISEMENT

Sponsors