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

Dynamic linkage in the chart

K

kaushik03

Member
Hi All,

I am working to create a dynamic chart. I will explain my requirement by using dummy data in the file uploaded here:
http://speedy.sh/vEVqy/Chart.xlsx

I have sales for different sales executives across multiple (and different) products for 12 months (please see data from B2 to O11.

Now,
  • I want to create a dynamic trend chart (at executive level) using 12 months sales data for the multiple products which a particular sales executive is selling
  • The dropdown should contain the list of all unique sales executives
  • If I change the list in dropdown, the chart data should automatically change;
For e.g., If I select, executiveB, chart data should be C6 to 08 (for the products A1, B1, C1). Similarly, if I select, ExecutiveC, chart data range should be changed to C9 to O11(for the products A2, B2, C2).

As of now, I have managed to create a dynamic named range formula (ChtRng..please check this from name manager), which is selecting the range according to my need. But when I try to pass the same in the chart, no change is reflecting in the chart...not able to figure it out why.

Could you please help me ti fix this?

Kaushik
 

Attachments

  • Chart.xlsx
    13.3 KB · Views: 7
Hi Kaushik,
The product code for ExecutiveC is (A2,B2,C2) different from ExecutiveA and ExcecutiveB ( which is A1,B1,C1).. is that correct or its just a typo error ?
Regards,
Ravi Verma
 
Thanks for your attention on this Ravi.

That is a challenge I am facing....this is not a typo...this kind of scenario is well possible in my data.

Looking forward to your response.

Kaushik
 
Hi Kaushik , I have not studied your chart in detail ; can you try using 3 separate series ?

Series_1 will refer to : =OFFSET(Sheet1!$D$3,(Sheet1!$A$20-1)*3,,1,12)

where A20 will take the values 1 , 2 or 3 depending on whether Executive A , B or C is selected using the drop-down.

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