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:

MonthValueTargetjan6060feb65mrt70apr75mei80jun85jul90aug95sep100okt105nov110dec115
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-22,65challengersNoot22,410leadersMies-2-15visionairiesWim2-15niche playersZus 11,310Jet-1-115ability to executeTeun115completeness of visionVuur-20,910Gijs-1-215Lam1-1,15Kees-11,410Bok-2-215
You can download the file ExcelGrafiekKwadrant2010.xlsx or ExcelGrafiekKwadrant2013.xlsxthrough

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:

PercentageBadModerateGood1-5-201330%65%15%40,00%1-6-201360%65%15%40,00%1-7-201355%65%15%40,00%1-8-201360%65%15%40,00%1-9-201390%65%15%40,00%1-10-201385%65%15%40,00%1-11-2013100%65%15%40,00%1-12-201360%65%15%40,00%1-1-2014110%65%15%40,00%1-2-201480%65%15%40,00%1-3-201470%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