Forum Discussion

hansolo's avatar
hansolo
Helper I
10 years ago

Scatter Plot Design Help

 

 

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

 

 

 

Need Help

3 Replies

  • mike_honey's avatar
    mike_honey
    Memorable Member
    10 years ago

    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's avatar
      Erin
      Helper I
      10 years ago

      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's avatar
        mike_honey
        Memorable Member
        10 years ago

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