creating dynamic ranges and charts

  • Thread starter Thread starter crichardson
  • Start date Start date
C

crichardson

I've found info about how to use dynamic ranges such as...

=OFFSET(MySheet!$A$1,0,0,COUNTA(MySheet!$A:$A),1)

but despite many attempts, I can't seem to get them working when usin
Excel to create a chart. In vba, I can create a chart but code lik
the following just gives an error...

With ActiveChart
.SetSourceDat
Source:=Sheets("D_Drive_Space").Range("D_Drive_Space!Date_D_Drive_Space
D_Drive_Space!Free_D_Drive_Space"), PlotBy:=xlColumns

eg. Date_Drive_Space is supposed to be a dynamic range.

I wondered if anyone had a working example of code that would create
dynamic range on a column of data and then create and format the char
accordingly?

Thanks in advance.

Cliv
 
Back
Top