• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

5. Charting Hacks > 55. Hack Together a Simple Thermometer Chart

Hack Together a Simple Thermometer Chart

Excel doesn’t provide a thermometer chart. If you want one, you’ll have to construct it.

By using the Chart Wizard to create a basic clustered column chart that compares values across categories, and then manipulating the various chart elements, you can create a visual, workable thermometer chart with little effort.

Set up some data, such as that shown in Figure 5-20, and use the Chart Wizard to create a basic clustered column chart, charting the data in rows. We used the range B3:C4.

Series data and creation of basic clustered column chart
Figure 5-20. Series data and creation of basic clustered column chart

Remove the legend and the gridlines (click them to highlight them, then press Delete), and format the Temperature Data Series to the Y2 axis. Do this by selecting the series, right-clicking, selecting Format Data Series


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint