![How How](http://www.l4labs.soton.ac.uk/tutorials/excel/images/e1018.jpg)
You also find out how to decorate a chart with a picture, display worksheet data alongside a chart, and place a trendline on a chart. Decorating a chart with a picture A picture looks mighty nice on the plot area of a chart — especially a column chart.
I've been scouring the interwebz only to find loads of solutions that worked years ago, work on Windows, or for some reason don't seem to do a darn thing for me. Could be I'm making mistakes, wouldn't be the first time. But it also wouldn't be the first time an issue was specific to Mac Excel 2011!
So I'm asking here. How can I use VBA to find the last row in column E, that is not blank and actually contains data (not just a formula that is producing a blank result currently)?Robert's formula, which is equivalent to the formula for lastRwEither in the code below, will find the last row even if it happens to contain a formula that is returning ' (a zero-length string).
![Excel graph trendline equation Excel graph trendline equation](/uploads/1/2/5/4/125448262/997487443.jpg)
Form your post I suspect you want to find the last row with data. That's lastRwData in the code below.