How to normalize two sets of values for comparison?

Factual Questions
1

I have two sets of values. The first is crude oil barrel price and ranges from 20 to 150. The other set is gasoline price per liter before taxes and this ranges from 0.30 to 0.80.

I want to make a graph that compares the two prices and see if the peaks and valleys match.

I tried that on Excel yesterday, but while the first range appeared nicely, the second range was almost a flat line. Apparently I have to do some kind of manipulation to amplify the second range so the two can be compared.

Any ideas?

2

Read up on z-values or z-scores.

3

You have set oil on the Y1 axis and gasoline on the Y2?
Then adjust the max & min values in the formatting of each Y axis.

4

Exactly. There’s even an Excel function to compute these, so you don’t have to do anything fancy here.