Chart Data Source Question

**cluelessnomad** · 11-20-2014, 11:42 AM

Hi,
I have some basic code to create charts from a datasheet. The line which references the data source looks like this:

.Chart.SetSourceData Source:=datawkb.Sheets(sheetnames(i)).Range("$B$2:$C$2,$E$2,$G$2,$I$2,$K$2,$B$95:$C$97,$E$95:$E$97,$G$95:$G$97,$I$95:$I$97,$K$95:$K$97,$B$102:$C$102,16,$G$102,$I$102,$K$102")

I'm trying to figure out if I can replace some of those cells with previously declared variables or just numbers. So instead of G102, I can use Var1 instead, which might be the sum of a few other cells.

Thanks for any help.

**xlbiznes** · 11-20-2014, 12:09 PM

try something like this :

Dim ch As Chart
Dim sr As Series
Dim myData As Variant
Set ch = ActiveChart
Set sr = ch.SeriesCollection(1)
myData = Array(10, 20, 30, 40, 50, 60, 70, 80, 90, 100) 'data
sr.Values = myData

**cluelessnomad** · 11-20-2014, 12:13 PM

Thank you for answering.
I have tried using series instead of what I have now. I'm wondering if it's possible to use cell coordinates and normal numbers in the same line. Could I do that with a series?