+ Reply to Thread
Results 1 to 6 of 6

Month on Month for several destinations AND several months

  1. #1
    Forum Contributor
    Join Date
    06-04-2015
    Location
    Bangkok, Thailand
    MS-Off Ver
    2013
    Posts
    175

    Month on Month for several destinations AND several months

    Hi all experts

    I'm having some trouble coming up with a visualization of the following data (attached).

    I have several countries and I have april to dec 2016 and 2017.

    I'm trying to figure out how to visualize this data without it being too cluttered.

    The main idea is to see compare each country month on month, so apr 2016 vs apr 2017.

    Trying to show how our countries have done compared to last year.

    The cleanest way (that my small brain can think of) is to do each one separately and make sort of dashboard.

    But I am hoping there must be a way to visualize this in 1 graph.

    Thank you so much in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Month on Month for several destinations AND several months

    See if this is close to what you are wanting
    Select a country from the dropdown in cell in B2 to see the side by side comparison in the table and the graph.
    tryingtoexcelatexcel-month-on-month-for-several-destinations-and-several-months-visualize.xlsx
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    06-04-2015
    Location
    Bangkok, Thailand
    MS-Off Ver
    2013
    Posts
    175

    Re: Month on Month for several destinations AND several months

    Hi GMR,

    Thank you very much. But I would need it more in a static format. For my higher ups they would need to have it simple to visualize and able to put into PPT. But I do like the approach very much.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Month on Month for several destinations AND several months

    Ok. I'll see if I can modify it for a static format instead.

  5. #5
    Forum Contributor
    Join Date
    06-04-2015
    Location
    Bangkok, Thailand
    MS-Off Ver
    2013
    Posts
    175

    Re: Month on Month for several destinations AND several months

    I was trying to think it through, but it might have to be combining the offices. So maybe do a graph for, japan korea, south asia, south east asia, taiwan, europe, china hk, and americas. Unless you can think of a way to combine them all? I'm not too familiar with bubble graphs and other more advanced techniques (im using 2010 excel) but if there was a better way to visualize then maybe I don't need to combine all offices? Still scratching my head.

  6. #6
    Forum Contributor
    Join Date
    06-04-2015
    Location
    Bangkok, Thailand
    MS-Off Ver
    2013
    Posts
    175

    Re: Month on Month for several destinations AND several months

    Hi All, just wondering if anyone might have another suggestion on how best to tackle this? Thank you very much in advance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  2. Within the month of X in the last 12 months
    By sdjames1979 in forum Excel General
    Replies: 1
    Last Post: 09-09-2015, 05:56 AM
  3. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  4. [SOLVED] Counting & summing formula (until last month,this month,until this month..
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2014, 01:14 PM
  5. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  6. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  7. Replies: 1
    Last Post: 11-22-2011, 08:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1