Creating a Thermometer Graph or Chart Template in Excel 2007

Updated on October 13, 2016

Introduction

The genesis of my latest Excel 2007 article is a little unusual. I was looking at some of the searches people used to find my other Excel 2007 articles and saw a search for thermometer chart Excel 2007. I had never heard of such a chart and promptly looked it up. Curiosity well and truly tweaked, I decided it would be fun to build my own. Along the way, I learnt not only how to create what I think is a very nice thermometer chart, but also learnt some new Excel 2007 tricks along the way. As Homer said, “the Journey is its own reward”. Our goal is to create a thermometer graph as shown below, so let’s get cracking.

Completed thermometer chart or graph created in Excel 2007.
Completed thermometer chart or graph created in Excel 2007. | Source

Creating a Thermometer Chart

  • Into a cell in your spreadsheet, type in the current total raised.
  • Select your cell and then
  • Select Column from the Charts group on the Insert tab
  • Select 2-D Column and then Stacked Chart
  • Excel will create a chart similar to the one shown below

The beginning of the thermometer chart a 2-D stacked column chart.
The beginning of the thermometer chart a 2-D stacked column chart. | Source
  • Select Series1 (the legend) and hit Delete
  • Click on the graph so that the Chart Tools tabs appear and select the Axes button from the Axes group on the Layout tab. Select Primary Horizontal Axis and thenNone
  • Again on the Layout tab,selectthe Gridlines button in the Axes group. Select Primary Horizontal Gridlines and select None.
  • Right click on the blue column in your graph and select Format Data Series
  • On the Series Options tab, select a Gap Width of zero
  • Click on the Fill tab and select Gradient fill and select Fire from the Preset colours
  • Next, select Border Colour and click Solid line. Choose a colour (I used a dark red)
  • Click Close to return to our graph or chart

You can see from the figure below that our chart / graph has now changed a lot

The thermometer chart begins to take shape
The thermometer chart begins to take shape | Source
  • Select the whole graph and resize it to make the column thinner and longer as shown below

Chart becomes more thermometer shaped.
Chart becomes more thermometer shaped. | Source
  • While still selecting the whole graph, right click and select Format Chart Area
  • Select the Border Colour tab and selectNo line

The next step is a little fiddly. Select the numbers on the vertical axis so that your graph / chart looks similar to mine below

How to select the vertical axis in Word 2007.
How to select the vertical axis in Word 2007. | Source
  • Right click and select Format Axis and then on the Line Colour tab, select No line. Keep the dialogue box open for the next step
  • Now we are going to adjust the numbers on the vertical axis. Click on Axis Options. Depending on your total you may wish to adjust the Maximum and the Major unit to suit, select the Fixed button and adjust as you see fit. In my case, I changed the Maximum to 1,000,000 and left the others fixed at their default values
  • Next, we need to remove the zero on the vertical axis. Once again, select the vertical axis and right click and select Format Axis. Click on the Number tab and select Custom. Type in 0;0; and click Add. Select it under Type and click Close. It should have looked like my screenshot below and the zero should disappear

How to remove the zero from the vertical axis in Excel 2007.
How to remove the zero from the vertical axis in Excel 2007. | Source

There is one final change you can make if it suits your purposes. You can have the numbers of your target (the vertical axis) either on the left or the right. To do this,

  • Select the graph and on the Chart Tools Layout tab, select Axes and then Primary Horizontal Axis. Select Show Right to Left Axis and the numbers will flip to the right hand side.

Now we are finished with the graph and we will begin to add shapes to make it look like a thermometer. First we will add the circle at the bottom.

  • On the Insert tab, select Shapes in the Illustrations group. In the Flowchart group, there is a circle that we will use for the base of the thermometer.
  • Place your circle at the base of your column and resize until it looks right.
  • Right click and select Format Shape. Select the Fill tab and choose Colour. Next click on Line Colour and select the same colour for the line

Next, we are going to add a rectangle above the column (otherwise all that white space looks a little weird)

  • Again on the Insert tab, select Shapes in the Illustrations group. Select a rectangle from Rectangles and draw a rectangle that extends your column upwards towards your goal.
  • Right click your rectangle and select Format Shape. Select the Fill tab and choose No fill. Click on Line Colour and use the same colour as you used for the line around your column. Also, click on Line Style and change the Width to 1pt.
  • To add check marks to each milestone (in my case every 100,000) click on the Insert tab, select Shapes in the Illustrations group and choose a line in the Lines group.
  • Move the line to the correct position and then right click on it and select Format Shape
  • Select Line Colour and select Solid line and choose white. Click Line Style and change the Width to .75 pt
  • Repeat the above two steps to create as many check marks as you need
  • Finally, we will create the frame for the thermometer and remove the gridlines.
  • On the Insert tab, select Shapes in the Illustrations group. Select a rounded rectangle from Rectangles and draw a rectangle the covers your thermometer
  • Right click your rounded rectangle and select Format Shape. Select the Fill tab and choose No fill. Click on Line Colour and select a colour that suits (I chose Orange)
  • Finally turn off gridlines by clicking on the Gridlines checkbox in the Show / Hide group on the Views tab

Now we have finished our thermometer and it should look something like mine below.

The finished thermometer chart created using Word 2007.
The finished thermometer chart created using Word 2007. | Source

Conclusion

I hope you enjoyed creating your thermometer chart or graph and that you also hit your target whatever it happened to be. Along the way, I also hope that you learnt a few new tricks in Excel 2007 as I did while creating mine. If you would like to know more about creating shapes or using graphs in Excel 2007 I have two additional articles, the first is on creating charts and graphs in Excel 2007 and the second is on using shapes in Excel 2007. Please feel free to leave any comments below and thanks again for reading!

Questions & Answers

    Comments

      0 of 8192 characters used
      Post Comment

      No comments yet.

      working

      This website uses cookies

      As a user in the EEA, your approval is needed on a few things. To provide a better website experience, turbofuture.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

      For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://turbofuture.com/privacy-policy#gdpr

      Show Details
      Necessary
      HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
      LoginThis is necessary to sign in to the HubPages Service.
      Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
      AkismetThis is used to detect comment spam. (Privacy Policy)
      HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
      HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
      Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
      CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
      Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
      Features
      Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
      Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
      Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
      Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
      Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
      VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
      PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
      Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
      MavenThis supports the Maven widget and search functionality. (Privacy Policy)
      Marketing
      Google AdSenseThis is an ad network. (Privacy Policy)
      Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
      Index ExchangeThis is an ad network. (Privacy Policy)
      SovrnThis is an ad network. (Privacy Policy)
      Facebook AdsThis is an ad network. (Privacy Policy)
      Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
      AppNexusThis is an ad network. (Privacy Policy)
      OpenxThis is an ad network. (Privacy Policy)
      Rubicon ProjectThis is an ad network. (Privacy Policy)
      TripleLiftThis is an ad network. (Privacy Policy)
      Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
      Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
      Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
      Statistics
      Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
      ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
      Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)