Excel Help

Yoshitoshi

Member
May 25, 2001
140
0
0
The derivative of your chart will be the rate of change of your 'Y-axis' data.

Example: if your X data is in the range A1:A:20 and your Y data is in range B1:B20, then in cell C2 enter the formula '=B2-B1'. Autofill this down to cell C20. You will now have a new set of Y data (one datapoint less than your existing data) in column C.

You can add this to your existing chart by RH clicking on the chart, selecting 'Source Data' and add a new series with your X value range from B2:B20 and your Y value range from C2:C20.

You should now see a second series with 'peaks/troughs' where your original series has it's 'steepest' gradients.

This works best with an XY plot and if your X data values are in equal increments.

PM me if you have any other queries - I use Excel alot!

Good luck.. Yoshi.
 

fatalbert

Platinum Member
Aug 1, 2001
2,956
0
0
thanks, that should do it. I needed it for a Chem lab. Potentiametric(sp?) Titration its a pain
 

Yoshitoshi

Member
May 25, 2001
140
0
0
Looks like you caught me at the right time, I graduated in Applied Chemistry!

Go easy on any Chem questions though..

 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |