Can't Select Label Attached to Filled Radar Series

   ActiveChart.SeriesCollection(2).Points(4).DataLabel.Select
				

   Application.ExecuteExcel4Macro "SELECT(""Text S2P4"")"
				

MORE INFORMATION

In Microsoft Excel, there are two types of radar charts:

    Type of Radar Chart   Description
   --------------------------------------------------

   Wireframe             Lines connect the points but
                         are not filled.

   Filled                All lines connect the points
                         and a fill pattern is
                         applied such that a polygon
                         is formed, with the series
                         forming the perimeter of the
                         polygon.
				

In the Microsoft Excel ChartWizard, only the type 6 radar chart is a filled radar chart (all other types of radar chart are wireframes). You cannot mix a wireframe and a filled radar series in the same chart.

If you are recording a Visual Basic macro and you select an individual data label attached to a series (in this example, the fourth point of the second series), the recorded code looks like this:

   ActiveChart.SeriesCollection(2).Points(4).DataLabel.Select
				

If you run this line of code when the second series is a filled radar series, you will receive the error message The code will run correctly if the series is any other type of series, including a wireframe radar series.

To select an individual data label attached to a filled radar series, you must use the Application.ExecuteExcel4Macro method, shown above.

Visual Basic Code Example

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. This Visual Basic code example selects the label attached to the fifth point of the second series in a chart and moves the label to the coordinates 20,20. The series is a filled radar series, so the Application.ExecuteExcel4Macro is used to avoid the error described above.

   Sub MoveDataLabel()

       ' Select the fifth point (P5) of the second series (S2).
       ' Normally, you would use:
       '
       '   ActiveChart.SeriesCollection(2).Points(5).DataLabel.Select
       '
       ' to do this, but this method does not work with a filled radar
       ' chart in Microsoft Excel 5.0.
       Application.ExecuteExcel4Macro "SELECT(""Text S2P5"")"

       'Change the selection's (the label's) Left property.
       Selection.Left = 20

       'Change the selection's (the label's) Top property.
       Selection.Top = 20
   End Sub