Excel Chart XValues Vakes

C

cb

Hi,

I have an XYScatter Chart and problems to pass Values
(as Range: like Daten!$B$2:$B$14) to the Chart.
Passing Values As Array (with range::getvalue()) works fine;
How can I pass Values like:
Charts("Chart1").SeriesCollection(1).XValues = _
Worksheets("Sheet1").Range("B1:B5")

thanks,

chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top