#How to download visual basic for excel full

We will need to place the linked picture behind the template. Place the data bar linked picture over the template and line up the linked picture to the 0% and 100% position of the thermometer.

This will allow for us to easily line up the linked picture to the 0% and 100% position of the thermometer.

#How to download visual basic for excel full

Temporarily set the current value to the goal value so we have a full data bar in our linked picture. Now we just need to incorporate this linked picture of the data bar into our thermometer template. Add The Linked Picture To The Thermometer Template Now we can resize and rotate the picture to a vertical orientation with the filled part of the bar at the bottom.

Set the colour to the same Red colour as used in the thermometer template.

This will make the numbers in the cells invisible.

Set the rule type to Format all cells based on their values.

Most of the settings will already be set to what we need by default. This will open up the New Formatting Rule menu. Select cells C2:C3 ➜ go to the Home tab ➜ select Conditional Formatting ➜ Data Bars ➜ More Rule. Now, we’re going to add some conditional formatting data bars to these cells. The goal value can be hard coded since it won’t usually be changing. We can set the current value based off a formula or pivot table that references the current data and sums it up. We’ll need a current value and a goal value (shown in cells C2 and C3). Copy and paste this template into your Excel Workbook to add the dynamic parts and finish creating the thermometer visual. We’re done with PowerPoint and can head over to Excel. We can save this PowerPoint file and use the thermometer template again and again. This is our basic thermometer template finished.

Select one of the shapes then press Ctrl + A on the keyboard to select everything.

Send the rectangle behind the thermometer template. Select the rectangle shape ➜ go to the Format tab ➜ select Send Backward ➜ choose Send to Back from the options.

Add a Rectangle shape and change the Fill and Outline to red then place it over the circle part of the thermometer just below the 0% marking.

Place these text boxes next to the line markers.

Align the text for these boxes in the center using the Paragraph tools found in the Home tab.

Add labels for the key points (0%, 25%, 50%, 75% and 100%). Go to the Insert tab ➜ select the Shapes command ➜ select the Text Box and make 5 of these in total.

Select all 5 lines ➜ go to the Format tab ➜ select Align and then Align Left ➜ select Align and then Distribute Vertically.

Don’t worry about getting the position exact as we’ll be using the alignment tools for this.

Place the other 3 lines between the top and bottom line.

These need to be placed exactly where we want our thermometer bar to start and stop.

Make 5 lines and place two at the top and bottom of the thermometer.

To change the thickness of the line go to the Format tab ➜ select Shape Outline ➜ select Weight from the menu.

Go to the Insert tab ➜ select the Shapes command ➜ select the Line shape ➜ draw the line horizontally.

Add markers for key points on the thermometer using a line shape.

Select the shape ➜ go to the Format tab ➜ select Shape Fill ➜ select white from the menu.

Select the shape ➜ go to the Format tab ➜ select Shape Outline ➜ select black from the menu.

We will also change the colour from the default.

Select all the shapes ➜ go to the Format tab ➜ select Merge Shapes ➜ select Combine from the menu.

Create a larger rectangle and place the thermometer shape inside it.

Hold Ctrl and select both shapes ➜ go to the Format tab ➜ select Merge Shapes ➜ select Union from the menu. Place the small circle at the bottom of the rectangle and merge the two shapes with the union command.Go to the Insert tab ➜ select the Shapes command ➜ select the Oval shape ➜ hold the Shift key and draw the shape to create a circle. Go to the Insert tab ➜ select the Shapes command ➜ select the Rectangle: Rounded Corners shape ➜ draw the shape in a blank PowerPoint slide. Add a tall skinny rectangle shape with rounded corners.But once it’s created, we’ll be able to save it and use it over and over again. As I explained in my traffic light dashboard visual post, PowerPoint has some extra merge shape commands we need to use to combine and cut out our thermometer template.Ĭreating our thermometer template in PowerPoint will require quite a few steps using shapes, merge commands, alignment and grouping. We’ll need to head over to PowerPoint to create our thermometer template. Video TutorialĬreating A Thermometer Template In PowerPoint Let’s look at how we can build this thermometer visual from scratch in Excel (and PowerPoint).