How to Create a Well Formatted PixelPerfect Chart

[Frank_S]

Description: Learn how to create a PixelPerfect Chart based on QlikView data. The new chart imports data from a QlikView document but does not exist in QlikView. The  chart is created in the report. Learn also how to set advanced graphic attributes.

If you haven't recently done so, download the latest version of Vizubi NPrinting Training environment available via the NPrinting Training Material Page. See the following link for download instructions: NPrinting Training Material

Create New Report and Template

1. Enter PixelPerfect Bar Chart as the report Name
2. Click on the New icon in the Template group of the tool bar

Set Template Scale to Pixels

1. Click on the triangle at the corner between the two rulers
2. Go to the Measure Units menu item
3. Open the drop-down menu by clicking on the down pointing triangle at the extreme right of the field
4. Select Pixels

Configure Workspace Format

1. Go to the Property Grid, which is usually docked at the lower left of the work area but can be enlarged and floated to any convenient position in the workspace or even docked on another side
2. Go down to the Page Settings group of attribute controls
3. Change the Paper Kind to the size that you normally use
4. Set Margins as appropriate (the Margins node has been expanded here so that you can see the unconventional order)

Make Room in Template Workspace

Drag the bottom border of the template down to the 350 pixel mark.

Add Object to Template as Table

Add CH311 to the Tables node.

Embed Chart Object

Drag the Chart object from the Tool Box into the template and drop it into the upper left corner of the Detail range aligned with the left margin and the bottom border of the Detail bar. The Chart Wizard opens automatically to the Chart Type page.

Select Chart Type

Select Bar for the Chart Type and click on the Next >> button at the bottom of the window. This moves you to theAppearance page.

Select Color Palette

1. Open the Palette drop-down menu
2. Select the color palette that looks best. The Origin palette has been chosen here.
3. Click on the Next >> button at the bottom of the window

Create and Configure Series

1. Select Series 2
2. Click on the Remove button at the bottom of the Series pane

This creates a simple chart displaying only one series.

Configure Series 1

1. Enter Sales for the Series name
2. Set Point sort order to Ascending
3. Set Sort points by to Value

Setting Sort points by to Argument would list points by category names in alphabetical order

Configure Legend Points

1. Select the Legend Point Options tab
2. Deselect Synchronize with point options
3. Open the Point view drop-down menu
4. Select Argument and Values
5. Set Value format to Currency
6. Set Value precision to 0, this sets the number of significant digits to the right of the decimal point to none
7. Click on the Next >> button at the bottom of the window

Bind Argument

1. Select the Series Binding tab
2. Open the Argument drop-down menu in the Argument Properties box
3. Expand the CH311 node
4. Select CategoryName node

Bind Value

1. Open the Value field drop-down menu under Value Properties
2. Select the Sales node under the CH311 node
3. Click on the Next >> button at the bottom of the window

Explore Chart Page

The Chart page provides controls for appearance attributes such as background color, padding (internal distance of content from margins), text in empty and small charts. Explore various values, but the predefined settings are used for this tutorial. Click on the Next >> button.

Change Diagram Orientation

Configure secondary axes, margins, and other diagram attributes on the Diagram page.

1. Put a check mark in the Rotated box so that the bars will be displayed horizontally
2. Click on the Next >> button

Inspect Panes Page

Have a look at the Panes page but leave the default settings. Click on the Next >> button.

Label X Axis

1. Select the Elements tab on the right
2. Put a check mark in the Visible box. Antialiasing will also be activated automatically
3. Enter Category in the Text field, it appears on the vertical axis because the diagram has been rotated

Label Y Axis

1. Change from Primary AxisX to Primary AxisY in the drop-down menu at the top
2. Make sure the Elements tab on the right is still selected
3. Put a check mark in the Visible box. Antialiasing will also be activated automatically
4. Enter Sales in the Text field, it appears on the horizontal axis because the diagram has been rotated

Format Label Content

1. Select the Labels tab on the right
2. Select the Auto tab
3. Set Format to Currency
4. Set Precision to 0
5. Click on the Next >> button

Set Bar Color

The Series View page let you to customize some visualization options

1. Select the Appearance tab on the right
2. Select pure, saturated blue (0; 0; 255) from the Color drop-down menu
3. Click on the Next >> button

Antialias Point Labels

Customize point display on the Point Labels page.Put a check mark in the Antialiasing box under Text Settings on the General tab

Configure Point Label Content

1. Select the Point Options tab
2. Leave Point view set to Values
3. Select Currency for Value format
4. Set Value precision to 0
5. Click on the Next >> button

Add Chart

Configure the chart heading on the Chart Titles page

1. Click on the Add button to create a new title
2. Enter Sales by Category as the heading
3. Click on the Next >> button

Render Legend Invisible

Configure a chart legend on the Legend page. Set whether or not a legend is displayed and how. A legend is unnecessary for this simple chart so make sure that there is no check mark in the Visible box.Click on the Next >> button.

Add No Annotations

No Annotations are to be added. Click on the Finish button to close the Chart Wizard.

Adjust Chart Size

Drag the bottom right corner of the chart to fill all the available space.

Open Save As Window

Click on the Save As icon in the Report group of the tool bar.

Save Template

1. Make sure the Save As window is open in the C:\NPrintingTraining\Templates folder
2. Enter an appropriate File name or accept the suggested one: PixelPerfect Bar Chart.npx
3. Click on the Save button

Run Preview

Click on the upper part of the Preview button.

Inspect Report