Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text.
Just follow these 4 simple steps:
- First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like company logos
- Now use this symbol characters as axis labels
- Finally change the font to the selected symbol font
- Really there is no 4th step, so go ahead add a little jazz to the chart. Happy Friday!
Some more charts with symbols used as axis labels / data labels.
Also try: Min-max charts to tell the story better, Incell graphs with colors, hot looking thermometer chart
3 Responses to “Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)”
Thanks Chandoo, some great helpful tips here. I'm quite good at Excel (mainly thanks to you!) but I'm always learning. I love the link you gave above to Dynamic Arrays & Spill Ranges, I understand them a bit more now, and can see some uses for them.
I am glad you enjoyed the show Dermot.
Great to see you back! Enjoyed when you first started the podcast and super excited to start listening to you again!