Also, the source for a chart can be opened or changed.

To manually update one or more charts, access the Links dialog box as explained above, select the chart or charts, and click Update Now.įrom the Links dialog box, a chart can be changed from manual to automatic update, and vice versa. Other Actions (Update, Change, Open Source) Hints: The Ctrl and Shift keys can be used to select multiple charts in the Links dialog box. Click it to access the Links dialog window. Then click Close or OK.Ī shortcut to the Links dialog window is placed on the toolbar as shown. Find Edit Links to Files and click Add> to add it to the toolbar.Under Choose commands from, select All Commands.The Quick Access Toolbar tab of the Publisher Options dialog box opens as shown below. Right-click on the ribbon and click Customize Quick Access Toolbar.Follow these steps to add a link to the Quick Access Toolbar. To manually update a chart, set automatic or manual update, or open/change a chart's source, one must access the Links dialog box shown below.Īccessing the Links window in many newer versions requires customization of the ribbon or Quick Access Toolbar.

Each time the Publisher document is opened, the user receives a prompt like the one below asking if the links should be updated.Ĭlick Yes and the chart will update if its data in the Excel worksheet has changed. In most versions of Publisher, an Excel chart copied and pasted to a Publisher document has automatic update selected by default. How to Automatically Update the Chart in Publisher Note: In most versions of Publisher, pasting the chart via keyboard shortcut or the right-click menu does NOT link the chart with its data. To paste the chart as an image that won't be linked to the data, click the button by Paste, make a selection, and click OK.

Make sure Microsoft Excel Chart Object Link is selected and click OK. To link the chart to its data, click the button by Paste Link.The Paste Special dialog box opens (see image). On the Home tab, click Paste ▼ > Paste Special.Right-click and select Copy from the menu.Open the Excel worksheet and select the chart to copy.How to Copy an Excel Chart to Microsoft Publisherįor most versions of Publisher, follow these steps: Other Actions (Update, Change, Open Source).How to Automatically Update the Chart in Publisher.How to Copy an Excel Chart to Microsoft Publisher.

How to insert a note in excel chart