View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
mgnrke28 mgnrke28 is offline
external usenet poster
 
Posts: 2
Default Data Range updating automatically as new data is entered

Hi,
I am wondering if there is a way to make the data range for a series graph
include cells in a column up to the last nonblank cell?

For example, I have a graph with a data range: =Sheet2!$B$2:$E$27
As I add new data to the columns, I'd like the table range (and chart) to
automatically include the new cells.

Is that possible?

Thanks in advance for any help you can provide!