title: Scatter Graph with four Quadrant for data analysis
body: <p>I want to create a scatter (four quadrant) chart using Excel 2010.</p>
  
  <p>what i am trying to achieve is </p>
  
  <ol>
  <li>Graph will be divided in four region (high/high,High/Low, Low/High , Low/Low ) -xy axis </li>
  <li>I want X and Y axis's min and max value as High and Low</li>
  <li>each region will list the total no of item falling in each category</li>
  </ol>
  
  <p>below is the sample data:</p>
  
  <p><img src="https://i.stack.imgur.com/CZhFO.png" alt="enter image description here"></p>
  
  <p>and this is the image of what i am trying to achieve as an end result (similar to this)</p>
  
  <p><img src="https://i.stack.imgur.com/2oKDi.png" alt="enter image description here"> </p>
  
  <p>I want to have only four region</p>
  
  <ol>
  <li>High/High </li>
  <li>High/Low</li>
  <li>Low/Low</li>
  <li>Low/High</li>
  </ol>
  
  <p>and each region will have total no of item falling in each category
  i.e.</p>
  
  <ol>
  <li>High/High - 2</li>
  <li>High/Low - 2</li>
  <li>Low/Low - 1</li>
  <li>Low/High -6</li>
  </ol>
  
  <p>can any one help me with how can i achieve the same using excel 2010</p>
  
  <p>this is the <a href="https://superuser.com/questions/485883/how-to-create-dynamic-scatter-plot-matrix-with-labels-and-categories-on-both-axi">link</a> i have used to achieve the expected end result  </p>