Guest User

Untitled

a guest
Dec 15th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. Dim ejex As String, ejey As String
  2. Dim graficos As String
  3. Worksheets("Sheet1").Activate
  4.  
  5. ejex = "C" + CStr(cont) + ":" + "C" + CStr(conta)
  6. ejey = "K" + CStr(cont) + ":" + "N" + CStr(conta)
  7.  
  8. graficos = ejex & "," & ejey
  9.  
  10. Dim rng As Range
  11. Dim cht As Object
  12.  
  13. Set rng = ActiveSheet.Range(graficos)
  14. Set cht = ActiveSheet.Shapes.AddChart
  15.  
  16. cht.Chart.SetSourceData Source:=rng
  17.  
  18. ...
  19. cht.Chart.SetSourceData Source:=rng
  20.  
  21. Dim ser As Series
  22. For Each ser In cht.Chart.FullSeriesCollection
  23. ser.ApplyDataLabels
  24. Next
Add Comment
Please, Sign In to add comment