spinbutton or similar to fill out a line chart progressively

[Degrath]

Hi everyone

I want to use a spinbutton or similar to fill out a line chart progressively, click by click, or can maybe use the spin button to populate a list line by line either that the chart reads as it expands.
I have tried and cant find a way to do it, any help would be greatly appreciated, thanks.

[protonLeah]

I don't know what you really want, but you could add a new column that copies only the values that are >= the current price set by the spinner.

[Degrath]

I don't know what you really want, but you could add a new column that copies only the values that are >= the current price set by the spinner.

Hi leah,
That might work, i will give it a go thursday after work.
Thanks Degrath

[Degrath]

Hi Ben thats closer allright, but what I am looking for is, to fill out a column one line at a time,
which will then build a line chart one point at a time, if this makes sense thanks

Denis..

[Andy Pope]

You can use a named range to define the number of cells to use for the series values.
Use Formula > Name Manager, to see the formula MyData.

I have linked both a form and activex spin button to cell I2. Note the chart does not update for the form control until you stop spinning.

The chart contains a dummy series, which you can remove from the legend. This is used to force all the category points to be be displayed.
Otherwise the chart will grow along both axis.

I have fixed the vertical axis in order to get maximum spread and a static plot area.

[Degrath]

Thanks Andy, I will look into that tonight when I get home.

Cheers Denis.