Excel 03 Scatter plot search column for last value

[chasethewind]

Hello,

If cells C:4 through C:? has numbers in it. How can I code a scatter plot to recognize C:4, Scan the Column C:C and find the last cell with a number in it. Then have the scatter plot update automatically from C:4 through the last known value in Column C. I cannot use any macros, vba code to accomplish this.

Thanks

 

[SkipVought]

Hi,

faq68-1331

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[chasethewind]

My selection goes past the values in the graph. It gives me zero values, how can I not show the zero values in the graph?

 

[SkipVought]

My selection goes past the values in the graph.

WHY?

Of you were to use the Data > List > Create list... feature, your formulas would propogate automatically as your data is added, AND the range name would ALSO expand!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}