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
Een reactie plaatsen