charts with calculated cells
 

Your question is not at all clear, guessing -

sXValues = "='" & ActiveWorkbook.Name & "'!" & "myRange"
ActiveChart.SeriesCollection(1).XValues = sXValues

Regards,
Peter T

"jasminesy" wrote in message
...
i am creating a chart based on "unknown" cells that are being evaluated
and
given "names" (i.e.
myrange=Worksheets("Data").range(cells(row1,1),cel ls(row1,3) where
row1=4).

can the "names" be used for xvalues, etc. in some way...if so, how...