Skip to Content

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

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Gaston Bigi

    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!

    (0) 
    1. Sara G Iyer 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

      (0) 
  2. 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 .

    (0) 
    1. Sara G Iyer 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

      (0) 
      1. 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

        (0) 
        1. Sara G Iyer 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 

          (0) 
            1. Sara G Iyer 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

              (0) 

Leave a Reply