title: excel:changing the symbol and color of a marker based on grouping
body: <p>I have a dataset that looks like</p>
  
  <pre><code>ID    Vehicle_grp    count    mpg  
  000     Car           5       10
          Motorbike    20      100
          Other         1       25
  001     Car          30       60
          Motorbike    28       45
          Other        85       35
  002     Car         100       10
          Motorbike    20      200
          Other         1       65
  </code></pre>
  
  <p>etc.</p>
  
  <p>In excel, how do i change the colors and marker symbols used based on the ID and vehicle group. I would like to change colors based on ID, and use a different symbol for each vehicle group (i.e car is circle, motorbike is triangle, and other is cross)</p>
  
  <p>I don't know VBA, so if theres a way to do this through the menus, that would be appreciated     </p>