Thread: Source data for chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nsv[_7_] nsv[_7_] is offline
external usenet poster
  
Posts: 1
Default Source data for chart

I have the following lines of code in a macro:

ActiveSheet.ChartObjects("Prob").Activate
ActiveChart.SeriesCollection(1).XValues = "=prob!R1C1:R45C1"
ActiveChart.SeriesCollection(1).Values = "=prob!R1C2:R45C2"

I want the number of chart data rows (in this example it is 45) to be
variable so that this value is taken from a cell in the sheet, but it
will not accept a variable name here.

Is this possible?


NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=487226

Reply With QuoteReply With Quote