Rolling chart

[John]

Hi,

I a trying to plot a graph of the last 30 days (line graph
is fine).

Since everyday I keep adding data, how can I make excell
pick up the last 30 days only.

Thanks
Omer

 

[Jason Morin]

You can use a dynamic range and then use this dynamic
range as one of the sources in your line graph.

Post more detail about the layout of your data and how it
will be keyed in (eg, data is in A1:A100), so that the
group can give a more specific solution.

HTH
Jason
Atlanta, GA

 

[dvt]

Hi,

I a trying to plot a graph of the last 30 days (line graph
is fine).

Since everyday I keep adding data, how can I make excell
pick up the last 30 days only.

Try these links:
http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html
www.tushar-mehta.com, click on Dynamic Charts on the left side
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

 

[John]

Hi Jason,

I am trying to plot a simple line chart, but as I add data
(dates) I want the chart to update automatically using the
last 30 data points. All thi is in a spreadsheet and I
have no issues sending anyone that spreadsheet.

Thanks
Omer

data is as follows:
A B C
6.3.03 0.06 -36.04
6.4.03 1.42 49.73
6.5.03 0.68 -46.89
6.6.03 -0.32 72.47
6.9.03 -1.68 -29.83
6.10.03 0.7 51.73
6.11.03 1.01 32.63
6.12.03 0.27 38.86
6.13.03 -1.28 -52.11
6.16.03 1.49 107.7
6.17.03 0.21 10.32
6.18.03 -0.24 24.11
6.19.03 -1.2 -57.13
6.20.03 -0.03 1.75
6.23.03 -1.63 -50.57
6.24.03 0.16 32.16
6.25.03 0.03 -18.41
6.26.03 1.07 46.24
6.27.03 -0.27 -27.21
6.30.03 -0.25 -8.23