Scale of 2nd x-axis

[Kenneth G]

Hello everyone

I am making an excel grafh with two x-axis.
Making these two axis is no problem, however, the 2nde x-axis is a binomial transformation of the first x-axis.
Therefore, the scale is different.

Is there an elegant solution to make the values of my second x-axis correspond to my fist x-axis?

Or will it probably be easier to construct my second x-axis by adding a new set of data?

Thank You

 

[jkpieterse]

I expect you'll have to add the second series to the chart with its own set of (transformed) x-values.