• 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...

  • 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?

Nightlytic

Nightlytic

Member
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:
Without sample workbook, hard to give you help. Upload sanitized sample which mirror your actual set up.
 
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
 

Attachments

  • Chandoo example.xlsx
    15.1 KB · Views: 4
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.
 
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
 
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 :)
 
You must log in or register to reply here.
Back
Top