CHART should change data automatically

[vazu]

Need help on the chart,

I want chart to display line graph but it whould shift data on its own, if now its showing cell A1 to A25, i want that as i add data in A26, it should automatically show A2 to A26 and not A1 to A26. please help.

May be a naive question.

[XL&ME]

Suggestion, you may want to attach a sample workbook to better enable someone to assist you with your problem.

Attaching a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[vazu]

sample.xlsx


Thanks for the suggestion, am new here

So in the attachment, i just want that the graph should take the new data and leave the old data, so in the attached file if we enter data for 16 December onwards, the graph should show 3rd December to 16 December and not from 2nd dec to 16 December,

In other words, lets say a graph is showing data from T1 to T5, now if we enter data for T6 day, then the graph should show the data from T2 to T6, kepping the range of 5 days same.

Thanks

[tranhaithang]

Hi man,
Here you go. What I did:
- Create a reference table where it will look up latest date
- The chart is based on this new table & will show the latest data

You can play around with how many days you want to shows...


Thang Tran