Data Range updating automatically as new data is entered

  • Thread starter Thread starter mgnrke28
  • Start date Start date
M

mgnrke28

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!
 
Back
Top