interactive chart like google finance

[Laoballer]

I've been playing around with google finance and am wondering if a
chart like that can be implemented in excel. Some of the features I'm
very interested in is the ability to be able to select a time window
and chart the trend. I need to create a chart that is basically
identical to the google and yahoo finance charts. Is this possible at
all in excel or is this an impossible task and I should look
elsewhere. If impossible what are some suggestions for accomplishing
this?

Thanks,

 

[David Heaton]

I've been playing around with google finance and am wondering if a
chart like that can be implemented in excel.  Some of the features I'm
very interested in is the ability to be able to select a time window
and chart the trend.  I need to create a chart that is basically
identical to the google and yahoo finance charts.  Is this possible at
all in excel or is this an impossible task and I should look
elsewhere.  If impossible what are some suggestions for accomplishing
this?

Thanks,

Hi,

It is possible with excel.

first check out Ozgrids site on dynamic named ranges here

http://www.ozgrid.com/Excel/DynamicRanges.htm


The pricinple is this.
Set up your data, in the formula below it assume that this data starts
at cell AT1 and continues along time periods in each column.

Add a chart to your worksheet

Add a scroll bar to your worksheet and set the linked cell to
somewhere on yout sheet (ie. A1)

Add the number of periods you wish to view in B1
in C1 simply SUM A1+B1

(You could add another scroll bar to adjust if you wish)

place this formula in the data range of your chart

=OFFSET('Sheet1'!$AT$1,0,'Sheet1'!$A$1,1,'Sheet1'!$C$1)


The OFFSET structure is =OFFSET (Starting Cell, 'Row Start Cell',
'Column Start Cell', 'Row End Cell', 'Column End Cell')

As the scroll bar changes value the 'Column Start Cell' and 'Column
End Cell' are adjusted automitically and the chart range is updated.

That should get you started

Regards

David