Creating Word charts from SharePoint metadata
In this JungleDocs for Office 365 tutorial, you will learn how to:
- Use metadata from your SharePoint lists to create Word charts
- Use Excel repeater commands
You can visualize your Office 365 data in reports, using charts, graphs, and statistics. You can edit an existing document template to included charts and graphs, or create a new one.
How to add metadata to a Word chart?
1. To get started, open Microsoft Word. Now add any kind of chart and then click Edit Data:
2. This will open an Excel chart with a
3. You will now add Excel commands (content controls) to these cells to let JungleDocs know which cells to populate with metadata from your Office 365 environment. There are two ways to do this:
- Entering formulas into the cells. Using this first method you simply enter the values into the cells that will later be replaced by data from your SharePoint. This is the quicker and simpler method of the two. However, note that documents created in this way will not be updateable once generated.
To get started, copy the content controls from the sample document to the document template:
Note: After figuring out the layout and exact cells in the document, it is very important to format the cells correctly. Microsoft Excel requires that the cell type is consistent with the data that that is inserted. Default cell type is "General" and if all cells are left this way, some data, like dates and numbers, might not be interpreted correctly. To avoid this, Excel cells must be the same type as SharePoint fields. You can change the cell types by right-clicking on them and selecting Format cells.
- Adding comments. Add a comment to the cell you want to be populated with metadata from your SharePoint. Remove the user name from the comment and add your formula.
4. The easiest way to create a chart is by using a grouped view in combination with a Matrix function.
For example, you want to show how many contacts you have per company. To do this, you would create a grouped view to group your contacts per company. After naming this view ByCompany you would insert the following formula in your Excel cell: =Repeater(Matrix("Customers"; "
5. Save your changes and assign your template to a JungleDocs rule. When running the rule to your end result would look something like this: