Hey all,

I am looking to produce a template for the lab I work for in which the user can insert a range of results into a table and the results will be placed into a chart automatically.

The issue I am having is that the data range on the x axis is fixed on the maximum size for the sheet (105) however a lot of the users will only have maybe half that amount of results. I am hoping to have the x axis range on the chart adjust automatically to the number of results inserted. Is this possible?

I am using Excel 2010.

Thanks