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
Kevin Drake Perth, Western Australia, Australia
I cannot wait to see the options that we have,,, you are a legend mate
avatar
Kevin Drake Perth, Western Australia, Australia
I use excel for that.
have a look at this link, it has even a ready template
http://www.instructables.com/id/Speedometer-Graph-in-Excel/
avatar
Kevin Drake Perth, Western Australia, Australia
I do not think MS project has that option.
avatar
Riyadh Salih Saskatchewan, Canada
Kevin, the problem on this chat I can not paste anything to show even snipping tools doesn't work here no graph no picture & no attachment
avatar
Sante Delle-Vergini, PhD Senior Project Manager| Infosys Melbourne, Victoria, Australia
Another thing to ask the administrators about.
...
1 reply by Riyadh Salih
Apr 30, 2018 12:02 AM
Riyadh Salih
...
Sante good idea
avatar
Sante Delle-Vergini, PhD Senior Project Manager| Infosys Melbourne, Victoria, Australia
I wish I had a speedometer for the crazy and unreliable influence algorithm, lol.
...
1 reply by Riyadh Salih
Apr 30, 2018 12:03 AM
Riyadh Salih
...
Sante, yes I hear you and agree with you
avatar
Drew Craig Sr. Agile & Product Coach| Vanguard Philadelphia, Pa, United States
Hi Riyadh - Let us know how you make out.
...
1 reply by Sante Delle-Vergini, PhD
Apr 30, 2018 5:58 PM
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.
avatar
Kiron Bondale Retired | Mentor| Retired Welland, Ontario, Canada
Riyadh -

If you are using the server version of MS Project, as there is a SQL back end database, any BI tool which has dashboard support would work.

But I'd ask the question, why a speedometer? Projects rarely have "real-time" updates the way a transaction processing system will, so what would a speedometer show which a more traditional bar chart or line chart couldn't?

Kiron
...
3 replies by Karan Shah and Riyadh Salih
Apr 29, 2018 11:20 PM
Karan Shah
...
[But I'd ask the question, why a speedometer? Projects rarely have "real-time" updates the way a transaction processing system will, so what would a speedometer show which a more traditional bar chart or line chart couldn't? ]

For my projects, it's a visual of the current velocity. With colours for slow, could-be-faster, on-track, or supercharged velocity. An arrow shows which colour wedge the project is currently on.

This is primarily used for periodic meetings with the more senior stakeholders (internal or external) and is complemented by a line graph. They don't have to measure and calculate slopes in the velocity chart. I have, therefore, found it to be more useful when stressing on a specific point where help is needed (resources need to pick up their pace, changes to backlog need to be discouraged, we are overstretching ourselves and output quality is a risk, etc.).
Apr 30, 2018 12:08 AM
Riyadh Salih
...
Kiron, we have few stakeholders who like fancy scoreboard so they like the idea when you change values the needle moves on three different colors (area on speedometer)
Apr 30, 2018 12:19 AM
Riyadh Salih
...
Kiron, many projects I know they do require real time data (tick by tick)
avatar
Paul Gosnell Project Manager| NTT Data Services Middletown, De, United States
I have been exploring Power BI, a Microsoft product, and it has gauges that may work.
...
1 reply by Riyadh Salih
Apr 30, 2018 12:08 AM
Riyadh Salih
...
Paul, thanks for sharing that, I will try that BI
avatar
Andrey Volodin Student| nill Russian Federation
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
...
2 replies by Riyadh Salih and Sante Delle-Vergini, PhD
Apr 30, 2018 6:00 PM
Sante Delle-Vergini, PhD
...
So it looks good.
May 01, 2018 1:16 AM
Riyadh Salih
...
Andrey, thanks for sharing all those links
It is so cool
< 1 2 3 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

"Love your enemy--it will scare the hell out of them."

- Mark Twain

ADVERTISEMENT

Sponsors