title: Macro for Excel to refrech Labels Chart
body: <p>I work on Excel and I'm not really familiar with macros assigned to charts. Basically I have several charts. I need each of these charts to have labels that corresponds to data in another spreadsheets called "Data_SC". So for instance I would have:</p>
  
  <p><strong>Graph1:</strong> Label_1 = Data_SC!A1 ; 
  Label_2 = Data_SC!A2...</p>
  
  <p><strong>Graph2:</strong>
  Label_1 = Data_SC!B1 ;
  Label_2 = Data_SC!B2...</p>
  
  <p>I tried to do it only for the first labels of each charts but I get the error "Type:mismatch". Here is my code:
  Sub Refresh_Labels()</p>
  
  <pre><code>Dim cht As ChartObjects
  
  For Each cht In Sheets("Sheet1").ChartObjects
      cht.SeriesCollection(1).Points(1).HasDataLabels = True
      cht.SeriesCollection(1).Points(1).DataLabel(1).Text =   Sheets("Data_SC").Range(A1)
  Next cht
  
  End Sub
  </code></pre>
  
  <p>Could you guys help me please? </p>