fbpx
Search
Close this search box.

and the Winner is…

Share

Facebook
Twitter
LinkedIn

Finally the winner for our first visualization contest is decided. It is… Cuboo.

Center Level Performances Along with Cumulative Values

Full Image

The entry by MB (#6) came a close second.

Simple and Easy to Read

Full Image

All the participants will receive a copy of my excel formulas e-book while Cuboo gets a copy of The Visual Display of Quantitative Information by Edward Tufte.

All in all there are several great entries suggesting a good variety to present budget vs. actual performance. Go check them out.

A Month ago I got a request from a reader asking me what is the best way to visualize budget vs. actual performance? I didn’t have any ready made answer for him. So I posted a visualization challenge, inviting contributions from my readers.

I got several responses and I am still not sure which one of them is best. So I have asked you to vote for the best visualization among all. And you selected Cuboo as the winner. Congratulations!

Many thanks to all my readers and contributors for making this a memorable and learning experience. I have learned several fun and interesting charting tricks looking the contest entries. I hope you had similar experience.

Have a Charting Problem and need some help?

Write to PHD by posting a comment or e-mail me at chandoo.d @ gmail.com. I a bit sloppy on emails these days, but I always star your mails and revisit them during weekends and send a response. So…

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

11 Responses to “and the Winner is…”

  1. [...] ggplot2: Budget vs Actual Performance 2009 April 23 tags: barplot, business, chart, data, excel, ggplot2, manipulation, reshape, zoo by learnr A reader of a Pointy Haired Dilbert blog enquired about best ways to visualise budget vs. actual performance. In response PHD challenged his blog readers to contribute their visualisations made using Excel or Google Docs spreadsheets, and later picked the winner. [...]

  2. Michael Pierce says:

    Any chance that someone has an Excel version of the winner?

    Also...looking back at the contest, I notice that all of the data is *under* budget. It would have been nice to see what folks would have done with entries that are over budget.

    • Chandoo says:

      @Michael: The charts that Cuboo made are inspired from here: http://www.hichert.com/227644/126291.html if you go to that site, there are several very good examples of excel charts that you can download and play with. The site is in German, so I could understand little. But I believe the formulas and charts should work anywhere nevertheless.

      I agree that the data was kind of skewed. I guess we would have seen few different alternatives if the data had a mix of both below and above budget values.

  3. Sumeet says:

    All the participants will receive a copy of my excel formulas e-book. Pls send me the ebook.

  4. [...] habe gewonnen … die Leser des Blogs “Pointy Haired Dilbert” haben meine Lösung als beste [...]

  5. cuboo says:

    Sorry for answering so late ... I was on holiday!
    Thank you for choosing my solution ... good to see that simplicity rules.
    You find the .xls-file for Excel 2003 at the end of this post:
    http://cuboo.wordpress.com/2009/04/05/excel-visualisierungs-oomph-oder-how-to-visualize-planist-abweichungen/

    The cumulative view of all centers I took from the Hichert+Partner website: http://www.hichert.com/Excel-Beispiele/511.xls
    As chandoo mentioned you find more examples of their incredible
    visualizations with Excel here:
    http://www.hichert.com/227644/126291.html

    @Michael: If actual values are over budget, the bars in my solution will turn red, of course.

    • jan says:

      @ cuboo: hi, very good solution.
      I can open the link for the excel file in your blog, could you please share it again

  6. [...] Um gráfico construído seguindo as regras SUCCESS ganhou o primeiro lugar numa competição de melhor visualização de dados planejados vs. realizados http://chandoo.org/wp/2009/04/21/budget-vs-actual-winner/ [...]

  7. Sean says:

    Hi Cuboo,

    This is some great work. I have a slight "glitch" when I open this file in Excel 2007. On the "Cum. View" tab, the series "neg", which are the small green blocks at the end of each budget bar, they are not lining up with their corresponding grey bars. They are aligned horizontally, but are ALL vertically below the grey bar, should be aligned to the middle of the bar (looking at the snapshot).

    What's interesting is that when I immediately open the file, EVERYTHING IS ALIGNED, then it does something for about .5 seconds and then the green bars drop down.

    http://www.flickr.com/photos/seanmcnair/4892342268/

    http://www.flickr.com/photos/seanmcnair/4892342242/

    Any thoughts how I might correct?

  8. jan says:

    could you please share us that excel file?

  9. Paul Adams says:

    Hi,

    Where can I get a copy of this spreadsheet?

    Paul

Leave a Reply