Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...

Open Microsoft Excel. Enter you data down column A. Enter "=AVERAGE(A:A)" in cell B1. This configuration looks for all data points in column A so when you add data to the column, it is included in ...