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

Multivariate data visualisation advice

MagdaMc

New Member
Hi there, I wonder if anyone can advise on what would be the best way to visualise the following data:

I want to visualise changing levels of a certain mineral. I have existing reserves of the mineral - per country (20 countries), annual production levels - per country and global demand - per country, over the span of the past 20 years. I have some ideas of what would be the best way to visualise that but I am just a beginner and wondered whether more experienced designers could advise on what would be the best way to present it in a clear way? Currently I am thinking that in order to keep it clear I will need to do an animation with each year represented in a separate iteration. (I need all variables to be represented given the purpose and target audience). Thanks in advance for any tips!
 

MagdaMc

Could You send a sample Excel-file from Your the following data?
As well as from I have some ideas of what would be the best way to visualise
Is Your goal I want to visualise changing levels of a certain mineral?
 
Hi, sorry, I do not have the excel file - i a scraping the data from a website. I appreciate you taking the time to answer! but I am ona tight deadline and will have to get t done today, I was just wondering if anyone had ideas on how to visualise several variables of this kind in a clear way.
 

MagdaMc

Really? You started to write about 24hrs ago and something should be ready ... today.
Without data, there are too many kind of challenges to even try to offer anything.

Have You Googled about this?
... I did and I found that ... You've asked same question from other forum.
That's called cross-posting.
There are rules about cross-posting, which You've skipped.
Of course, You've read those rules before Your the 1st posting.
 
Ok, I don’t understand the hostility. How exactly did I offend you to the point of you taking time out of your day to Google my question to then “call me out” on that? As I said - I appreciate you taking the time to reply. I just don’t want to go through the hassle of exporting the data to upload here as I was hoping for a reply along the lines of - when you working with 4 variables and one of them is continuous the kind of graphs that usually work best are…

Yes, I posted on Reddit too. Precisely because I don’t have a lot of time to get it done in and I figured that if I post in another place I have a higher chance someone will reply and give me inspiration. No, I haven’t seen in the rules anything about not being able to post about the same issue anywhere else. That’s a thing? I can only ask here about a specific problem? What sort of cult is this place?

And yes, my project is due today. It’s called “leaving things until last minute due to personal issues I’m not going to be explaining online”.
 
If some has tight deadline,
then isn't is smoother start eg from link New Users - Please Start Here ?
and from there New Users Please Read
There can find How to get the Best Results at Chandoo.org
as well as that other section, which should avoid to do.
It'll be a shorter way to get solution.
( Above lines are answers for You second chapter questions. )

I wrote Without data, there are too many kind of challenges to even try to offer anything.
There will be minor possible that any sample solution would match with Your i a scraping the data from a website.
Without data, someone else would need to get eg random data - and that would be over 95% guess.
If number won't match with realistic data then the result would be - what ever.
If try to make something useful then it needs more than You've written.

Now, You asked give me inspiration
Screenshot 2024-04-10 at 11.31.26.png
... but maybe You would like to get an Excel-file, instead of snapshot.
 
Ok, I don’t understand the hostility.
Hi, with such guessing challenge - which has no place in any Excel forum ! - you should create your thread at least​
two weeks before the deadline, here maybe a month 'cause of the missing workbook attachment !​
When I read your initial post I prefered to directly move to the next unread thread rather than attempting any comment​
which could receive a such common easy answer about the so called 'hostility' …​
You may have more chance on some mind-readers forum.​
 
Back
Top