Read: How to create a Line Chart and Scatter Plot Graph in Excel? Once you are done filtering ... if you use dynamic charts. So, to automatically update your dashboard, you must use a dynamic ...

Set up your list in an Excel table, which is dynamic and expands as you add new data Define names for these tables to create a named range that updates automatically Use the named range as the ...

Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates. Click "OK." How to Populate a Website From an Excel Database. Microsoft Excel ...

While Excel includes a legend automatically when you create the scatter plot, there are a number of ways to delete it; if your legend is missing you can get it back through the "Layout" tab.