View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Calle Calle is offline
external usenet poster
 
Posts: 70
Default a question about diagrams.

nevermind, I found this code to play around with.

ActiveSheet.ChartObjects("Diagram 17").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(2).Values = "=resultatpivot2!R5C3:R8C3"