Skip to Content
Author's profile photo Sara G Ayer

Drill down Made Easy

Drilling Down on any thing with the help of a Hidden Combo Box.  This Document is particularly for beginners and learners.

Just follow the screen shots below and achieve the drill on any chart. In this example the Column chart is drilled and

the output appears in the stacked column chart below.

This example shows the category wise profit , and on clicking the particular category the profit made by products

in that particular category are stacked up  which is shown in the stacked chart.

1.PNG

2.PNG

3.PNG

4.PNG5.PNG6.1.PNG

And that completes the drill down in a chart.  The .swf file and the .xlf are attached herewith. Change the extension .txt to .xlf and .swf for the respective versions.

Happy Learning!

Regards,

Sara

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello Sara, one quick question. Is there any way to make it with 3 different charts, that comes activated from the main chart with 3 series, one for each of the above?? hope you understand my doubt. thanks!

      Author's profile photo Sara G Iyer
      Sara G Iyer
      Blog Post Author

      Hi Gaston,

      Yes it can be as many chart as required. Only thing is the connected data should be there in place. Like its there in image number 4 from top, or third last image.

      Let me know if its not clarified.

      Regards,

      Sara

      Author's profile photo Former Member
      Former Member

      I did. Please go to my profile and look for my post to understand better what I mean. Thank you a lot

      Author's profile photo Sara G Iyer
      Sara G Iyer
      Blog Post Author

      Hi Gaston,

      I have checked and replied there.

      Regards,

      Sara

      Author's profile photo Jyoti Jain
      Jyoti Jain

      Hello Sara,

      Can this Stacked bar by month wise be sorted as per ascending / descding order. ?

      Eg. (For Jan =  All Products need to sorted asc/desc)

      Would appreciate your response .

      Author's profile photo Sara G Iyer
      Sara G Iyer
      Blog Post Author

      Hi Jyoti,

      If you go to Behaviour tab of the stacked chart you can see the sorting there. In here you can sort it based on one series or on the basis of the X axis labels.

      Hope this clears.

      Regards,

      Sara

      Author's profile photo Jyoti Jain
      Jyoti Jain

      Thanks Sara, but this sorting would be only series at a time.

      But I have a requirement wherein i have to sort by series. eg. (For JAN --- All Products should be sorted as very asc desc value...like Product 1 ,Product 3 , Product 2 , Product 4) if in descending order for JAN.

      Can we try to achieve this ? Since currently in xcelsius we can sort only by 1 series at a time and not by all series

      Regards,

      Jyoti

      Author's profile photo Sara G Iyer
      Sara G Iyer
      Blog Post Author

      Hi Jyoti,

      This requirement quite hard to achieve directly. With workaround it can be but then it would be a very long procedure to achieve the same.

      Regards,

      Sara 

      Author's profile photo Jyoti Jain
      Jyoti Jain

      Hi Sara,

      Thanks for information. Do u know how we can manage to do it by workarounds.

      Author's profile photo Sara G Iyer
      Sara G Iyer
      Blog Post Author

      Hi Jyoti,

      It something long, I would recommend posting a discussion on it would be good, as,  if someone has done it already then it would be of help.

      Thanks,

      Sara