Advertisement
Guest User

Untitled

a guest
Oct 4th, 2015
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. ActiveSheet.ChartObjects("ChartDens2").Activate
  2. ActiveChart.SeriesCollection.NewSeries
  3.  
  4. ActiveChart.SeriesCollection(5).XValues = Worksheets("Interface").Range(myRange)
  5. ActiveChart.SeriesCollection(5).Values = Worksheets("Interface").Range(anotherRange)
  6.  
  7. ActiveChart.SeriesCollection(5).MarkerStyle = -4142
  8.  
  9. With ActiveChart.SeriesCollection(5).Format.Line
  10. .Visible = msoTrue
  11. .ForeColor.ObjectThemeColor = msoThemeColorText2 **''NOT WORKING LINE**
  12. .ForeColor.TintAndShade = 0
  13. .ForeColor.Brightness = 0.400000006
  14. .Transparency = 0
  15. .Weight = 1
  16. End With
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement