Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Select last data in column for a graph
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Select last data in column for a graph
No macro, just formulas in dynamic defined names:
http://peltiertech.com/WordPress/200...ynamic-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "ASTDan" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Select last data in column for a graph
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) -- If this helps, please click the Yes button Cheers, Shane Devenshire "ASTDan" wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Select last data in column for a graph
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 ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Shane Devenshire" wrote in message ... 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) -- If this helps, please click the Yes button Cheers, Shane Devenshire "ASTDan" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you select all text/data within all the cells of a column? | Excel Discussion (Misc queries) | |||
Clustered column graph with mixed data in 2nd column | Charts and Charting in Excel | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
In Excel: select the last 20 rows of data in a column | Excel Worksheet Functions | |||
Is it possible to Select Data on a Graph/Zoom to it in the Spreads | Excel Discussion (Misc queries) |