Scatter Plot Design Help

[hansolo]

I built the scatter plot below but I need some help making it a little more useful.

1. I want to set color condition based on the X axis. If the data point is > 50% I want it to be green, if it is < 50% I want it to be red

2. I want to increase the area of the plot adding a negative range to the Y axis and a positive/negative range to X axis so the data points at the bottom can be read.

3. I would like the name of the data point to be visible. Right now it is only visible if you hover over the data point.

Thank you in advance,

Dave

[mike_honey]

Most of these can be achieved by tweaking the Visualisation / Format:

1. Add a Calculated column e.g. IF ( Table1[MyXAxis] > 0.5 , "High", "Low" ). Drag that column to the Legend well. Go to Visualisations / Format / Data colors and set the colors you want.

2. Go to Format and expand the X-Axis. Set a Start Value e.g. -0.2.  Repeat for the Y-Axis

3. Go to Format and set the Category lables On.  This will show whatever field you have in the Details well.

May the Force be with You ...

[Erin]

Hi Mike,

Thanks for the reply. Could you post the scressnshot of the shrinked points on your scatter chart? I am kind of can't get how the ways you descibed could make the size changed.

Thanks,

Erin

[mike_honey]

I'm confused - none of those points related to "shrinked" or "size changed" points.