If i add a series to a chart, this is recorded.
ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(2).Name = "=""foo"""
ActiveChart.FullSeriesCollection(2).XValues = "=goal!$S$1116:$S$1124"
ActiveChart.FullSeriesCollection(2).Values = "=goal!$T$1116:$T$1125"
Right after doing that, if i go to the immediate window and try to query what those properties are, i get errors.
First this proves that my focus, etc is correct.
?activechart.FullSeriesCollection("foo").Name
foo
But, both of these just give "Type mismatch"
?activechart.FullSeriesCollection("foo").XValues
?activechart.FullSeriesCollection("foo").Values
have tried some variations as well (just "SeriesCollection" or just "Series") but i cannot find a way to get returned to me the property values for the series for properties "Values" and "XValues".
So, how can i write code to query the existing object properties and return to me the XValues and Values property for a series?
Thank you!
ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(2).Name = "=""foo"""
ActiveChart.FullSeriesCollection(2).XValues = "=goal!$S$1116:$S$1124"
ActiveChart.FullSeriesCollection(2).Values = "=goal!$T$1116:$T$1125"
Right after doing that, if i go to the immediate window and try to query what those properties are, i get errors.
First this proves that my focus, etc is correct.
?activechart.FullSeriesCollection("foo").Name
foo
But, both of these just give "Type mismatch"
?activechart.FullSeriesCollection("foo").XValues
?activechart.FullSeriesCollection("foo").Values
have tried some variations as well (just "SeriesCollection" or just "Series") but i cannot find a way to get returned to me the property values for the series for properties "Values" and "XValues".
So, how can i write code to query the existing object properties and return to me the XValues and Values property for a series?
Thank you!