Speedometer Chart

[Joseph Horling]

Hi Chandoo Experts,
First, I would like to thank you for all the previous help on my other projects. You have been very helpful and I appreciate your prompt response. I was looking to create a speedometer chart for my dashboard tab involving the name of the player: goals, assists and goals. I would like to have one of each for goals, assists, and goals. I saw on google sheets the exact one I wanted but excel doesn't seem to have that particular one. Is there a way that I extract the one from google sheets to my dashboard? If not, how do I make one using the statistics I have in my Player and Stats tab? Thank you, Joseph from Michigan.

 

[p45cal]

Can you show us the type of chart you mean? A link perhaps?

 

[Joseph Horling]

https://docs.google.com/spreadsheet...a1c490IdrQCzIR3opzsxHB0z8/edit#gid=2064265511 There's the link, I hope you can get to it.
Thank you P45Cal.

 

[p45cal]

here's the link, I hope you can get to it.

..not without permission.

 

[Joseph Horling]

https://docs.google.com/spreadsheets/d/1jlkxdAhvS7gk_JFaTia1c490IdrQCzIR3opzsxHB0z8/edit#gid=0 Try it now. I gave permission to everyone. Hope you can get to it.

 

[Hui]

Have you had a look at the templates at:
https://sites.google.com/site/e90e50fx/home/compound-pie-radar

 

[Hui]

How's this?

see attached file:

 

[Joseph Horling]

That's great Hui. But how do I link that to the dashboard? I want to be able to see three speedometers(Goals, Assists, and Points) when I change the players name on the slicer. See first file above. Thanks, buddy.

 

[Hui]

Hows this?

All linked to that 1 yellow cell

To use these copy the worksheet into your file, the Named Formula should go with it

Relink the yellow cell and the cells directly below it to your data source

 

[Joseph Horling]

Thanks, Hui! I will try to copy that into my file. You're awesome at this. I wish I can figure that out myself.