Updating charts in excel

Once you have embedded a chart, be careful not to delete or move the original Excel file.

Start by setting up some labels with dropdowns (I normally put these off to the side and outside the print range…but that doesn’t sit nice with the screen resolution I like to work with on this blog): Then, set up the dropdowns using Excel data validation: First, the report period.This helps the data stay in sync, so you won't have incorrect or out-of-date information in your chart. An Excel spreadsheet containing the chart's source data will appear.After you have finished editing, be sure to save the chart in Excel.If you have already created a chart in Excel, you can embed and link it to your Power Point presentation.When you embed an Excel chart in Power Point, any updates you make to the original Excel chart will automatically update in your presentation, as long as the files remain in the same location.

Search for updating charts in excel:

updating charts in excel-49updating charts in excel-1updating charts in excel-29updating charts in excel-37

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating charts in excel”