When other users open those files, they don't update the links.This chapter takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.
To create a line break within a formula, press Alt Enter.It’s a good idea to know the limits Excel sets on various aspects of formulas and worksheet models, even though it’s unlikely that you’ll ever bump up against these limits.Formula limits that were expanded in Excel 2007 remain the same in Excel 2013.So if you’re coming to Excel 2013 from Excel 2003 or earlier, Table 3.1 shows you the updated limits.If this could be a concern, I suggest you create an Excel file that contains only the data for the graph and the graph itself, leaving the bulk of the data in another Excel file that isn’t linked to the Power Point file.
Alternatively, you can break the links to the source Excel file before you send the file to others.
It allows you to format and animate the graph in Power Point, giving you better control of how you present the graph.
The disadvantage is that you must remember to manually click the Refresh Data button to get the latest updated data for the graph.
Method 1: Basic Paste After you have created the graph in Excel, click on it and copy it (press Ctrl C or click the copy button on the Home ribbon). Paste the graph on the slide by pressing Ctrl V or clicking the Paste button on the Home ribbon.
You can now edit the graph using the Power Point graph tools in the Graph ribbons (there are three ribbons on Power Point 2007 & 2010 and two ribbons in Power Point 2013 & 2016).
Note, too, that Excel also accepts line breaks in formulas.