+91-8826547882

Thermometer Chart in Excel

Thermometer-Chart

In this article we will create a cool thermometer chart in excel. In this type of chart you can represent the data that show the percentage of a value. It keeps a track of a single variable (for e.g. Number of product sold or sales goal etc.)

Click here to download the template.

To create the chart, select the cell with percentage value.

 

Thermometer-in-excel-image1

Now in the Insert tab under Chart panel, click Column, and select the column clustered chart.

 

Excel-Training-in-Excel-Thermometer2

Now your chart will look like this.

How-to-create-chart-in-excel3

Reduce the Gap width to 0% of data chart. Right click on the blue data bar and click Format Data Series, now change the Gap width to 0%. Delete the legend.

Thermometerchart4

In the same way by selecting the plot are you can change the background fill color to black.

Now right click on the left axis, click on the format axis option.

In the axis option box, click on the fixed radio button of maximum option and type 1 in the text box.

Thermometerchart5

Now your column chart will look like this.

Thermometer-chatr-In-Excel6

Now to give better look to the chart you can insert the oval at the bottom of the chart.

To Insert, Click on the Insert Tab > Click shapes and select the oval.

How-to-column-chatr7

January 14, 2014

0 Responses on Thermometer Chart in Excel"

Leave a Message

Your email address will not be published. Required fields are marked *

© copyright www.excelcrazy.com. All rights reserved. Design and Development by www.creativebrainweb.com

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Location (required)

Your Message for us...

captcha