Retrieving XValues data

[abielr]

I have a line chart for which I cannot figure out how to retrieve the XValues of a series. I know how to set the XValues:

ActiveChart.SeriesCollection(1).XValues = ActiveSheet.Range("A10:20")

But I cannot retrieve this information.

Dim x As Range
Set x = ActiveChart.SeriesCollection(1).XValues
Error: "Object required"

Dim x As String
x = ActiveChart.SeriesCollection(1).XValues
Error: "Type mismatch"

Is there a way to do this?

Thanks very much.

Abiel

 

[pgc01]

Hi Abiel
Welcome to the board

The XValues property returns a variant with an array of x values for a chart series.

Try:

Dim vValues As Variant
 
vValues = ActiveChart.SeriesCollection(1).XValues