title: How to retrieve the max/min values and locations in Excel Chart object
body: <p>How do I retrieve the max and min values of an excel chart series collection as well as the position of the same on the chart? I want to calculate where the label should be for each point in the series and move it accordingly. </p>
  
  <p>I'm doing this to make them look nice, in case your wondering. The numbers tend to get all messed up if I just blindly move the labels. I'm sure I could have the number at the base of the chart, but that's not what I'm trying to do. It doesn't help much that the Chart object is hard to get to work with the Object Listing thing-a-ma-jig (that whatcha-ma-call-it that pops up when you hit period after an object name).</p>
  
  <p><strong>Edit:</strong> What I'm trying to achieve is the retrieval of the highest(max) and lowest(min) values of a certain series of an excel chart. I also want to get their positions on the chart itself (from the top or left). I know which way to look, but if you give the code to check which way to measure that will be a bonus. See the drawing below. </p>
  
  <pre><code>   -------------------Left------------------------------------- &gt;
    |        ________________________________________
    |       |                                        |
    |   225 |----------------------------------------|max (highest)
    |   200 |                                        |
    |   175 |                                        |
    |   150 |            -----                       |
  |Top| 125 |           /     \                      |
    |   100 |          /       \                     |
    |    75 |   -------         \                    |
    |    50 |  /                 --------------\     |
    |    25 | /                                 \    |
   \|/    0 |----------------------------------------|min (lowest)
    V       |________________________________________|
  </code></pre>