1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Advice on best visualisation of progression levels?

Discussion in 'Discuss Data Visualizations and Charting' started by Nightlytic, Jan 31, 2018.

  1. Nightlytic

    Nightlytic Member

    Messages:
    107
    Hi,

    (Excel 2010, limited to excel use only, other than maybe fixing a graphic with photoshop or what have you)

    So I would just like to ask for some advice because I'm all out of creativity. It's midweek blues.

    I have a table with staff promotions. There are 6 staff levels ranging from junior to executive and I'd have data on how many were promoted (moved on to the next staff level) last month, or total year to date. It's fair to assume that nobody skips a step, Junior (1) will be assistant manager (2), then manager (3), and never skip right from junior (1) to manager(3), so I'm almost thinking of a chart with steps, showing the number that went into each level. Can't see anything fitting though within excel charts or smart art!

    Bottom line is, I need to show at a glance (for a presentation) how staff moved up to different bands, and ideally there would be arrows to very strongly imply that yes, if a junior moved to assistant manager, there is now one less junior down there! At the same time I don't just want to plop down "Juniors -1" because then people go off tangent, start thinking a junior handed in their 4 week notice or something! Not what I'm getting at. Clear chart, just 6 figures really but visualising the progression/relationship.

    And I suppose a little nice to have is if you can come up with something original for me :) I have a pretty big MI pack there and there are a lot of tables, bar charts, stacked bar charts, line graphs, waterfall charts,information cards and all that sort of stuff. Would love something a little unique. I don't have any self-made graphics or smart art, I guess.
    Last edited: Jan 31, 2018
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,558
    Without sample workbook, hard to give you help. Upload sanitized sample which mirror your actual set up.
  3. Nightlytic

    Nightlytic Member

    Messages:
    107
    Hi Chihiro,

    I created a dummy table, and a bit of an example of a chart I had in mind myself but Idk. It doesn't look professional enough or maybe it's just that to me it doesn't seem to portray the information at a glance. It's just 6 numbers, if anybody asks what they are then I failed miserably at presenting them, huh?

    Thanks for the help

    Attached Files:

  4. Nightlytic

    Nightlytic Member

    Messages:
    107
    I should have caveated the dummy data, there are months there which immediately imply patterns. But nobody wants the pattern for these. It’s the last month movement and year to date total that matter. I will probably visualise one, and give the other on the side as a list. Say a chart of the last months movements on top left of the slide, and the YTD totals to the right.


    I might even give a little list below of where people were promoted (teams, geographical areas, whatever I find). My request is mainly for an innovative but relatively clean way to visualise the movement.
  5. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,558
    Hmm, there really isn't enough context to make this meaningful chart/visual.

    Though you could use funnel chart, waterfall chart etc.
    upload_2018-1-31_11-44-14.png

    upload_2018-1-31_11-44-30.png
  6. Nightlytic

    Nightlytic Member

    Messages:
    107
    Hi Chihiro,

    Yeah, well there isn't much to show but funnel charts and waterfall charts look slick but don't demonstrate the change in composition. It is a bit unusual, that's why I struggle to come up with anything, but I thought someone might've done it before in some clever way. I might just need to take a dozen showers to come up with something haha.

    Alright, thanks for the help anyway, I'll ponder on :)

Share This Page