Doorgaan naar hoofdcontent

Posts

Posts uit april, 2014 weergeven

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

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

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

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