title: How can I color dots in a xy scatterplot according to column value?
body: <p>Consider the following worksheet:</p>
  
  <pre><code>     A       B        C        D
  1 COMPANY  XVALUE   YVALUE   GROUP
  2 Apple     45       35       red
  3 Xerox     45       38       red
  4 KMart     63       50       orange
  5 Exxon     53       59       green
  </code></pre>
  
  <p>I have used the scatterplot function in Excel to create the following chart:</p>
  
  <p><img src="https://i.stack.imgur.com/pHAEp.png" alt="enter image description here"></p>
  
  <p>However, each point in the chart has an additional property: <code>GROUP</code>. There are four groups: <code>red</code>, <code>orange</code>, <code>black</code> and <code>green</code>. I would like to color each dot accordingly, so that I could perhaps see a pattern (group <code>green</code>being almost always on the left side of the chart, for instance). Because my list is 500 rows long, I cannot do this manually. How can I do this automatically?</p>