'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Missing Select Data for Scatter Charts in Excel for the Web
Question details
The user is unable to find the Select Data command when right-clicking a scatter chart to change the data range or switch rows and columns.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to edit the chart data source or switch rows and columns for an existing scatter chart in the browser.
- Observed behavior
- The Select Data option is completely missing from the right-click context menu and the Chart ribbon in the web version of Excel.
Verify whether you are using Excel for the Web in your internet browser or the Excel desktop application, as advanced chart-editing features are exclusively available on the desktop version.
Open the Workbook in the Excel Desktop Application
Since Excel for the Web lacks advanced chart editing features, you must open your file in the desktop app to access the Select Data command.
Excel for the Web is designed for lightweight editing and currently does not support the Select Data menu needed to change specific data series or switch rows and columns for scatter charts.
In Excel for the Web, locate the top ribbon menu and click the 'Editing' or 'Viewing' dropdown, then select 'Open in Desktop App'.
Once the file opens in your desktop Excel software, click anywhere on your scatter chart to select it.
Navigate to the 'Chart Design' tab that appears on the top ribbon and click on 'Select Data'.
Make your desired changes to the data range or click 'Switch Row/Column', then save the document to automatically sync changes back to the web version.
Submit a Feature Request to Microsoft
Report the missing feature to Microsoft's development team to encourage them to add full chart capabilities to Excel for the Web.
Edit Scatter Charts Easily with WPS Office
Bypass web-based limitations by using WPS Office. It provides a robust, fully-featured desktop spreadsheet application for free, allowing you to easily select data, switch rows and columns, and fully customize your scatter charts without needing an expensive subscription.
- 1. Install WPS Office: Download and install the free WPS Office suite on your desktop computer.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file containing the scatter chart.
- 3. Edit Chart Data: Right-click the scatter chart and click 'Select Data' to access the full chart data management window.
Frequently Asked Questions
Why can't I switch rows and columns in Excel for the Web?
Excel for the Web is a simplified version of the desktop software and currently lacks comprehensive chart-editing capabilities, including the Select Data menu which is required to switch rows and columns.
Can I change the chart data range directly in Excel online?
You can perform very basic data range adjustments by selecting the chart and dragging the colored highlighted borders around your spreadsheet data. However, for precise series editing, a desktop application is required.
Does WPS Office support advanced scatter chart editing?
Yes, WPS Spreadsheet provides complete charting tools. You can easily add or remove data series, switch rows and columns, and format scatter charts exactly as you would in Microsoft Excel desktop versions.
