Excel/VBA

Plotting dynamic ranges in Excel

One annoying thing about using charts in Excel to represent data is that by default it encourages you to define a finite sheet range to plot data. This can be annoying when you’re dealing with data where the total number…

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…