'%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 Add Multiple Data Series to an Excel Online Scatter Chart
Question details
The user needs to add multiple data series with distinct X-values to a scatter chart in Excel Online.
- Product
- Microsoft Excel Online
- Device & OS
- not provided
- Scenario
- Creating an advanced scatter plot with multiple independent data series on the web version of Excel.
- Observed behavior
- Excel Online lacks the advanced chart-data management features required to add scatter-plot series with separate X-values, a feature otherwise available in the desktop version.
Ensure your data is organized into clear adjacent columns for X and Y values before attempting to configure your scatter chart.
Use the Excel Desktop Application to Configure Scatter Charts
Since Excel Online has limitations with advanced chart configurations, switching to the desktop version allows full control over data series.
Excel for the Web does not currently support the complete 'Select Data Source' dialog box needed to assign individual X and Y ranges to separate scatter plot series. To achieve this, you must open the file in the desktop version.
While viewing your spreadsheet in Excel Online, click the 'Editing' or 'Viewing' button on the ribbon and select 'Open in Desktop App'.
Right-click your existing scatter chart in the desktop application and choose 'Select Data' from the context menu.
In the Select Data Source dialog box, click the 'Add' button located under the 'Legend Entries (Series)' section.
Select your specific ranges for the Series Name, Series X values, and Series Y values by clicking the arrow icons next to each field, then click 'OK'.
Create Advanced Scatter Charts with WPS Spreadsheet
WPS Office provides a fully featured desktop spreadsheet application for free. It seamlessly handles multiple data series, distinct X/Y values, and advanced trendlines without the limitations found in basic web editors.
- 1. Select Initial Data: Open your workbook in WPS Spreadsheet and highlight your first set of X and Y data columns.
- 2. Insert Scatter Chart: Navigate to the 'Insert' tab on the top ribbon, click 'Scatter', and choose your preferred scatter plot style.
- 3. Open Data Manager: Right-click on the newly created chart area and select 'Select Data' to open the data management window.
- 4. Add Additional Series: Click the 'Add' button to input a new series, defining its unique X-value and Y-value ranges.
- 5. Apply Customizations: Click 'OK' to apply. You can then right-click any individual series to add precise trendlines or formatting.
Frequently Asked Questions
Why can't I add separate X-values to my scatter chart in Excel Online?
Excel Online (Excel for the Web) is a streamlined version of the software. It currently lacks the advanced 'Select Data Source' dialog box required to manually assign separate X-value ranges to multiple scatter plot series.
How do I fix trendlines extending across all X-values inappropriately?
Trendlines may behave unexpectedly if multiple data series are incorrectly merged into a single series. To fix this, you must separate your data into individual series with distinct X and Y values using a desktop spreadsheet application, which allows you to apply independent trendlines to each.
Can I view charts with multiple data series in Excel Online if created on desktop?
Yes, charts created in the desktop application with multiple data series and separate X-values will display correctly in Excel Online. However, you will not be able to edit their specific data source ranges within the browser interface.
