How to visualize multiple variables over several years? [Contest]


Kaushik, one of our forum members has an interesting problem.

Need to quickly visualize 3 variables ( Company, years, Financials) in a single […] chart.

Multiple variables over several years – How to chart?

Let’s take a look at the data first.

multiple-variable-data

Ways to visualize such data…

Whenever you want to visualize business data, the first thing to ask is,

  • What is the purpose of this visualization?

Related: How to create right chart from your data?

Since we don’t know why Kaushik wanted to visualize all 100 numbers in a single chart, let’s define some goals for the chart.

  • Yearly trends of financial metrics
  • How one company compares with another over years
  • How individual metrics contribute to overall revenue (all the 5 metrics add up to 100)
  • What are the most interesting numbers, drastic changes or alarming trends

One way to answer these questions is thru a panel chart. It shows massive data in a concise chart and allows for exploration of inter-relationships.

See below.

Absolute trends:

Made with sparklines.

panel-chart-yearly-trends-multivariable-data

Indexed Trends:

And of course you can use indexed charts technique to explore the numbers better.

panel-chart-indexed-trends-multiple-variables

Your challenge – How would you visualize this data?

So here is something fun for you. Visualize this multiple variable data and share your charts.

What’s in it for you?

This is a contest. The two most awesome charts will $100 Amazon Gift Cards.

How to submit your entries:

  • Simple. Download the data workbook.
  • Create your chart in a new tab.
  • Email your files to chandoo.d@gmail.com with the subject “Multiple variable challenge”
  • Send in your entries before July 4th, 2016 (Monday).
  • We will showcase all the entries and pick winners by July 11th.

Fine print:

  • You may submit multiple entries, but you can maximum of one gift card.
  • No VBA based solutions. Excel or Power BI charts are ok.
  • If you cannot accept Amazon gift card (because of where you live), you can opt for $100 cash thru PayPal.

Get busy charting…

Chandoo

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

15 Responses to “How to visualize multiple variables over several years? [Contest]”

  1. Chirayu says:

    I was the first to reply to the thread on the forum 🙂 Downloaded your workbook & thought it was a cool concept but 2007 can't see sparklines. Wondering if I can just submit the one I already answered in the forum. I'll probably add a bit more flashiness to it though

  2. Chandeep says:

    Hi Chandoo,
    For Ultratech Cement all values are not adding up-to 100. Check the total of the values in
    2011 (102)
    2013 (90)
    2014 (95)
    2015 (96)

  3. Blaz says:

    Cannot wait to see your attempts! :=)

  4. Santosh says:

    Looking forward for the results.

  5. Marcel says:

    Yeah... any news on this?

  6. Paul says:

    Chandoo, how about results ?

  7. Santosh Chaube says:

    Any updates , when we can get to see the contest results

  8. Blaz says:

    Chandoo, did you mean to publish results on July 11th 2017? 🙂

  9. Tobias says:

    I think a lot of people are keen to see the results that will be "showcased by July 11th".

  10. Arnaud says:

    Hi Chandoo,

    Can you give us a feedback about expected date to communicate the results of the contest ?
    Thank you Chandoo.

    Arnaud

  11. DME says:

    Hi Chandoo,

    Hope all is well. Will the contest winners ever be announced? I know we're all looking for an update, so hoping to hear something soon.

    Enjoy your weekend,

  12. Danish boy says:

    Hi Chandoo,

    Hope all is well also. I am sure you red the comments ; we are all looking for the results ... Or just an answer from you, in a first time. Almost 2 months and no word from your side.

    Enjoy NZ.

    • Chandoo says:

      Hi Danish Boy and other participants. I am deeply sorry for the delay in publishing the results. The move to NZ has thrown a wrench to my work and I am slowly getting back to regular schedule. I will be publishing the results next week as everything is already compiled and ready to go.

  13. Kelly says:

    Hi Chandoo,
    I'm keen to check out the results from this, has anything been published yet...?

    Thanks,

Leave a Reply


« »