Scatter plot with zero in centre of chart

[dapperscavenger]

Hi all

Is there a type of chart I can use which is essentially a scatter plot, but which always has 0 as the centre point regardless of the values (negative, positive, range)?

If the values of both axis are above zero, points will show in top right quadrant.  If the values of both axis are below zero, points will show in bottom left quadrant, and so forth.

Visually this would be very descriptive for the type of data I want to show

[PhilipTreacy · Accepted solution]

Hi @dapperscavenger 

Perhaps a Radar Chart is what you are after

Radar Chart (microsoft.com) 

Regards

Phil

[dapperscavenger]

Yes, I think a radar chart might be better suited, thank you

[PhilipTreacy]

Hi @dapperscavenger 

What you describe is a scatter plot.  If you want 0 always at the centre, manually set the bounds of the chart so 0 appears where you want.

Regards

Phil

[dapperscavenger]

The ranges are too variable.  With filters it can go from a couple of hundred, up to 750K

When setting start and end points, this means the smaller ranges are squashed together.

I'm wondering if there is a visual where you can set the mid point instead.