Excel/VBA

Using error bars to highlight chart values

This is a handy technique that I was recently reminded of, using error bars to highlight values on XY scatter charts. If you have an Excel chart you might often have the need to highlight a certain value of interest.…

Lambda functions coming in Excel!

Well, it’s not often I wake up at 4am and get excited about Excel formulas. Today was one of those days though. There on Google was the recommendation for a link saying on sheet lambda functions are on their way…