Dual Indicator Speedometer Chart in Excel
HTML-код
- Опубликовано: 15 сен 2024
- Hello Friends,
In this video you will learn how to create a dual indicator speedometer in Excel. We can display our 2 metrics in one speedometer chart.
Please download this excel file from below given link:
drive.google.c...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert
This is really a very simple explanation of an otherwise complicated process ! Thanks !
Thanks for your valuable feedback.
Your videos are great. I'm Brazilian. Você é um ÁS no Excel.
Obrigado por palavras agradáveis
Parabéns!!!
Obrigado por compartilhar seu conhecimento
Thanks for watching.
Thanks for sharing this.
you are awesome
Thanks
Many Thanks
Amazing .... thank you!
Thanks for your valuable feedback
OK Friend, this is brilliant, OK Friend
Thanks for your valuable feedback
When I align my two speedometer charts, it only shows only shows the needle from chart two. Chart one disappears behind chart 2. How do I fix?
Hi Sir,
Can't we make by using only one graph, instead of taking two? By adding a series in the same single graph...
warm regards,
Hello PK, Need your help for my use case. I want to build a speedometer to represent Organisation Risk Score.
Data is like, Critical Bugs - 40
Medium Bugs - 75
Low Bugs - 90
Speedometer should represent 3 colours, Red (critical) , Orange(Medium) & Yellow(Low)
Pointer should fall in Red colour as there are critical bugs, f critical bugs falls to zero then Pointer should fall into Orange segment
Apart from that , no of bugs should show in coloured portions of each segment.
Hi PK, Thank you for the wonderful chart. I have one question. If I want to have a scale 20 to 120 instead of 0 to 100, what calculation should I use?
HI, You will have to setup extra steps; use a separate cell for manual inputs, say it is Cell F1 for current year and F2 as Last Year as examples and enter say 0.2 (or as 20% when you put in the "%" sign). For the Cell I1 and I2 (as with PK's Example), put in the formula for Cell I1 as (=F1-0.2) then also for Cell I2 as (=F2-0.2), Omit the brackets and commas, input formula from = sign onwards to last digit will do. Then, change the manually input scale from current 0%, 20%, 40%,60%, 80%, 100% to 20%, 40%, 60%, 80%, 100%, 120%. Then you will have your scaling. Do have a side note to indicate that the scale is from 20%to120% and not 0% to 100%.
Extra: The scale is 200% with 5 parts adding up to 100% and 1 part as 100%, which is why the bottom half of the doughnut chart is invisible after aparting "no fill", you can scale into equally divided parts (i.e 4 parts to 1 part for 25%, 5 parts to 1 part for 20%, or 10 parts to 1 part for 10% etc.) to your desire as you see fit.
Which is why the no fill part is written as a formula of (2 - 0.01 - (cell value I1))
Sir my second chart is coming over first chart when I am aligning them. Please help
same issue with me.
Hi zaim,
Please fill the chart area as no fill and chart outline as no line
Bravo (Y)
Thanks
how to set min data to 75% and max is 100, i only need 75% min data, thanks for ur answer sir
Hello, You will have to setup extra steps; use a separate cell for manual inputs, say Cell F1 for current year and F2 as Last Year as examples and enter say 0.75 (or as 75% when you put in the "%" sign), values upper limit is at 1. For the Cell I1 and I2 (as with PK's Example), put in the formula for Cell I1 as (=F1-0.75) then also for Cell I2 as (=F2-0.75), Omit the brackets and commas, input formula from = sign onwards to last digit will do. Then, change the manually input scale from current 0%, 20%, 40%,60%, 80%, 100% to 75%, 80%, 85%, 90%, 95%, 100%. Then you will have your scaling. Do have a side note to indicate that the scale is from 75%to100% and not 0% to 100%, so enter values from 0.75 to 1.
Extra: The scale is 200% with 5 parts adding up to 100% and 1 part as 100%, which is why the bottom half of the doughnut chart is invisible after aparting "no fill", you can scale into equally divided parts (i.e 4 parts to 1 part for 25%, 5 parts to 1 part for 20%, or 10 parts to 1 part for 10% etc.) to your desire as you see fit.
Which is why the no fill part is written as a formula (2 - 0.01 - (cell value I1))
@@hongqirong9927 thanks for reply sir, ill try it :D
Sir excel shape in colour change in vba coading
Hi Karan,
I will make such video very soon. Thanks for watching