woensdag 30 april 2014

Excel: Chart With a Target Line Based on Just one Value Which Expands Automatically

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

dinsdag 29 april 2014

Excel: Gartner Magic Quadrant Made Easy

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

dinsdag 22 april 2014

Excel: Chart with Background indicating Good, Moderate and Bad

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

woensdag 9 april 2014

Excel: Chart With Line From One Side To The Other

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