Graph data from multiple lists/libraries

It is possible to graph data from multiple lists, by using SharePoint look up columns. Consider the following example.

In this example, we have 2 SharePoint lists (can be more).

List 1: a list of companies




List 2: products, in this list, there is a column named “Company”, where it is a look up column to list onemulti_lists_2



The look up column configuration as follows

multi_lists_3Once configured, in list 2 we can see list 1 data, now we are ready to visualize data from both list 1 and list 2. Launch the visualizer from list 2, always launch the visualizer from the list looking up (list 2), rather than the list that’s being looked up to (list 1).






Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s