I’ll end with some recommendations of when each method should be used.Each method starts with you creating the graph in Excel first, because we will be copying the graph created in Excel into the Power Point slide.
When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically.
However, once I open & close the graphs in PP, they'll show the correct data." To understand why this happens, you first have to know that Power Point itself doesn't make graphs.
Instead, it fires up MSGraph, an "applet" whose sole purpose in life is to supply graphs to Power Point and other applications via OLE (Object Linking and Embedding).
Once you have embedded a chart, be careful not to delete or move the original Excel file.
If the location of either the Power Point presentation or the Excel file changes, you may have to embed the chart again in order for it to display correctly.