Show Bar | search
Click here to view Show Bar news from 60+ newspapers.
Bookmark or Share- Change the plotting order of categories, values, or data seriesLearn how to reverse the order of categories, values, or data series in a chart by using the Format Selection or Select Data options. This can help you improve the visibility and readability of your chart axes and data markers.
- Display or hide formulas - Microsoft SupportLearn how to switch between displaying formulas and their results, hide or show formulas in a range of cells, or prevent formulas from being displayed or edited. Find out how to use the ribbon, the keyboard, or the formula bar to control the display of formulas in Excel.
- Add or remove data labels in a chart - Microsoft SupportLearn how to add data labels to show details about a data series or its individual data points in Excel charts. Find out how to change the location, format, and text of data labels, or use cell values as data labels.
- Hide error values and error indicators in cells - Microsoft SupportLearn how to use IFERROR function, conditional formatting, and custom number format to hide error values and indicators in Excel cells. See examples of error values, error indicators, and how to convert them to zero or dash.
- Display the relationships between formulas and cellsLearn how to use the Trace Precedents and Trace Dependents commands in Excel to graphically show the connections between cells and formulas. Find out how to check formulas for accuracy, find the source of an error, and troubleshoot untraceable items.
More
