G
Greg
I have two series that I've made a simple line chart of. One is a
column of data, the second is all nulls. The X series is consecutive
dates. Next, I record into a macro the act of changing the series
values and x values. I don't really make a change, I just type what's
already there to make it simple. I can see in the resulting macro the
lines to change the two series' values and xvalues. When I then
immediately run the macro, it fails on the assignment of the xvalue of
the null data series with the error, "Unable to set the xvalues
property of the series class". How can that be? I just did it
successfully manually?
When I replace the nulls with zeros, the macro does not fail. But I
need them to be nulls due to the difference in the way lines are drawn
when encountering null vs. zeros (the line drops to zero when the
value is zero, the null data point is ignored and the line goes to the
next data point).
How can I set xvalues to a series of nulls in a macro the way I can
when I do it manually?
column of data, the second is all nulls. The X series is consecutive
dates. Next, I record into a macro the act of changing the series
values and x values. I don't really make a change, I just type what's
already there to make it simple. I can see in the resulting macro the
lines to change the two series' values and xvalues. When I then
immediately run the macro, it fails on the assignment of the xvalue of
the null data series with the error, "Unable to set the xvalues
property of the series class". How can that be? I just did it
successfully manually?
When I replace the nulls with zeros, the macro does not fail. But I
need them to be nulls due to the difference in the way lines are drawn
when encountering null vs. zeros (the line drops to zero when the
value is zero, the null data point is ignored and the line goes to the
next data point).
How can I set xvalues to a series of nulls in a macro the way I can
when I do it manually?