Skip to Content

Like many other miscellaneous components, source data is one among.

Many wonder , what this excel imaged component does.

Developers who tend use many formulas in excel usually encounter the scenario of circular-referencing. This component is used for avoiding that.

I have just taken re-known scenario, which shows the use of it.

Suppose the drill down is happening in a stacked column chart of stacked bar chart and this chart shows the trend of the product groups across the months.

On drilling down the user wants to see the detailed data for that particular month.

In this scenario, the stacks are not drilled down but instead the axis label is used to drill down further.  This type of case cannot be achieved without the use of source data component.

The below illustration shows how it is done.

1.PNG2.PNG

3.PNG4.PNG5.PNG6.1.PNG6.PNG

7.PNG

8.PNG

9.PNG

Thanks for the reading,

Happy Learning 🙂

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply