Hessel de Walle's Blog

Via my newspaper we discovered these chart on  http://www.people-press.org/2014/06/12/political-polarization-in-the-american-public/ We just wondered how to do this in Excel. Here is what we created: We did not have the right data, so we just estimated the figures: 1994 2014 Democrats Republicans Democrats Republicans Liberal11 0,4 0,0 4,1 0,0 Liberal10 1,4 0,1 5,3 0,4 Liberal09 1,6 0,2 5,8 0,6 Liberal08 2,8 1,3 6,8 0,8 Liberal07 3,2 1,9 7,0 1,2 Liberal06 5,6 2,3 7,2 1,6 Liberal05 6,2 3,0 7,4 2,4 Liberal04 7,6 4,2 7,8 9 4,0 Liberal03 8,0 4,9 7,6 4,4 Liberal02 8,4 6,1 7,2 4,8 Liberal01 8,2 9 6,4 6,0 5,...

Nice idea of the designer of my newspaper Trouw :  to present the category  Neutral   apart from the others. Also nice to make a chart like this in Excel : On the content I have no comments. You can download  Excel20141211English.xlsx  via: https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

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

I could not make it as nice as the original but it looks OK to me. Circumplex - model of relations among different value groups (following Schwartz 1992) And the original from  http://www.rwlnetwork.org/news/balance-%E2%80%93-an-example-for-using-frames-in-real-world-learning.aspx Here are the data: Inner Outer Benevolence 1 Intrinsic Values 3 Tradition 1 Conservation 2 Security 1 Extrinsic Values 2 Power 1 Openness to Change 2 Achievement 1 Hedonism 1 Simulation 1 Self-Direction 1 Universalism 1 You can download the file  ExcelCircumplex.xlsx  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Downloaden a milestones template from the Microsoft Office website: http://office.microsoft.com/en-001/templates/timeline-with-milestones-TC102930035.aspx To my opinion it needed some improvement. This is what I created: Compared to their version: I used the same data as they did for their example, with the last column changed and one added: DATE MILESTONE POSITION BASELINE BELOW BASELINE ABOVE 23-jan Project Start 25 0 #N/B 14-feb Milestone 1 10 0 #N/B 24-feb Milestone 2 -10 #N/B 0 1-mrt Milestone 3 15 0 #N/B 15-mrt Milestone 4 -15 #N/B 0 15-mei Milestone 5 15 0 #N/B 15-jun Milestone 6 -15 #N/B 0 30-jun Milestone 7 15 0 #N/B 15-jul Milestone 8 -20 #N/B 0 30-jul Milestone 9 20 0 #N/B 23-okt Milestone 10 -15 #N/B 0 31-dec Project End 15 ...

Bubble or pie chart or both? With the help of Excel VBA everything is possible! Here are the data: Bubble X Y Size A 1 3 3 B 3 3 3 C 3 1 4 D 1 1 2 Pie 1 Pie 2 Pie 3 Pie 4 8 5 3 8 5 1 7 2 6 2 4 3 4 4 3 3 5 5 3 2 You can download the file  ExcelGrafiekBel.xlsm  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

This chart shows thumbs up when the values are above average and thumbs down when the values are below: Here are the data: Month Values Qualification Average Above Average Below Average jan 130 C 79 130 0 feb 80 C 79 80 0 mar 56 D 79 0 56 apr 91 C 79 91 0 may 98 C 79 98 0 jun 59 D 79 0 59 jul 70 D 79 0 70 aug 86 C 79 86 0 sep 90 C 79 90 0 oct 38 D 79 0 38 nov 81 C 79 81 0 dec 69 D 79 0 69 You can download the file  ExcelThumbsUpDown.xlsx  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Pretty easy to create: Crystal Reports line chart with banded background, indicating good, average and bad: For this example I used the noordenwind database, the Dutch equivalent of the Northwind database. For the bands I used three formula fields: Good: 50000 Bad: 30000 Average: 40000 I created a stacked bar chart based on the three formula fields. The line chart presents the total sales volume per customer, limited to the country Germany. You can download the file  Graphbands.rpt  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Can you base a target line in a chart on just one value? Yes, you can! And will it expand dynamically? Yes, it will! Here are the data and no, there is nothing hidden: Month Value Target jan 60 60 feb 65 mrt 70 apr 75 mei 80 jun 85 jul 90 aug 95 sep 100 okt 105 nov 110 dec 115 You can download the file  ExcelGrafiekHerhaling.xlsx  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Gartner Magic Quadrant made easy: simply use a picture as background in a bubbel chart. The given example is even easier to create in Excel 2013. Here are the data: Aap -2 2,6 5 challengers Noot 2 2,4 10 leaders Mies -2 -1 5 visionairies Wim 2 -1 5 niche players Zus  1 1,3 10 Jet -1 -1 15 ability to execute Teun 1 1 5 completeness of vision Vuur -2 0,9 10 Gijs -1 -2 15 Lam 1 -1,1 5 Kees -1 1,4 10 Bok -2 -2 15 You can download the file  ExcelGrafiekKwadrant2010.xlsx or  ExcelGrafiekKwadrant2013.xlsx   through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Pretty easy to create: Excel chart with colored background, indicating good, moderate and bad: All we need is this data: Percentage Bad Moderate Good 1-5-2013 30% 65% 15% 40,00% 1-6-2013 60% 65% 15% 40,00% 1-7-2013 55% 65% 15% 40,00% 1-8-2013 60% 65% 15% 40,00% 1-9-2013 90% 65% 15% 40,00% 1-10-2013 85% 65% 15% 40,00% 1-11-2013 100% 65% 15% 40,00% 1-12-2013 60% 65% 15% 40,00% 1-1-2014 110% 65% 15% 40,00% 1-2-2014 80% 65% 15% 40,00% 1-3-2014 70% 65% 15% 40,00% and a combination of a line chart and a stacked bar. A stacked area chart could do the job just as well. You can download the file  ExcelGrafiekenAchtergrond.xlsx  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

At a course I got the question about a line in a chart. Isn't it possible to get a line from one side of the other? He was talking about the lower line which is an ordinary line chart. So I used some tricks to change it. Now the upper line is like he asked. You can download the file  ExcelGrafiekdoorgetrokkenlijn.xlsx  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

In this example I created a meter or gauge with two pointers. The pointers can be changes by using the scroll bars at the sides. This example presents age and labour market participation in the Netherlands. You can download the file  ExcelDoublePointer.xlsx through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Gebaseerd op een voorbeeld uit Graphic Presentation van Willard C. Brinton uit 1939, pagina 245. Hoe geef je veranderende rangorde in de tijd weer? In onderstaande voorbeeld heb ik dat toegepast op de verandering in aantal inwoners van de Nederlandse provincies sinds 1850. Het voorbeeld is te downloaden als ExcelProvincies.xlsx via https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Onderstaande Excel grafiek laat zien hoe langzaam maar zeker de gasvoorraad van gasveld Slochteren afneemt. Met behulp van de schuifbalk kunnen we in deze grafiek dat effect ook laten zien. Dan moeten we deze wel even downloaden. Het voorbeeld is te downloaden als ExcelZandloper.xlsx via https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

Op internet vinden we diverse Excel voorbeelden en sjablonen van zogenaamde thermometer grafieken. In alle voorbeelden die ik kon vinden, wordt er gebruik gemaakt van SmartArt om de bol van de thermometer te maken. Als je dan meer thermometers naast elkaar maakt, wordt het bewerkelijker. Bovendien staat de SmartArt bol los van de grafiek. Zodra je de grafiek verplaatst of de breedte verandert, gaat de bol niet mee. In mijn voorbeeld heb ik de bol gemaakt met behulp van een lijngrafiek met markeringen. Van de markering kun je dan een bol maken. Deze bol kun je opblazen. En klaar is kees. Je kunt dan probleemloos het aantal thermometers opvoeren en de grafiek groter en kleiner maken. Hoe maken we deze grafiek? §   Neem vanaf rij 32 de bovenstaande gegevens over of open het blad Thermometer . §   Selecteer de rij lijn met alle nulpunten. §   Kies Invoegen Þ Lijn Þ Lijn met gegevensmarkering . ...