Using Excel 2007, I have a spreadsheet (attached), which has the following
Have a maximum number (B1) and minimum number (B2). E.g. 0 and 10, but the maximum number may change. Using an increment (B3) of 0.5, I want to do the following:
1. Generate a sequence e.g. 0,0.5,1....10 and copy in to cell A6 downwards, maximum row possible will be 200 (to take into consideration change in maximum number, and increment).
2. Copy the formulas in B6 and C6 down to meet the row with the final number, in this case 10 (Cell A17) in row 17.
3. Add the following formula =average(B6row with final value eg. B17)), to the cell immediately below the row with the final value, in this case B18 (highlighted yellow). This formula only averages cells in column B6:B17.
4. Cell F2 then equals this average cell in this case =B18. (Highlighted red). This will be a summary average, for the user, to save having to scroll down to see the average cell, which is B18.
5. I then want the graph to update to take into account this new information, uses A6:A17 as x-axis and B6:B17 as y-axis.
Bookmarks