Forum Discussion

Lovebo01's avatar
Lovebo01
Icon for Helper I rankHelper I
6 years ago
Solved

Scatter chart X-axis with text value

Hi everyone,   I am trying to use a scatter chart and have some numerical value on Y-axis and text value on X-axis, but when I am trying to do this, I have this error message : "Your x- and y-axis ...
Need Help
  • negi007's avatar
    negi007
    6 years ago

    @Lovebo01 You can perform the steps below to create the scatter plot that you want to have

    1. Create a calculated column:

    Color_Code - IF('Scatter chart'[color]-"Rojo",1,2)
    2. Then plot the data as below screenshot shown. Start both axes from zero values
    scatter.PNG

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
6 years ago

 

The nature of a Scatter Chart required numberic values on both the X and Y axis, BUT have you tried creating a Line Chart where the Stroke Width is set to 0, and the Show Marker is turned on with default circles?  I think this may be closer to what you want?

 

(I have a scond Y axis in the demo example below, but you can play around with the values?)

 

Forrest