Microsoft KB Archive/49277

{|
 * width="100%"|

Excel: Selecting a Data Point in a Chart with a Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

-

SUMMARY
In Excel versions 2.2, 3.0 and 4.0, a series or data point can be selected from a macro by using the SELECT function. The arguments are in the form &quot;SxPy&quot; where &quot;x&quot; is the number of the series and &quot;y&quot; is the number of the data point.

For example, the following macro activates a chart and selects point 3 in series 2:

  =ACTIVATE(&quot;Chart1&quot;) =SELECT(&quot;S2P3&quot;)

For more information on this feature, see pages 380-381 of the &quot;Microsoft Excel Function Reference,&quot; version 4.00. If you are using version 3.0, see pages 211-212 of the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual. If you are using Excel 2.20, see pages 275-276 of the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :