• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto-update to Chart data source

skarnik01

skarnik01

Member
Hi,

I am looking out for an update to the Chart in my worksheet 1 wherein the data source (in Sheet 2) is always the last 20 rows of my data. The no. of rows keep on adding on daily basis and I expect the Chart to be updated dynamically for the last rows in the sheet. I do not intend to create table though I am using Excel 2010.
Is there a function or a macro which can help me do so?

Thanks in advance,


Thead Moved
 
Last edited by a moderator:
Sharnik

You can use a Named Formula using Index or Offset to extract the last 20 values

Can you post a sample file for us to help you further
 
Hi,

Please find the sample file. For the example purpose, I would like to have chart for last 10 rows. When I add 2 rows as marked in yellow, the chart in another sheet "Chart" should get updated for Row 3:12. My records would have dates excluding Sat, Sun & holidays.
 

Attachments

  • Sample_Chart_auto-update.xlsx
    10.7 KB · Views: 2
skarnik01 said:
He Somendra, the file does work as expected. Please let me know what tool / macro has been used for this.
Click to expand...


Go through the Name manager for named range using OFFSET function and than to chart series to see how it is used. If you face any difficulty in doing this, just write back.

Regards,
 
You must log in or register to reply here.
Back
Top