I need help with finding exact values within a chart. any help would be appreciated.
here is a picture of what i mean: excel.htm
I need help with finding exact values within a chart. any help would be appreciated.
here is a picture of what i mean: excel.htm
Moved to correct forum!
Webjunkie, you can upload a workbook to this forum which may result in you getting the response you need!
Not all forums are the same - seek and you shall find
You have something close to a linear relationship here which can be expressed as.
where the sales figures are in column A.Please Login or Register to view this content.
Martin
Sorry for posting in the incorrect forum. Here is the workbook for help.
I did get one way to work, its just not as accurate. i provided it also in the workbook. thanks
excel_help.xls
Excel will calculate the slope (using the SLOPE function) and the y intercept for you (using the INTERCEPT Function) and then you can use the formula y = slope * x + intercept. See the attached worksheet. Is this what you are looking for?
ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks