Skip to main content Skip to complementary content

Image dimension management in Microsoft Office reports

You can change the size of images exported from QlikView and Qlik Sense. Excel, Word, and PowerPoint maintain image dimensions as defined at the moment the image is dropped into the report template.

Information note If you apply filters to an image after it has been added to a report, it may become distorted due to changes in dimensions.

To change the size of images exported from QlikView and Qlik Sense, use the Stretch option in the Properties pane. It can be set to the following:

  • Don't Fit: Image size does not change. Template settings will be ignored. Image may overlap other content.
  • Fit Inside (default setting): Image height and width remain the same, or the height and width are reduced proportionally until both are smaller than the settings in the template. Image quality is not degraded.
  • Fit Width: Image width remains the same, or changes to the width set in the template, whichever is smaller. Image height is adjusted proportionally.
  • Fit Height: Image height remains the same, or changes to the width set in the template, whichever is smaller. Image width is adjusted proportionally.
  • Stretch: Image dimensions are increased or decreased until both dimensions are the same as set in the template. Aspect ratio is not maintained.

If you unlock the aspect ratio of an image when making adjustments to dimensions, the image may look distorted. The image in the generated report will have the original aspect ratio.

Creating a PowerPoint report with different image sizes

The following example shows the different image dimension options in a PowerPoint report template, but is relevant to Excel and Word reports.

Information noteIf you are creating an Excel report, image sizes will be in pixels, not centimeters. Images cannot be manually re-sized in Excel.

Adding an image with the Don't Fit property

Do the following:

  1. Create a PowerPoint report using the Sales Demo app, and then open the Template Editor.
  2. On the left pane, right-click on Images, and select Add objects.

  3. Select CH304 - Sales by Country.

    The original object is 9.16 cm high x 14.93 cm wide.

    If the Properties pane is not open, right-click on the object node in the Template Editor, and then select Properties.

  4. Click the Stretch Value cell and select Don't Fit from the drop-down list.
  5. Drag and drop CH304 - Sales by Country into the template.
  6. Select the CH304 - Sales by Country image.
  7. In the PowerPoint ribbon, go to Picture Tools and then Format.
  8. Expand the Size tool by clicking on the icon in the lower right corner of the Size group.
  9. Clear the Lock aspect ratio check box.
  10. Change the Height to 8.75cm and the Width to 20cm.
  11. Click Close at the bottom right of the window.

Adding an image with the Fit Inside property

Do the following:

  1. On the PowerPoint ribbon, click the Home tab .
  2. Click the New Slide icon.
  3. On the left pane, right-click on Images, and select Add objects.
  4. Add CH304 - Sales by Country to the template again. This image will be automatically named CH304_1 - Sales by Country.
  5. In the Properties panel, set the Stretch property to Fit Inside .
  6. Drag and drop CH304_1 - Sales by Country into the template.
  7. Select the CH304_1 - Sales by Country image.
  8. In the PowerPoint ribbon, go to Picture Tools and then Format.
  9. Expand the Size tool, and clear the Lock aspect ratio check box.
  10. Change the Height to 8.75cm and the Width to 20cm.
  11. Click on Close at the bottom right of the window.

Adding an image with the Fit Width property

Do the following:

  1. On the PowerPoint ribbon, click the Home tab .
  2. Click the New Slide icon.
  3. On the left pane, right-click on Images, and select Add objects.
  4. Add CH304 - Sales by Country to the template again. This image will be automatically named CH304_2 - Sales by Country.
  5. In the Properties panel, set the Stretch property to Fit Width.
  6. Drag and drop CH304_2 - Sales by Country into the template.
  7. Select the CH304_2 - Sales by Country image.
  8. In the PowerPoint ribbon, go to Picture Tools and then Format.
  9. Expand the Size tool, and clear the Lock aspect ratio check box.
  10. Change the Height and Width to 12.7cm.
  11. Click on Close at the bottom right of the window.

Adding an image with the Fit Height property

Do the following:

  1. On the PowerPoint ribbon, click the Home tab .
  2. Click the New Slide icon.
  3. On the left pane, right-click on Images, and select Add objects.
  4. Add CH304 - Sales by Country to the template again. This image will be automatically named CH304_3 - Sales by Country.
  5. In the Properties panel, set the Stretch property to Fit Height.
  6. Drag and drop CH304_3 - Sales by Country into the template.
  7. Select the CH304_3 - Sales by Country image.
  8. Select Format under Picture Tools.
  9. Expand the Size tool, and clear the Lock aspect ratio check box.
  10. Change the Height and Width to 12.7cm.
  11. Click on Close at the bottom right of the window.

Adding an image and adjusting it manually

Do the following:

  1. On the PowerPoint ribbon, click the Home tab .
  2. Click the New Slide icon.
  3. On the left pane, right-click on Images, and select Add objects.
  4. Add CH304 - Sales by Country to the template again. This image will be automatically named CH304_4 - Sales by Country.
  5. In the Properties panel, set the Stretch property to Fit Inside.
  6. Drag and drop CH304_4 - Sales by Country into the template.
  7. Select the CH304_4 - Sales by Country image.
  8. Adjust the image size to fill the slide by dragging a corner handle, and then repositioning the image until the image fills the slide appropriately.

Previewing the report

You can now see how the five different sizing options display your image differently.

Do the following:

  1. Click on Preview. You will see the following:
    1. Slide 1 - Don't fit

      The image is the same size as it was in the QlikView document or Qlik Sense app, 9.16 cm x 14.93 cm. Qlik NPrinting has ignored the height and width settings.

    2. Slide 2 - Fit Inside

      The image has the height specified in height setting, 8.75 cm, and the width has been adjusted proportionately to 14.26 cm.

    3. Slide 3 - Fit Width

      The image width has been reduced to the specified 12.7 cm width, and the height has been adjusted proportionately to 7.79 cm.

    4. Slide 4 - Fit Height

      The image height and width may be equal to or less than the original image dimensions. Even though the height was set to 12.7 cm, the height remains 9.16 cm and the width remains 14.93 cm.

    5. Slide 5 - Fit Inside with manually re-size

      The image is the same size as the original, 9.16 cm x 14.93 cm. The image is positioned in the top left corner.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!