Hello,

I am trying to show bond yield charts, everytime the interest rate changes.

I have a series of data. And in cell A1 I have the interest rate. I want
each of the cells in the series of data, to equal the sum of A1 + 0.5, if
cell A1 is greater then 5.00. Otherwise I want each cell in the series of
data to equal the sum of A1 - 0.5, if cell A1 is <5.00. Also I want the A1 +
0.5 bit to occur for only half of cells in the data series, and the other
half with the A1 - 0.5 bit.

Any ideas how I can proceed.

Regards

Ok I have four curves from four series of data, they are code linked by
altering the value in one cell. How can employ the scroller function, so that
the curves begin to appear once the scroller is being clicked. (Like a time
frame)

regards

In article ,
says...
Ok I have four curves from four series of data, they are code linked by
altering the value in one cell. How can employ the scroller function, so that
the curves begin to appear once the scroller is being clicked. (Like a time
frame)

regards

I am not sure I understand the problem. If the definition of each
series is linked to a scroller control, as you click on the scoller
more and more of the curves should appear.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions