JungleDocs | Word chart filling
You can use JungleDocs to easily create Word reports. Part of this functionality is that you can use the data from your SharePoint lists to immediately create graphs and charts in Word. In this tutorial you will learn how to do this.
Note: Charting is not supported in Small Parts. If you need to fill chart data using JungleDocs, chart must be placed in the document template.
You can easily fill your Word charts with data from your SharePoint views and lists. Let's get started.
- To get started, open Microsoft Word. Now add any kind of chart and then click Edit data:
- This will open an Excel chart with predefined table:
Here you can add Excel repeater command, which will fill and resize table. You can use any JungleDocs supported command in this embedded Excel file.
For more information on how to configure Excel templates, please read Configuring Excel templates.
- The easiest way to create a chart is by using a grouped view and Matrix function. Enter a comment in A2 cell:
Customers list has a view where contacts are grouped by companies, and the view name is "ByCompany".
- In this example, the view "ByCompany" is only grouped by companies and will display a number of contacts for each company:
Note: This table has a header row. So you should enter the command =Repeater(GetView("Tasks"; "MyChartData")) to A2 cell (not in A1). Save your changes and JungleDocs will fill this chart data according to your configuration.