Bob Ross of Excel - Great job! Thanks so much for the step by step directions for the happy little thermometer
@exceldashboards
5 жыл бұрын
You are very kind. Thanks for the great comment!
@timmyp_NINERS
8 жыл бұрын
Thank you for this video. Helped me create a graph for my employees for a we are running at work.
@exceldashboards
8 жыл бұрын
You are very welcome. Glad to help!
@wayneedmondson1065
5 жыл бұрын
Nice Thermo Goal chart. Thanks for sharing it. Thumbs up!
@exceldashboards
5 жыл бұрын
Thanks!
@mamamidas55
6 жыл бұрын
This was a very helpful video thank you!!
@exceldashboards
6 жыл бұрын
Awesome, so glad to help! Thank you for your great comment!
@chreum9733
5 жыл бұрын
Very helpful, thanks a lot!
@exceldashboards
5 жыл бұрын
You are very welcome. Thanks for the great feedback!
@jiatonghan3420
7 жыл бұрын
This is very helpful, Thank you so much.
@exceldashboards
7 жыл бұрын
You are very welcome. Thanks for the great comment.
@KidscounselOrg
8 жыл бұрын
Thank you so much for this tutorial! It was amazing and my co-workers were impressed : ). I do have a question. The dollar signs on my y-axis have disappeared. How can I put them back? Thanks again
@exceldashboards
8 жыл бұрын
Change your number format of the axis to currency
@Jaynechch
8 жыл бұрын
Awesome - thanks heaps - I made one by following along with you - really easy but never would have done it on my own. Cheers. PS: Mine was for a debt reduction thermometer.
@exceldashboards
8 жыл бұрын
+Jayne Glynn Thanks for the comment. So if you are reducing debt, does your thermometer go up or down?
@Jaynechch
8 жыл бұрын
+exceldashboards It goes up just like yours - I put the total amount of debt at the top - it sounds weird but I think it will work - as the thermometer goes up it means I'm paying it off. :-)
@DesignsbyCADPRO
2 жыл бұрын
how do you copy into word documents or powerpoint with fields intake
@larakaye3354
6 жыл бұрын
THanks so much, This is terrific! I had one problem for some reason when I pasted the thermometer bulb it seemed to be grouped with the rest of the bar and therefore when I tried to match up the gap width, it would change across the entire thing and not match up. Any suggestions for how to ungroup those?
@exceldashboards
6 жыл бұрын
Hi Lara, your bulb may be on the wrong axis. Try selecting it and moving it to the other axis. That is my thought right off the bat :) Check the video and make sure the axis match mine.
@bingo111172
7 жыл бұрын
Great Videos...!!
@exceldashboards
7 жыл бұрын
Thanks bingo! I appreciated your comment.
@robinsteinshnider125
6 жыл бұрын
Great video! Is there a way to express progress to the goal as a percentage in addition to just a numerical value?
@exceldashboards
6 жыл бұрын
Yes, but depends on the version of Excel. If you have Excel 2016, you can add a Label that references a different cell. In that cell you can put both pieces of information. For Excel 2010, you can use this technique: www.exceldashboardtemplates.com/CustomDynamicLabels
@robinsteinshnider125
6 жыл бұрын
Thanks! I will give it a try.
@exceldashboards
6 жыл бұрын
Cool, good luck!
@hollywhitworth896
6 жыл бұрын
This was one of the best I have seen, so well done and thank you! My question/problem is that when I enter a number that is above sales goal the chart adds some green, but also moves the red bar (the goal, which in this example is $25,000)above our goal of $25,000...you see it in your video when you enter $27,000 as the sales number which this starts at the 13:10 mark of your video, your red sales goal bar jumps to approx $26,000 and the green fills in to approx $29,000....probably a simple fix for you, but for my simple mind, I can't figure it out. Help???
@exceldashboards
6 жыл бұрын
This is a bug/issue with the formulas, Very few people must hit 100% as only a few people have raised the issue. I need to create a new video showing how to reverse the formulas soon but can't remember the exact steps. If you look at the formulas, you will see the issue and I think we needed to reverse them. Maybe I can get that video developed next week as they take about 8 hours to develop and post..
@hollywhitworth896
6 жыл бұрын
No problem...thanks for the help....it was and is a great tutorial....I just can't figure it out...thanks again
@terrimccullers7140
5 жыл бұрын
@@exceldashboards Were you ever able to figure this out? I have the same problem.
@exceldashboards
5 жыл бұрын
Hi Terri, sorry I meant to make a video and it got away from me. For this file, the fix is as follows: 1) Create New Data Point Cell A8= text of "Current Sales Chart" in Cell B8 formula = MIN(B4,B2) 2) Click on Chart. Select Chart Design Ribbon. Click on Select Data Button. Edit Series 1. Change Series Value = B8
@exceldashboards
5 жыл бұрын
Hi all, I just posted a Tutorial and Video To fix the issue. Check out this post: exceldashboardtemplates.com/fix-sales-goal-error-of-excel-thermometer-chart
@OfficiallyRohanBlake
5 жыл бұрын
Awesome video but I am unable to do the grouping option. Not sure how else to do it. Is there another way?
@exceldashboards
5 жыл бұрын
You can create the picture in MSPaint or another drawing program and copy / paste it or save it as a file. Then insert the picture/drawing from paste action like the video shows or insert a picture from a file into the worksheet and then copy/paste into the chart as shown in the video. Good luck and thanks for the comment.
@ipunk99
6 жыл бұрын
Thank youuuuuu
@exceldashboards
6 жыл бұрын
You are welcome.
@sherylcollins6758
6 жыл бұрын
How can I get the actual sales raised figure to print out with a line pointing to the top of the moving part of the thermometer? I want it to show the actual dollar amount with an arrow or something and it would need to move/adjust every time the thermometer changes.
@exceldashboards
6 жыл бұрын
Hi Sheryl, interesting concept, i will add this to my list of topics for the future.
@osvaldocarmona1747
4 жыл бұрын
How come when you go above the goal, I noticed that the theromoster and the axis numbers shift and they are not matching. For example, do 40,000 and it wont match
@exceldashboards
4 жыл бұрын
Hi Osvaldo, please review this link and video: www.exceldashboardtemplates.com/fix-thermometer-error
@mahabom100
8 жыл бұрын
Great tutorial. However, for e.g. when the current sales exceeds by say $10,000 the whole graph shifts. the red part of the graph becomes greater that $25,000. How do you hold the red graph @ $25K while the green part added to beyond the 25K
@exceldashboards
8 жыл бұрын
Check your maximum axis value. That may be your issue.
@osvaldocarmona1747
4 жыл бұрын
@@exceldashboards this is the same issue I am having but it still doesnt add up
@osvaldocarmona1747
4 жыл бұрын
Yes, this fixed it!
@FrederickDomond
8 жыл бұрын
+jayne Glynn i am trying to do the same for my debt (Dave Ramsey baby step #2) anyway to do this in google spreadsheet? I have tried following the steps in this video but could not do it. Any help would be appreciated.
@exceldashboards
8 жыл бұрын
Been some time since I used Google spreadsheet, but their charting was not as robust. There may be a way, but might be easier to track it in Excel. Good luck
@larakaye3354
6 жыл бұрын
Thanks so much, Frederick. That was the issue!
@peytonsimpson4518
7 жыл бұрын
Can i do this in google sheets? I got close but I couldn’t do anything with a secondary axis
@exceldashboards
7 жыл бұрын
I don't believe you can do this on google sheet. But I haven't been in there in a few years, so maybe it is possible.
@TallahasseeTonya
7 жыл бұрын
Can I do this using words instead of number values? I'd like to create a goal chart to reach my "dream job".
@exceldashboards
7 жыл бұрын
Hi Tonya, yes you can. What word thresholds would you want to use?
@TallahasseeTonya
7 жыл бұрын
Adjunct, associate professor, assistant professor, professor, tenured professor
@peytonsimpson4518
7 жыл бұрын
The vertical axis is dates instead of currency
@exceldashboards
7 жыл бұрын
Hi Peyton, is that what you would like? Doesn't the dates get one day closer every day? Not sure what the goal is...to make it one more day?
@laulguildinc2749
7 жыл бұрын
There seems to be at least one step skipped between steps 3 and 4--Format Data Series only stacks 2 of the 3 series, but NOT all 3 series. How can one proceed with you if only 2 axis are stacked?
@exceldashboards
7 жыл бұрын
Hi Laul, did you find your issues? If you follow the video and also check out this post for detailed instructions. I don't believe I skipped anything. Let me know. www.exceldashboardtemplates.com/how-to-make-a-thermometer-goal-chart-in-excel/
@clairety-222
8 жыл бұрын
I got rid of those grid lines but now my boss wants them back. How do I add the horizontal grid lines back?
@exceldashboards
8 жыл бұрын
Hi Claire, click on the chart, then click on the Layout Ribbon and then Click on the Gridlines button.
Пікірлер: 58