'%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 Use and View Bubble Charts in Excel for the Web
Question details
The user wants to know if it is possible to create and view bubble charts within Excel for the web.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Creating advanced data visualizations such as bubble charts using an online browser-based spreadsheet.
- Observed behavior
- Excel for the web does not natively support the direct creation of bubble charts from the online interface.
Ensure you have access to a desktop version of Microsoft Excel (such as Microsoft 365, 2021, 2019, or 2016) and an active OneDrive account to sync your workbooks.
Create in Desktop Excel and View Online via OneDrive
Since you cannot generate a bubble chart directly in the web browser, you must build the visualization using the desktop application and then upload it to your cloud storage for online viewing and data editing.
Excel for the web is designed for lightweight editing and currently lacks the advanced charting engine found in desktop versions.
By utilizing the desktop app, you bypass this limitation while still allowing web access to the finished chart for your team or remote work needs.
Open your desktop version of Microsoft Excel. Organize your data with X values in the first column, Y values in the second, and Bubble sizes in the third.
Select your data range, navigate to the 'Insert' tab on the ribbon, click the 'Scatter (X, Y) or Bubble Chart' icon, and select 'Bubble' or '3-D Bubble'.
Go to 'File' > 'Save As', select your connected OneDrive account, and save the workbook.
Open your web browser, navigate to your OneDrive account, and click the saved workbook to open it in Excel for the web. The bubble chart will be fully visible and will update if you modify the underlying data.
Create Bubble Charts Easily with WPS Spreadsheet
If you need a robust, free desktop tool to create advanced visualizations like bubble charts without a paid Microsoft 365 subscription, WPS Office provides a complete solution. WPS Spreadsheet features powerful built-in charting tools that seamlessly handle complex data.
- 1. Enter Your Data: Launch WPS Spreadsheet and arrange your data into three columns representing the X-axis, Y-axis, and Bubble Size.
- 2. Select the Data Range: Highlight the cells containing the data you wish to plot on the chart.
- 3. Insert Chart: Navigate to the 'Insert' tab on the top ribbon and click the 'Chart' button to open the chart library.
- 4. Choose Bubble Chart: In the Chart dialog, select 'XY (Scatter)' from the left menu, click the 'Bubble' chart subtype, and click 'OK' to finalize your visualization.
Frequently Asked Questions
Why can't I find the bubble chart option in Excel for the web?
Excel for the web is a streamlined version of the desktop software designed for performance in a browser. It does not currently include the full charting engine required to natively generate specialized charts like bubble or radar charts.
Will a bubble chart created on desktop lose its formatting when opened online?
No. When you upload a workbook containing a bubble chart to OneDrive and view it via Excel for the web, the chart retains all its original formatting, colors, and layout elements exactly as created on the desktop.
Can I edit the values of the bubble chart in Excel for the web?
Yes. Even though you cannot create or redesign the bubble chart online, any changes you make to the data cells in the web browser will instantly update the size or position of the bubbles on the existing chart.
Which desktop versions of Excel support bubble chart creation?
Bubble charts are fully supported in Microsoft 365, Excel 2021, Excel 2019, Excel 2016, and most previous desktop versions for both Windows and Mac.
