Thread: Naming a worksheet as a variable in a Active Chart Series
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Naming a worksheet as a variable in a Active Chart Series
Hi Farooq,
this is only a stab in the dark, and I'm assuming you have less than
100 sheets.
K = K + 1
ActiveChart.SeriesCollection(1).XValues = "='MSC" & IIF(K9,"0","") &
"'!R2C4:R14C4"
inside your loop.
Ken Johnson

Reply With QuoteReply With Quote