Fix Missing Value from Cells Option in Excel Chart Data Labels
Question details
The user is unable to find the 'Value from Cells' option when trying to format and add custom data labels to a chart.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Adding or editing data labels on an XY scatter chart or other chart types to display values from specific worksheet cells.
- Observed behavior
- The 'Value from Cells' checkbox is completely missing or unavailable in the Format Data Labels pane.
Verify the file extension of your current Excel workbook by checking the title bar; if it ends in .xls, you are using a legacy format that restricts newer charting features.
Convert Legacy XLS File to a Modern Excel Format
Upgrading your workbook format to XLSX, XLSM, or XLSB unlocks modern charting features, including the 'Value from Cells' option.
The 'Value from Cells' feature for chart data labels is only supported in newer Excel file formats. When a document is saved as a legacy Excel 97-2003 (.xls) file, the application enters Compatibility Mode and disables features that older versions cannot display.
Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Save As'.
Choose a location to save your file. In the 'Save as type' drop-down menu, select 'Excel Workbook (*.xlsx)', 'Excel Macro-Enabled Workbook (*.xlsm)', or 'Excel Binary Workbook (*.xlsb)'.
Click 'Save'. For the changes to fully take effect on your chart objects, close the newly saved file and reopen it.
Select your chart, click the Chart Elements icon (+), open the 'Format Data Labels' pane, and verify that the 'Value from Cells' checkbox is now available.
Create and Format Advanced Charts Easily with WPS Spreadsheet
WPS Spreadsheet offers full support for modern chart data labels, including linking values directly from specific cells. It is fully compatible with modern XLSX formats, preventing missing feature issues caused by legacy compatibility constraints.
- 1. Open Workbook in WPS: Launch WPS Spreadsheet and open your Excel workbook.
- 2. Access Chart Elements: Click on your existing chart to reveal the 'Chart Elements' icon (+) on the right side.
- 3. Open Label Options: Hover over 'Data Labels', click the arrow that appears next to it, and select 'More Options'.
- 4. Select Value From Cells: In the formatting pane, check the 'Value From Cells' box and highlight the specific data range you want to display on your chart.
Frequently Asked Questions
Does the 'Value from Cells' option work in Excel 2010?
The 'Value from Cells' option was introduced in Excel 2013. If you are using Excel 2010 or an earlier version, this option is not natively available in the Format Data Labels pane, regardless of the file format.
Why is the option still missing after saving as XLSX?
If the chart was originally created in compatibility mode, simply saving the file might not immediately update the chart object's properties. You may need to use the 'Convert' option under the File > Info menu, or delete and recreate the chart in the new XLSX file.
Can I use macros to add cell values to data labels in legacy formats?
Yes. If you must keep the legacy XLS format for compatibility reasons, you can use VBA macros to iterate through chart points and manually assign text from specific cells to individual data labels.
