I'm trying to create a thermometer style graph so i can so the progess of a goal. Does anyone know how to do this?
This one might be hard to explain. I'm trying to create a status bar
(mine is shaped like a thermometer and it fills in red) where the cells
fill in using Conditional Formatting.
The user enters 2 numbers, the larger number for the max value of the
thermometer (i.e. 90 degrees F, and a smaller number for the current
status (i.e. 30C). Whatever values the user enters, the values labeling
the thermometer should automatically fit that data, and the cells
beside fill in with a red color.
I currently have it working but I'm looking for a more accurate formula
not using macros that works for a greater variety of numbers. Here is
how it is setup now:
- The cell next to the top of the thermometer (B8) is set to what the
user enters for a max value (i.e. 30)
- The bottom cell (B38) is set to 0.
- The cells inbetween (minor ticks) use this formula:
=B8-($B$8-$B$13)/5 (this is for B9)
- B13 and every 5th cell below it are the major tick marks:
=ROUND(B13-$B$8/6,0)
- the cells to be colored, i.e. D8, a =IF(B8-1<$G$37,1,0) where G37
is the current value the user entered) so if the value is one
Conditional Formatting sets the color to red, or else it stays white
It works well for max values greater than 10, but below that the status
bar doesn't exactly fill up to where it should. I can send you the file
if you email me if this is unclear! Thanks!
I am trying to create a chart that looks like a thermometer. I used the instructions for a web page online. It shows how to do the charting and copy a picture of a thermometer onto the data point creating the look of a thermometer. My problem is that the image is not transparent when you link it to the data point. IT is on the worksheet itself.
Also. I am using a spinner control. I am trying to make it increment by .5. Is that possible.
Thanks
I am trying to create a chart that looks like a thermometer. I used the instructions for a web page online. It shows how to do the charting and copy a picture of a thermometer onto the data point creating the look of a thermometer. My problem is that the image is not transparent when you link it to the data point. IT is on the worksheet itself.
Also. I am using a spinner control. I am trying to make it increment by .5. Is that possible.
Thanks
New here. Also trying learn excel. Not even sure if there is such a name for a chart. I have seen it when they do fund raisers with the goal and the amount recieved so far. Need to build a chart that shows total services due, and on the same bar show the number of services completed, and as more are completed the bar moves up closer to the total due.
Thank you for the assistance.
How do I do this? I see instruction for 2003 but not 2007.
I am using the Thermometer template that was suggested on my other thread (from Andy Pope).
It works great, except that the thermometer is not translucent and overlaps the "Mercury" bar.
Is there a solution for this? It's not the case in the template, but I can't figure out how to "bring the mercury forward" so that it shows through the thermometer like the example.
Please help!
Kate.
I am working on an Excel spreadsheet that will work like a list of things I want to accomplish and then check off. Here is how the spreadsheet is set up: Start (Cell C4) type in the start date; Today (Cell C5) =NOW(); To Go (Cell C6) =E4-C5; End (Cell E4) = C4 + 365 (the number of days). Column B lists the number(s) of items on my list; Columns C, D, E, F, G and H cover my list (I had to "merge" some cells in Columns C, D,E, F, G and H in order to fit some of my sentences; Column I is where I put my check box(es), each check box is linked to the cell it appears in.
My question is, I want to create a thermometer chart linked to each check box, so that when I check off an item as "finished", my row will first change color (I use conditional formatting to change each "finished" row to maroon) then when I check the check box, my thermometer chart will automatically show the percentage of items that are done. My problem is, I can't find the right items to highlight to create the thermometer chart (I want the chart to be horizontal rather than vertical and to show the percentages). I have tried highlighting the entire spreadsheet, and I have tried just highlighting my row lists (with the row number and check box included in the highlighting) and nothing works right. Please help!!!
Hi all, new to the forum. I have completed a "thermometer" chart in excel 2003 but I want to add a goal line. I created a secondary data set (e.g. all data set at the goal of 80%) thinking that would create a goal line across the 80% level, but it only added one point in the middle of the bar. Is there a way I can get that goal to display across the chart (other than just adding a manual line in)?
Access has very limited charting for what I need to produce.
I need to produce a scatter chart from my query - but i need the functions that excel offers that access doesn't.
Is there a way to link an access query to an excel ole object inserted into a form?
Data:
I have one column of X values
I have one column of Y values
I have 3 series (1,2,3)
Thanks!
How to Make a Thermometer Chart in Excel