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.

In this tutorial we will create a simple bar chart with sales by Year-Month.

Limitations

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

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 then 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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?