How To: Insert an Excel chart into ArcMap
Instructions provided include steps for inserting an Excel chart into ArcMap, while maintaining a live link between them. Any changes made to the Excel chart are automatically updated in ArcMap.
Note: The content in this article pertains to ArcGIS versions 8.x and 9.x only. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.
- Open the Excel file that contains the chart needed.
- Click the Chart Area. Eight black resizing blocks called handles should appear around the Chart Area. Leave Excel open and the chart selected.
- Start ArcMap and switch to Layout View.
- Navigate to Insert > Object. In the Insert Object dialog box, select Create from file, and click Browse to go to the location of the Excel file; select it.
- Check the Link box and click OK.
The Excel chart is added to the layout.
Note: Make sure to save any changes made to the Excel chart. Not saving the changes disrupts the link to the map document.
To make future edits to the Excel chart that are reflected in the ArcMap Layout, double-click the chart object in ArcMap, make the edits and save. If edits are made in Excel, with ArcMap closed, the chart objects must still be double-clicked in ArcMap to open it and register the changes.
Also, when the chart is modified in Excel and it loses sizing or assigned placement assigned before the modification, resize the chart in ArcMap.
- Inserted or pasted Word and Excel objects, documents, and tables do not print or export correctly
- What is the difference between pasting from another application and inserting an object?