Relative Chart References

sentimentrader

New Member
Joined
Oct 24, 2002
Messages
6
Hello,

I would like to have a chart update automatically when I add more data, with a fixed number of data points. For example, when I add data, I would like the chart range to only reflect, say, the past 30 days, and not just add the latest data to the existing data range.

I know this is possible and I think I'm close, but I just can't get it to work.

Thanks for any help.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Why don't you summarize your data using a PivotTable and create your chart from it?
 

sentimentrader

New Member
Joined
Oct 24, 2002
Messages
6
One of the columns is a formula based on other data, so I would rather keep it in a straight column basis...
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Sorry, I don't follow your reasoning. See below...
Book1
ABCDEFGHIJK
1DateValueInRange?InRange?TRUE
29/1/200283FALSE
39/8/200219FALSESumofValue
49/15/200220FALSEDateTotal
59/22/200298FALSE9/29/200234
69/29/200234TRUE10/6/200227
710/6/200227TRUE10/13/200286
810/13/200286TRUE10/20/200234
910/20/200234TRUE10/27/200288
1010/27/200288TRUE
11
Sheet2
 

Watch MrExcel Video

Forum statistics

Threads
1,122,187
Messages
5,594,748
Members
413,930
Latest member
Nela817

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top