Creating Excel charts

You can add a native Excel chart to your Qlik NPrinting reports filled with data from a QlikView document or Qlik Sense app. The same chart does not need to exist in the original document.

In this example, to create an Excel chart, a QlikView table is added to the template as a level. Fields are embedded in the template, and an Excel chart will be created with the data exported from QlikView.

Create new Excel 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. Excel report with chart.
  3. Select Excel from the Type drop-down list.
  4. Select an app from the App drop-down list.
  5. Click Create to create the report.
  6. Click Edit template to open the Template Editor.

Add data source

Do the following:

  1. Right-click the Levels node, and then select Add levels.
  2. Select the Connection to the QlikView document that contains the object you want.
  3. Enter CH184 in the Search box, and then select Top 25 Products.
  4. Click OK.

Embed level in template

Do the following:

  • Drag the CH184 node into the template and drop it onto three vertically consecutive cells. For example, drop it onto rows 12-14 to make room for the graph above.

Embed fields for columns

Do the following:

  1. Expand the CH184_Level node.
  2. Drag the fields ProductName and Total Sales into the template one at a time, and drop each into an empty cell in a row between the level tags.

Add column headings

Add headings to a row that is above the row containing the level opening tag, and then format them with the Excel formatting tools that are made visible by clicking the Toolbar icon.

The rows containing the level opening and closing tags will be eliminated during the table generation process.

Add Excel chart

Do the following:

  1. Click Toolbar to open the Excel ribbon bar.
  2. Click Insert to open the related bar.
  3. Click the Insert Column Charts icon, and then select 2-D Column chart.

Define chart

Do the following:

  1. Select the Design tab.
  2. Click the Select Data icon.
  3. Click the Add button in the Legend Entries (Series) pane.
  4. Click the icon at the right of the Series name.
  5. Select the cell with the Total Sales heading.
  6. Confirm by clicking on the icon at the right end of the Edit Series field.

Proceed to define series values

Do the following:

  1. Select the icon at the right end of the Series values.
  2. Select the Total Sales range by including the cells in the rows containing the level opening and closing the tags along with the cell containing the <Total Sales> tag.
  3. Confirm the selection by clicking on the icon at the extreme right end of the Edit Series field.
  4. Click OK.

Defining horizontal (category) axis labels

Do the following:

  1. Click Edit in the Horizontal (Category) Axis Labels pane.
  2. Select the Product Name range by including the cells in the rows containing the level opening and closing the tags along with the cell containing the <ProductName> tag.
  3. Confirm the selection by clicking on the icon at the right end of the Axis label range field, and then click OK.
  4. Click OK to finish the chart creation.

Preview and save

Do the following:

  1. Click Preview.
  2. Check the report, close it, and then edit the template again if necessary.
  3. Click Save and Close to save the template and close the Template Editor.

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?