How to make a graph of the difference between cells - Microsoft Excel

TryteHD

Estimable
Jan 5, 2015
6
0
4,510
0
Hello, I'm benchmarking using fraps the frame timing during a 2 minute run around a map in BF1. It's progressively given me the ms build up from 0ms all the way up to 119986.554ms. I wanted to make a line graph showing the difference in frametime over time, so say between frame 1 and frame 2 is had a ms of 30 difference, and then that fluctuated between 25 and 35, how could I show that on a graph?
 
You need to create a new column in Excel (assuming the times are arranged down in a single column. e.g.

Column A (millisec)
Row 1: 0
Row 2: 30
Row 3: 55
etc.

You create column B. In cell B2 you type a difference formula:

= a2-a1

Then you click B2. In the lower right of the selection highlight will be a tiny box. Click and hold that down, then drag the mouse down to paste the formula in B2 all the way to the end of your data. Excel's copy is smart enough to make the columns and rows in the formula relative. So the formula pasted into B3 will be = a3-a2, B4 will have =a4-a3, etc. (If you want a static column or row, just put a $ in front of the letter or number. e.g. =$a2-a1, or =a$2-a1, or =$a$2-a1.)

Then you can use the Excel charting tool to create a line graph of Column B.

Edit: fixed typo in formula!
 
You need to create a new column in Excel (assuming the times are arranged down in a single column. e.g.

Column A (millisec)
Row 1: 0
Row 2: 30
Row 3: 55
etc.

You create column B. In cell B2 you type a difference formula:

= a2-a1

Then you click B2. In the lower right of the selection highlight will be a tiny box. Click and hold that down, then drag the mouse down to paste the formula in B2 all the way to the end of your data. Excel's copy is smart enough to make the columns and rows in the formula relative. So the formula pasted into B3 will be = a3-a2, B4 will have =a4-a3, etc. (If you want a static column or row, just put a $ in front of the letter or number. e.g. =$a2-a1, or =a$2-a1, or =$a$2-a1.)

Then you can use the Excel charting tool to create a line graph of Column B.

Edit: fixed typo in formula!
 
Thread starter Similar threads Forum Replies Date
P Apps General Discussion 4
M Apps General Discussion 4
L Apps General Discussion 5
C Apps General Discussion 2
clintox Apps General Discussion 3
F Apps General Discussion 7
S Apps General Discussion 2
C Apps General Discussion 10
J Apps General Discussion 11
J Apps General Discussion 18
A Apps General Discussion 1
Gabe_G Apps General Discussion 2
C Apps General Discussion 2
D Apps General Discussion 1
O Apps General Discussion 2
S Apps General Discussion 1
D Apps General Discussion 1
K Apps General Discussion 0
J Apps General Discussion 2
N Apps General Discussion 12

ASK THE COMMUNITY

TRENDING THREADS