fbpx
Search
Close this search box.

Visualization Challenge – How to show market share changes?

Share

Facebook
Twitter
LinkedIn

One of our readers Jennifer mailed me with this excel charting problem she is having. I thought why not ask other readers for their advice on this. So here it goes:

The Charting Challenge – Visualizing Changes in Market Share

Here is an excerpt from her email:

The gist of my problem is how to show change-in-market-share between time period 1 and time period 2 for two different products in the cleanest, easiest-to-grasp way.

One of the restrictions that I have are that I have to somehow show both the fact that the mkt shares add up to 100%, and the changes.

However, I am concerned that the main takeaways; increases in competitor 1 is being driven by decreases in competitor 2 … might get lost.

The sample data along with the initial graphs she has built are shown below:

product-market-share-data market-share-product-2

you can access the market share data at this shared google doc.

Now, the question for you is: How would you improve this graphs to bring out the message?

Here are few ways I could think of:

  • Reversing the competitor order to 1 at bottom and 5 at top so that comparison can be easy
  • Changing the stack overlaps from partial to full so that the step-case look can be removed.
  • Instead of stacks, using regular bar charts with 5 sets of columns, 1 each for a competitor and using colors to bring contrast between period 1 and period 2.

Your turn…

PS: you can post images in comments by uploading the images to a free site like flickr or photobucket and then copy pasting the image link in the comment box.

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.

17 Responses to “Visualization Challenge – How to show market share changes?”

  1. Dan says:

    Sorry if this is a duplicate comment -- wordpress returned an error that said I am not authorized to access comments.php? Maybe because I tried to insert the photobucket link w/embedded image?

    Anyway, let's try again:
    I'd put two charts together for each product highlighting gain/loss on the left and before/after on the right.

    http://i376.photobucket.com/albums/oo206/thenoob666/marketshare-1.jpg

  2. Tony Rose says:

    I might go with a simple column or bar chart that only shows the change in market share by competitor with maybe a total market share label. I would not use stacked bars because the baselines are different after the first segment, which makes a comparison difficult.

    I will try a sample when I have a few minutes.

  3. Jennifer says:

    Chandoo --- Thanks for posting this.
    And Robert, thanks for the pointer to the bump charts. I had never seen them before. I gave them a try with my data and really like the results.
    You can see it here:
    http://i453.photobucket.com/albums/qq251/sollje2002/bumpchart_example.jpg

  4. [...] been sitting on for two months. Back in September, Chandoo presented a difficult problem: Visualization Challenge - How to show market share changes? Specifically, how to show the change in market share among five competitors, for two [...]

  5. Jon Peltier says:

    After sitting on this one for almost two months, I have finally added my 2¢ in Challenge - Show Market Share Changes.

  6. Chandoo says:

    @Jon: thanks for your post. It is surely very insightful 🙂

  7. [...] the visualization challenge “how to show market share differences?” we had a while back? Well, Jon Peltier revisits this with a whole set of options. I suggest [...]

  8. [...] Visualization Challenge - How to show market share changes? our colleague Chandoo presented the following data and challenged his readers to display it [...]

  9. nixnut says:

    Hello Chandoo - I've posted another solution at Jon's Blog (see link two posts up) and Jon suggested I post a note here as well. -- regards nixnut

  10. [...] Challenge - Show Market Share Changes I suggested a panel chart in response to Chandoo’s Visualization Challenge - How to show market share changes? In Explore Your Data With Pivot Tables I showed how a simple pivot table analysis could lead to [...]

  11. [...] Almost 2 months ago our reader Jennifer sent me an email asking if there is an effective way to present market share changes between two periods for 2 products among five competitors.  I have replied her promptly with whatever I could think of as better ways to present the data. But I also posted a visualization challenge: How to show market share changes? [...]

  12. Bharath Vullanki says:

    gr8 work done Chandoo(MVP)...
    Kudo's Jon, nixnut, Dave
    I'm 1st year student from NITIE and I really liked your passion for data visualization...
    Hope you come up with such real time tricky problems which involves lotz of man power into this...
    I thought of leaving you guys a complement over here...
    Thanks a lot of you guys...

    • Chandoo says:

      @Bharath: Welcome to PHD. I really like NITIE even though I have been to the insti only once for few hours in 2003 for GDPI. It is peaceful and soothing amidst the buzz of Mumbai. Hope you are having a great time there.

      We have several discussions on visualizations and related topics almost on weekly basis. Do chip in with your views and suggestions and see how you can learn and share.

  13. Ahmed says:

    Hi Chandoo, I have looked to the above concept for measuring the Markt share, but that little bit not updated in matter of charting ( i mean not advance) , i have subscribed to the Excell lessons, but i didnt see any dashboard helping in analayzing market share for products.. Do you have any new format/templates for that purpose?

    Thanks
    Ahmed

  14. William Kiarie says:

    I think the stacked column chart should serve the purpose but data bars from Conditional Formatting would also work
    http://i1025.photobucket.com/albums/y311/Kiarie_William_Njihia/mktshare_zpsdjn6dpd6.png?t=1439451727

Leave a Reply