How to get the Line axis in my Scattered chart ?

[bhaveshp90]

Hello,

I have the scattered chart as shown below;

Project_number, Project_Name, Region, Country_Name as Dimensions

Sold_Values, and Forecast_Values as Expressions

Sold_Values vs Forecast Values:

How to get the reference line axis in the Scattered chart? (As shown below)

Desired Output:

thanks

Bhavesh

[vishsaggi]

May be here?

[bhaveshp90]

I tried to do that with the expression (GMP as Forecasted/GMP as Sold) in the reference lines. But this is what I am getting (I posted the desired output in my question now)

[vishsaggi]

Can you share a sample file to look into please?

[bhaveshp90]

I tried doing so, how can I attach the file here ???

[swuehl]

Maybe like discussed here

Scatter plot with diagonal reference line

[bhaveshp90]

Considering x as your only dimension you have this expression;

=aggr(NORMINV( 1-(rank(x)  - 0.5) / count(distinct total ) , 0,1),x)

But I am having Project_number, Project_Name, Region, Country_Name as Dimensions in my scattered chart.

What changes should I make in the expression?

[swuehl · Accepted solution]

I was thinking of something like this

[bhaveshp90]

Perfect 🙂 thank you for the answer