Hi all

I have a very, very basic understanding of excel and wondered if you can help.....
If I want to populate a 3d chart with some data, is it possible for the axis (and/or series data range) on the chart to automatically update depending on the range (numnber of columns and rows) of the data entered.

For example, the attached spreadsheet is used to plot some data points. In the case of example 1, I have entered only 10 columns by 10 rows of data and plotted on a 3d chart. In example 2 I have entered 50 columns by 50 rows of data and plotted on a 3d chart. Is it possible for the chart in example 1 too show only the 10cols by 10rows without manually updating the series data range? On my worksheet I use, I want to be able to enter 10 columns by 10 rows of data, or 20, or 30 or 41 etc but keep the same chart and have it automatically update? is this possible?

And does this make sense?!

thanks
Dean
example.xls