Great video thank you, How do I do this with a range of 5 max, and the data is from .00, .01, .02 etc up to max of 5, so the needle could point to 2.57 for example
Great question, Neil! 😀 Yes, it is possible! One way would be to add additional color columns next to Grey and Color and adjust the IF formulas to include multiple ranges as needed. Build Doughnut charts for the additional colors as shown in the video, and you've got it!
Would it be possible to have a gauge chart...using doughnuts similar to yours...but that not only show the 0% - 100% range (horizontally, where the 0% is far left and the 100% is the far right of the gauge)...but to also extend the gauge to include negative values (that would extend the gauge to the left, going backwards...making a circle below the horizontal axis) as well as values that exceed 100% (and would go to the right, going forwards...making a circle below the horizontal axis) that currently stops at 100%?
How can i use it to measure my work through multi sheets ( each sheet different tables sizes Vertically and horizontally) , as i want to know how many done and how many left
Just curious...Years ago, I created a data conversion app in VBA that took a long time to compute. I built a progress gauge that showed how much longer it was likely to take, but it was just a bar going from 0 to 100%. My time prediction was based on how much had been completed in say 10 minutes. Having not used VBA for 20 years, I forget how I even did it. What approach would you suggest be used using more modern techniques? I have no current need for this, but others might find the application useful.
Great question Jim! It's mostly going to depend on how predictable the processes are within the macro. If the macro is adding formulas the the workbook, then calculation times might get longer, making it more challenging to predict how much time is left. System resources can also make this a challenge. I've created VBA progress bars in the past, but those usually just display the percentage complete in terms of steps in the process instead of time. I hope that helps.
I'd like to create a gauge chart that shows the percentage completion for a project based on a start date, end date, and today's date. The twist is, if today's date is past the end date, I'd like the gauge to turn red. Thoughts?
Neat application, Jason! Try creating a third gauge chart for Red. Use another column of data (e.g., Column N). The formula in column M for Color may need to be modified to include an IF condition for the date that makes the green disappear (0) when TODAY()>End_Date. You may want to keep Grey in the gauge even when Red is in play. Hope that helps!
We are trying to use this on a project, but excel doesn't support the Combo Donut chart anymore. Is there a chance this would work with the Sunburst chart.
Instead of using 2 charts on top of each other, could you just make it so that the one donut chart has three "blocks" of data within it? i.e., currently there is a second block that is 101-200, but could you have it where that is the 3rd block, and the 2nd block would be 48-100?
As a teacher I find this EXTREMELY useful! I can't wait to use it!
Thanks for your feedback! 😀
I like this very much and will use it. Now we need to add conditional formatting to change to colour depending on the numeric result.
Did you manage to do this?
Great tutorial, thanks. Looking forward to the next one. Paul
Thanks, Paul! Glad you enjoyed it!
Waiting for that calendar view! Great vid.
Coming soon! Thanks for watching!
Thank you for the tutorial! Very beneficial and this is what I was looking for.
Glad it was helpful! 😀
Thank u Jon for this great video 📹
Excellent. Great tips!
Glad it was helpful! 😀
This is so cool, thank you!!
Thx, easy to understand
Thank you! Great tutorial!
You're very welcome! 😀
thank you, thank you, thank you.
Welcome, @andrewsvega2023! 😀
Great video thank you, How do I do this with a range of 5 max, and the data is from .00, .01, .02 etc up to max of 5, so the needle could point to 2.57 for example
Thanks for this Is it possible to change the colour of the chart in relation to valaue ie 0-40 Red, 41-69 Amber & 70- 100 Green?
Great question, Neil! 😀 Yes, it is possible! One way would be to add additional color columns next to Grey and Color and adjust the IF formulas to include multiple ranges as needed. Build Doughnut charts for the additional colors as shown in the video, and you've got it!
@@ExcelCampus what would the IF formula look like on this?
Would it be possible to have a gauge chart...using doughnuts similar to yours...but that not only show the 0% - 100% range (horizontally, where the 0% is far left and the 100% is the far right of the gauge)...but to also extend the gauge to include negative values (that would extend the gauge to the left, going backwards...making a circle below the horizontal axis) as well as values that exceed 100% (and would go to the right, going forwards...making a circle below the horizontal axis) that currently stops at 100%?
How can i use it to measure my work through multi sheets ( each sheet different tables sizes Vertically and horizontally) , as i want to know how many done and how many left
Just curious...Years ago, I created a data conversion app in VBA that took a long time to compute. I built a progress gauge that showed how much longer it was likely to take, but it was just a bar going from 0 to 100%. My time prediction was based on how much had been completed in say 10 minutes. Having not used VBA for 20 years, I forget how I even did it.
What approach would you suggest be used using more modern techniques?
I have no current need for this, but others might find the application useful.
Great question Jim! It's mostly going to depend on how predictable the processes are within the macro. If the macro is adding formulas the the workbook, then calculation times might get longer, making it more challenging to predict how much time is left. System resources can also make this a challenge.
I've created VBA progress bars in the past, but those usually just display the percentage complete in terms of steps in the process instead of time.
I hope that helps.
I'd like to create a gauge chart that shows the percentage completion for a project based on a start date, end date, and today's date. The twist is, if today's date is past the end date, I'd like the gauge to turn red. Thoughts?
Neat application, Jason! Try creating a third gauge chart for Red. Use another column of data (e.g., Column N). The formula in column M for Color may need to be modified to include an IF condition for the date that makes the green disappear (0) when TODAY()>End_Date. You may want to keep Grey in the gauge even when Red is in play. Hope that helps!
We are trying to use this on a project, but excel doesn't support the Combo Donut chart anymore. Is there a chance this would work with the Sunburst chart.
We can get it to the point where we have the two half donuts, but we can't make them overlap without that combo chart maneuver you did!
Instead of using 2 charts on top of each other, could you just make it so that the one donut chart has three "blocks" of data within it? i.e., currently there is a second block that is 101-200, but could you have it where that is the 3rd block, and the 2nd block would be 48-100?
Link is not available in description
Sorry about that! We updated it, and here is the link: www.excelcampus.com/charts/guage-charts/
Have a great day!