Fix Missing Value From Cells Option in Excel for Mac 2016
Question details
The user is unable to assign custom label values to charts because the Value From Cells option is missing from the data-label settings.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Formatting chart data labels to display custom text or values sourced from a specific spreadsheet range.
- Observed behavior
- The Value From Cells checkbox does not appear in the Format Data Labels pane under Label Options.
Verify your exact Excel version by opening Excel and clicking 'Excel' > 'About Microsoft Excel' in the top menu bar, as feature availability heavily depends on your specific release.
Manually Link Individual Data Labels to Specific Cells
Since the batch Value From Cells option is unavailable in Excel 2016 for Mac, you can manually link each chart label to a cell containing your custom text as a workaround.
This method requires you to link each label one by one. It is highly effective for charts with a small number of data points, though it can be time-consuming for very large datasets.
Click on your chart to select it. Go to the 'Chart Design' tab, click 'Add Chart Element', hover over 'Data Labels', and choose a position (e.g., 'Outside End').
Click once on the data labels to select the entire series, then click a second time (slowly) on the specific data label you want to change. Only that single label should be highlighted with selection handles.
Click inside the Formula Bar located above the spreadsheet grid. Type the equals sign (=), then click on the specific cell in your worksheet that contains the custom label value. Press Return.
Repeat the single-selection and linking process for the rest of the data labels in your chart. The labels will now dynamically update if you change the text in the linked cells.
Upgrade to a Newer Version of Excel
To gain native access to the Value From Cells feature without manual workarounds, upgrade to a newer version of Microsoft Office.
Use WPS Office for Advanced Charting on Mac
If your current version of Microsoft Excel lacks the advanced charting and data label features you need, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that offers powerful spreadsheet tools for Mac users.
- 1. Download WPS Office: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Open your Excel file: Launch WPS Spreadsheet and open your existing .xlsx workbook.
- 3. Customize your charts: Select your chart and explore the comprehensive chart element customization options natively available.
Frequently Asked Questions
Why is the Value From Cells option missing in Excel for Mac 2016?
Microsoft did not include the 'Value From Cells' data label feature in the initial release of Excel 2016 for Mac. It was later introduced in updates for Office 365 subscribers and newer perpetual versions like Excel 2019 and Excel 2021.
Can I use a third-party add-in to fix the missing data labels feature on Mac?
While there are third-party add-ins (like XY Chart Labels) that historically provided this functionality on Windows, compatibility with Mac versions of Excel is highly limited. Manually linking cells or upgrading your software are the most reliable solutions.
How do I link a chart title to a specific cell in Excel for Mac?
Click the chart title to select it, then click inside the formula bar at the top of the screen. Type an equals sign (=), click the cell containing the text you want to use as the title, and press the Return key.
