Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

How to Create a PowerPoint Chart using Native QlikView Tables

Support
Support

How to Create a PowerPoint Chart using Native QlikView Tables

Description: NPrinting supports PowerPoint native charts. You can create new charts, or replicate QlikView ones, by adding column tags as the chart data source in the Table node.

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

Attention:

  • Stock charts are not supported
  • Column tags won’t be produced if dragged and dropped into the presentation
  • Tables are only the chart data sources. You cannot drag and drop tables into the slides
  • Other features, like Pages, still work as usual

Create a New PowerPoint Report

Create-a-New-PowerPoint-Report.png


Open your NPrinting project then:

  1. Click on Reports
  2. Select PowerPoint reports
  3. Click on New
  4. Insert a Name. For instance "PowerPoint Native Chart"

Then click on New to create a new template.

Insert a PowerPoint Chart in the Template

Insert-a-PowerPoint-Chart-in-the-Template.png

  1. Add the CH326 in the Tables node
  2. Click on Chart in the PowerPoint ribbon bar

Select the Bar-Chart Type

Select-the-Bar-Chart-Type.png

Select the Bar-Chart then click on Ok in the bottom right corner. Oly the Stock charts are not supported, so you can select the chart type you prefer.

The Excel Data Source Appears

The-Excel-Data-Source-Appears.png


An Excel sheet will be used as data source for the chart. The data are the ones included into the blue border. We'll insert the NPrinting tags into the blue border and we'll re-size this to include only the correct dataset.

Drag and Drop the Table Tags into the Excel Worksheet

Drag-and-Drop-the-Table-Tags-into-the-Excel-Worksh.png


Select the fields in the Tables node. Multiple selections are supported by keeping pressed CTRL or SHIFT. Drag and drop the tags into the upper left corner of the Excel worksheet. Be sure to insert column's title in the first row of the worksheet and column's tag in the second row.

Delete Un-useful Data

Delete-Unuseful-Data.png


Select the columns C and D then delete them. Select and delete also the rows 3, 4 and 5. The blue border will be re-sized automatically. When done you can close Excel by clicking the X on the top right corner. It will be automatically saved.

Verify that the Chart Data Sources are Correct

Verify-that-the-Chart-Data-Sources-are-Correct.png

To check that the chart data sources are correctly connected:
  1. Click on "Select Data" in the Design menu of the PowerPoint ribbon bar
  2. Click on Edit in the Series column to check it as you did with a normal Office chart
  3. Click on Edit in the Category column to check what cells are included
Modify the data source ranges if it's necessary, then close the editor.

Save the Template and Run a Preview

Save-the-Template-and-Run-a-Preview.png
  1. Click on "Save As" to save the template in your preferred folder
  2. Click on Preview

Final Chart

Final-Chart.png


In the preview you'll see a native chart inside the slide.

Add Pages by Category

Add-Pages-by-Category.png


All other features, like Pages, still works:

  1. Add the Category field in the Pages node
  2. Drag and drop the Category label into the slide

Save and run a preview.

Preview with Pages by Category

Preview-with-Pages-by-Category.png

You can see a slide for each category.

Version history
Revision #:
1 of 1
Last update:
‎2015-11-19 06:52 PM
Updated by: