maandag 20 oktober 2014

Excel: Multi Thermometer Graph

On the Internet, I found several examples of Excel thermometer charts. In all the examples I could find, people use SmartArt i.e. shapes to create the ball of the thermometer. The more thermometers you then create, the more laborious. Moreover, the SmartArt ball is independent of the graph. Once you move the graph or width changes, the ball is not coming with it.

In my example, I created ​​the ball using a line chart with markers. The marker you then change into a ball. The size of this ball you can increase. And it's done. You can then smoothly increase the number of thermometers.



You can download the example file ExcelThermometer.xlsx via

https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Een reactie posten