Thread: Select last data in column for a graph
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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


Reply With QuoteReply With Quote