data range

  Learn how to change the data plot for fitting from inside the fitter tool, and then also how to change the fit data range of the current data plot by using change parameters.

  In Excel, use the OFFSET function to deliver a variable range of values to a function. Also see the Match function used in an array formula to find the first positive value. Use the OFFSET, MATCH and STDEV functions to calculate standard deviation for sample data where the data range varies for each sample in accordance with finding the first positive value in the data set.

Question : What is the data range when making a graph in Microsoft Excel?

Answer : The area of the sheet whre are your x and y values stored..   More from Yahoo Answers

Question : Im trying to create a worksheet in excel 2000 to process and graph data. The data is stored in columns and is of variable length in each run. To automate the plotting of the data, in the series I need to set the range to $B$2: (last cell that contains a value). How do I specify the last cell that contains a value without having to select it manually? Thanks much!

Answer : When creating a Chart, there is problem with specifying a larger area of cells than there exists data. You could end up with a large portion of the graphed data being blank (the cells with no data). You could have a single "dummy" row at the very end of your data, which is part of the Chart you created. Any new rows of data that you add in would be inserted above that "dummy" row, and the Chart would adjust automatically without having to modify the Data Range within the Source Data area...   More from Yahoo Answers

Looking for More Help!

Type Your Question Here