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
8 Responses to “What is LAMBDA? 4 Practical examples to REALLY understand it”
Thanks so much for this, it's utterly brilliant!
Silly question - I assume LAMDA will work with dynamic arrays?
Very much so. Many of the new functions like MAP only make sense in the context of dynamic arrays and Lambda functions.
As usual, very informative material. Easy to understand and apply!
Thanks for making everyone awesome!
Easy to understand Lambda function through this tutorial. Thanks Chandoo.
I have Officce 365 (updated), but I can't see LAMBDA function. 🙁
I dont see "Office Insider" option in my excel 365.
Another option for First Monday...
=LAMBDA(anydate,WORKDAY.INTL(EOMONTH(anydate,-1),1,"0111111"))
Loving the binary options in WORKDAY.INTL David...