• 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.

Linking chart with table in excel

aamirsq

Member
Hi,

I am having little problem here anyone with suggestion ? i want to display in chart data only upto selected month.
 

Attachments

  • Chart example.xlsx
    18.6 KB · Views: 3
Hi:

what do you mean by "How do you link it?"? I am using name ranges and offset formulas to make the chart dynamic.
Thanks
 
What i do is "from sheet 1, i select all [A2:M4] data and click recommended charts style 2." extremely simple.
So what else did you do with it ?
 
Hi:

I have made the your chart dynamic using offset function in name ranges. Your chart will now change dynamically as per the selection you make in the drop down. Find the attached.

Thanks
 

Attachments

  • Chart example.xlsx
    18.2 KB · Views: 7
Back
Top