How to Create a Well Formatted PixelPerfect Chart


    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 16 Training & Installation/Upgrade Information

    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