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 ...

Launch Excel and open the spreadsheet that contains the list that you want to sort. Click to select a range of data, such as A1 through A20, or click the header to select the entire column of data.

If an Excel chart’s vertical axis is incremented by 20,000, and most of its data points are between 70,000 and 550,000, the chart will look somewhat crowded at the top if the horizontal axis ...