Insert an Excel file screenshot in a map page setup

Post 15 of 42

In order to show examples of the world oil production, we want to integrate an Excel spreadsheet screenshot into C&D page setup.

This tip is possible with Windows Vista and Seven operating systems thanks to the capture tool available in the accessories.

Map creation in C&D

The first step is map creation. In this example, we use a polar projection of Northern Hemisphere.

astuce-20100913-apercu-excel-avec-carte-1

Excel table capture

Then, access the Excel file used for your source data and use the capture tool to select the area you want and save it as png, jpeg or gif format.

astuce-20100913-apercu-excel-avec-carte-2

Insert your table in C&D

When your are back to C&D, go the page setup

Insert the Excel table image

astuce-20100913-apercu-excel-avec-carte-3

To complete this operation, select the tool “add image” then draw a rectangle in which the Excel table image will be displayed. While the image is still selected, go to Image properties:

astuce-20100913-apercu-excel-avec-carte-4

Tick the box “keep original shape” in order to keep your image proportions (height/width)

astuce-20100913-apercu-excel-avec-carte-5

Prepare map export

Results of the image insertion clearer once the map is exported

astuce-20100913-apercu-excel-avec-carte-6

Menu