How to Make All Scatter Chart Bubbles the Same Size in Excel
Question details
The user needs to make all bubbles or data points in an Excel scatter chart the same size after they changed unexpectedly.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Modifying a scatter chart after adding new goals and statistics to the data set.
- Observed behavior
- The chart bubbles changed sizes automatically and appear to be using a specific data range or the Y-axis to dynamically determine their individual sizes.
Ensure you have the correct scatter chart selected and verify which columns in your spreadsheet are meant to be the X and Y coordinates.
Clear the Bubble Size Series Data Range
Removing the data range assigned to the bubble size setting forces Excel to use a default, uniform size for all data points.
When extra data is added, Excel might incorrectly assign a column to the 'Series bubble size' field, turning a standard scatter plot into a bubble chart with varying point sizes.
Click anywhere on your scatter chart. This will display the 'Chart Design' and 'Format' tabs on the Excel ribbon.
Navigate to the 'Chart Design' tab and click on the 'Select Data' button.
In the 'Select Data Source' dialog box, highlight the series you want to fix under 'Legend Entries (Series)' and click the 'Edit' button.
Check the 'Series X values' and 'Series Y values' boxes to ensure they are pointing to your intended data ranges.
Locate the 'Series bubble size' box at the bottom of the dialog. Delete any cell references inside it so that the field remains completely empty.
Click 'OK' to close the Edit Series dialog, then click 'OK' again to close the Select Data Source dialog.
Create and Customize Scatter Charts Easily with WPS Spreadsheet
WPS Spreadsheet offers intuitive charting tools that make it easy to manage data series, switch between chart types, and adjust visual elements like marker sizes without getting lost in complex menus.
- 1. Insert a Chart: Highlight your dataset, go to the 'Insert' tab, click 'Chart', and select a Scatter chart.
- 2. Select Data Source: Right-click the generated chart and choose 'Select Data' from the context menu.
- 3. Edit Series Settings: Click 'Edit' on your data series and clear out any unwanted references in the Bubble Size input box.
- 4. Format Markers: Right-click the uniform data points, select 'Format Data Series', and use the Fill & Line panel to manually set a fixed marker size.
Frequently Asked Questions
Can I manually set a specific size for all the uniform scatter chart bubbles?
Yes. Once you have made the bubbles uniform by clearing the bubble size data range, right-click any data point on the chart and select 'Format Data Series'. Go to the 'Marker' options under 'Fill & Line' and adjust the 'Size' number under Marker Options.
Why did my Excel scatter chart turn into a bubble chart automatically?
If you select more than two columns of data (such as X, Y, and an additional statistics column) when inserting a chart, Excel may assume the third column is meant to represent the size of a bubble, converting the scatter plot into a bubble chart.
Will clearing the bubble size affect the accuracy of my X and Y values?
No. The X and Y series dictate the position of your data points on the grid. Clearing the 'Series bubble size' box only removes the size variation of the markers without altering their actual coordinates.
