Tip Printed from ExcelTip.com

---

Displaying Numbers in Thousands in a Chart in Microsoft Excel


Charts are linked to data, and, consequently, any change to the format of numbers in the data table will lead to a corresponding change in how the numbers are displayed in the chart.

1. Select the data in a data table and press Ctrl+1.
2. In the Format Cells dialog box, select the Number tab.
3. In the Category box, select Custom.
4. In the Type box, type #,##0 to display a number rounded to the nearest thousand.