Need help with chart / excel data

Hi guys,

Need help with an issue. Need to work through a lot of data and I hope somebody could make my life much easier :-)

Data I work with contains productdata actual price and all previous prices in 1 column.

I need a chart where I can see the difference between actual price (most actual date in clumn D) and previous price (date before actual date)

Please have a look into example excel I have attached.

Thanks!

So the question is the formula to get the values? Not how to plot


If your data is representative and sorted by product and then date descending
I4 is =IF(G4=INDEX($A$4:$A$26,MATCH(G4,$A$4:$A$26,0)+1),INDEX($C$4:$C$26,MATCH(G4,$A$4:$A$26,0)+1),"")
j4 is =VLOOKUP(G4,$A$4:$C$26,3,FALSE)

if you always have a previous value i4 is INDEX($C$4:$C$26,MATCH(G4,$A$4:$A$26,0)+1)
you may need to swap , for ; depending on your region settings