title: VBA - Make chart B appear when series 1 of chart A is selected
body: <p>I have a chart with 14 series. Likewise I have 14 charts that are associated with each of these series. I am trying to create a macro that can be called when a particular series is selected. When the series is selected the macro makes the corresponding chart appear which gives the user more detailed data. </p>
  
  <p>This is what I have come up with so far (Bear with me I am a weak programmer). Please let me know if I am on he right track and if not please give me some direction. this code currently gives me an error message "Object doesn't support this property or method".</p>
  
  <p>Thanks!</p>
  
  <pre><code>Sub Macro1()
  
  Dim Series6 As Object
  Set Series6 = ActiveChart.SeriesCollection(1).Points(6)
  
     If Series6.Select Then
     Sheets("Sheet1").ChartObjects("Chart 2").Visible = True
     End If
  End Sub
  </code></pre>