Creating a PowerPoint chart using native Qlik tables

Qlik NPrinting supports PowerPoint native charts. You can create new charts, or replicate QlikView or Qlik Sense charts.

Limitations

• Stock charts are not supported.
• Tables are only the chart data sources.

Supported PowerPoint charts

The following PowerPoint charts can be bound to tables in a report template:

• Clustered Bar

• 3-D Clustered Bar

• 100% Stacked Bar

• 3-D 100% Stacked Bar

• Stacked Bar

• 3-D Stacked Bar

• Clustered Column

• Stacked Column

• Stacked Column 100%

• Clustered Column 3D

• Stacked Column 3D

• 100% Stacked Column 3D

• Column 3D

• Stacked Line

• Stacked Line With Markers

• Line

• Line 3D

• Line With Markers

• 100% Stacked Line

• 100% Stacked Line With Markers

• Area

• Area 3D

• 100% Stacked Area

• 100% Stacked Area 3D

• Stacked Area

• Stacked Area 3D

• Wireframe Contour

• Wireframe Surface 3D

• Surface 3D

• Contour

• Bar Of Pie

• Pie

• Pie 3D

• Pie Of Pie

• Exploded Pie

• Exploded Pie 3D

• Doughnut

• Exploded Doughnut

• Radar

• Radar With Markers

• Filled Radar

Create a new PowerPoint report

Do the following:

1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
2. Enter a Title for the report. PowerPoint Native Chart.
3. Select PowerPoint from the Type drop-down list.
4. Select an app from the App drop-down list..
5. Keep the Enabled check box selected.
6. Click Create to create the report.

Insert a PowerPoint chart in the template

Do the following:

1. Click Edit template to open the Template Editor.

2. Right-click the Tables node, and select Add objects.
3. Add CH326 - Sales by YearMonthNum from the objects list.
4. In the PowerPoint ribbon, select the Insert tab.
5. Click on Chart in the Illustrations section.
6. Select the first bar chart in the Columns option, and then click Ok.

An Excel sheet is opened and will be used as the data source for the chart. We will insert Qlik NPrinting tags into the sheet and re-size the data to include only the correct data set.

Drag and drop the table tags into the Excel worksheet

Do the following:

1. Expand the Tables node.

2. Select the YearMonthNum and Sales tags in the Tables node.

   Use Ctrl+Click to select more than one object.

3. Drag and drop the Year MonthNum tags into the upper left corner of the Excel worksheet (cell A1) and the Sales tags into cell B1.

   Be sure to insert the column title in the first row of the worksheet, and insert the column tag in the second row.

Delete unnecessary data

Do the following:

1. Select and delete columns C and D.

2. Select and delete 3, 4 and 5.

3. Close Excel.

   The changes will automatically be saved.

Verify that the chart data sources are correct

To check that the chart data sources are correctly connected, do the following:

1. Click Select Data in the Design tab of the PowerPoint ribbon bar in the template editor.

   Excel will be opened again.

2. Click Edit in the Series column to check the correct cells are shown in the Series name and Series values fields.
3. Click Edit in the Category column to check which cells are included.

4. Modify the data source ranges, if necessary, then close the editor and Excel.

5. Click on Preview .

   You will see a native chart inside the slide.

Add pages by category

All other features, like pages, can be added.

Do the following:

1. Add the CategoryName field in the Pages node.
2. Drag and drop the CategoryName tag into the slide.
3. Click Preview .

   You will see a slide for each category.

4. Click on Save and Close to save the template.