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!
You have something close to a linear relationship here which can be expressed as.
where the sales figures are in column A.Code:=(0.0228515625)*A2+25.471875
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
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)
Posting Permissions
Reply With Quote
Bookmarks