Select last data in column for a graph

[ASTDan]

Hello,

Is there an excel function that I can use to select the last cell that
contains data to display in a chart? Do I have to write a macro for this?

Thanks

Dan

 

[Jon Peltier]

No macro, just formulas in dynamic defined names:

http://peltiertech.com/WordPress/2008/05/14/dynamic-charts/

- Jon

 

[Shane Devenshire]

hi,

This gets the last non-blank number
=LOOKUP(9^9,C3:C21)
This gets the last non blank text entry
=LOOKUP(REPT("z",255),B2:B21,B2:B21)
and this gets the last non-blank row number
=MAX((A1:A15<>"")*(ROW(A1:A15)))
This needs to be array entered (press Shift+Ctrl+Enter to enter it)

 

[Jon Peltier]

It's not inconceivable that someone would have numbers greater than 9^9. The
largest number Excel can understand is something line 9.999E307, so I
usually hunt for 1E300.

- Jon