Related Posts
Hi everyone! I am working in Tata Consultancy Services Limited and getting released from my project by 31st Jan and I'm looking for project with onsite opportunities. Please do let me know if any openings available. I have 1.5 yoe. Skills - Network Automation, RPA(Automation Anywhere), Python, Power Automate, Cisco meraki, Zscaler. Willing to learn new technologies as well.
My email id - mishrashruti98@gmail.com
Enthusiast
Did you make a mistake working in BigLaw? Why?
Very aptly said.!!
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
I love using heat maps idk if they’re typically underused but they are where I work!
Coach
Not sure if it’s underused but I like sparklines next to my tables
Avoid defaults, eliminate lines and outlines when data specificity isn’t required and make it yours. Doughnuts are getting played out but still better than pie charts. Spark lines are cool, waterfalls are traditional but cool if you surprise with the format
Surface charts are my fav in excel (excluding any of the charts involving python or requiring add ins). You can make pretty awesome charts using the pivot chart tool. Only real disadvantage of surface chart, and I don't consider this a huge disadvantage because it hasn't created issues for me (but in theory in can create issues) is that it implies correlation.
If eye catching is what your boss wants, then the Tree chart is very eye catching. Biggest disadvantage of the tree chart is how simple it is (sometimes that can be more of an advantage though).
Sunburst chart is also a nice one. Can show much more detail than tree chart. Biggest disadvantage of that one, I've found, is making it look presentable. I've only used this once in a scenario where I gave my boss like ten different possible charts to put into a report. She didn't select this one (she went with surface chart, and two plain old column charts).
Tree charts are cool. Agreed
In order of complexity:
Radial Chart > Dispersion > Time Series > Bar Chart > Pie Chart > “One Number in Red”… if your client is struggling, put the red number in millions.
Not what you asked, but I wouldn’t make the decision on chart type by what’s eye catching. Chart type is critical to conveying a key message about the data, that’s what should be prioritized. In terms of eye catching, i think this is more about the overall aesthetic design. Clear labels, no unnecessary images, wise use of colors to draw eyes to what matters most, perhaps a descriptive title, well formatted legend. That’s the art that makes the science matter to people.