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
Bookmarks