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.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,532
Messages
5,832,286
Members
430,126
Latest member
bwatts

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