title: Use text as horizontal labels in Excel scatter plot
body: <p>I am trying to make a scatter plot in Excel with text as horizontal axis labels.</p>
  
  <p>I have the data</p>
  
  <p><a href="https://i.stack.imgur.com/OfA06.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OfA06.png" alt="enter image description here"></a></p>
  
  <p>and I want a chart like this</p>
  
  <p><a href="https://i.stack.imgur.com/XfH23.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XfH23.png" alt="enter image description here"></a></p>
  
  <p>The way I produced this chart was to have a scatter plot with numeric X values and numeric Y values, so instead of Poland I have X=1 and Y=10, Y=11, Y=12, and Y=9. For Germany I chose X=2 and Y=8 and Y=7. I just added some text boxes with the names to hide the numeric X values.</p>
  
  <p><a href="https://i.stack.imgur.com/rZwWj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rZwWj.png" alt="enter image description here"></a></p>
  
  <p>But I want this to be dynamic, so I tried to set the X value labels here:</p>
  
  <p><a href="https://i.stack.imgur.com/w35rH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/w35rH.png" alt="enter image description here"></a></p>
  
  <p>but I am not able to change the horizontal values.</p>
  
  <p>How can I solve this problem?</p>