Building graph series via VBA

[roscoe]

Currently I have code that that build a X-Y series with a constant Y value. That is coded as:

activechart.seriescollection.newseries.values = Array(Yvalue)

where Yvalue is the constant Y value.

What I'd like to do (instead of a fixed value) is reference a single cell where I can (after series creation) change one value to move the entire series up/down (or off the chart scale if I want to hide it).

How would I change the code above to do that?

Thanks!

 

[roscoe]

Well, I figured out how to enter a cell (pretty basic actually) but now I get a spinning wheel at the end of the macro. Odd part is if I click anywhere in the graph (the macro is triggered by clicking on a data point) the spinning wheel goes away. very odd...