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. 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. Not saving the changes disrupts the link to the map document. Save any changes made to the Excel chart. Both procedures reload the full chart in the layout view. As a second option, close the Excel file, and double-click the chart in the layout view.

If this occurs, open the linked Excel file, and click Save. In some instances, the added object may not display the full chart of the linked Excel file. Check the Link check box, and click OK.Click Browse to go to the location of the Excel file and select it.

In the Insert Object dialog box, select Create from file. Open ArcMap, and click Layout View to switch to the layout view.Eight resizing blocks called handles appear around the Chart Area. Open the Excel file containing the chart to add.Any changes made to the Excel chart are automatically updated in ArcMap. Instructions provided include steps for inserting an Excel chart into ArcMap, while maintaining a live link between them. Click the Production Start Editing button on the Production Editing toolbar.How To: Insert an Excel chart into ArcMap Summary.Click OK on the ArcMap Settings Change Warning dialog box.Add the Production Editing toolbar if necessary by clicking Customize > Production > Toolbar Settings > Nautical Chart Production.If the feature class contains MAGVAR objects, skip this topic and move on to 'Calculating magnetic variation and annual change for compass roses'. If there are no data points with an FCSubtype value of MAGVAR, continue with this topic.

Right-click the feature class and click Open Attribute Table.

Identify whether there are any data points in the TidesAndVariationsP feature class.

The following steps outline how to add a new point feature to the TidesAndVariationsP feature class. In ArcGIS Maritime, the compass rose is stored in the MAGVAR subtype in the TidesAndVariationsP feature class. Every nautical chart has a compass rose to delineate true north and magnetic north, as well as assist with angles for orientation, bearing, and traversing routes.

Arcgis rose diagram