'%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)
Why Combo Charts Are Not Available in Excel for the Web (And How to Fix It)
Question details
The user is unable to find or create combo charts in the web version of Microsoft Excel.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Attempting to create a combo chart using the online version of Excel.
- Observed behavior
- Combo chart options are missing or unavailable in the web interface, as Excel for the web does not currently support creating them.
Ensure you have access to a desktop spreadsheet application, such as Microsoft Excel desktop or WPS Office, as the web version currently lacks this specific charting feature.
Use the Excel Desktop Application to Create Combo Charts
Since Excel for the web does not support creating combo charts, you must use the fully-featured desktop client to build them.
Excel for the web is a streamlined version of the desktop application and does not include every chart feature. To bypass this limitation, you can easily transition your current session to the desktop version.
While viewing your workbook in Excel for the web, click the 'Viewing' or 'Editing' button on the ribbon, and select 'Open in Desktop App'.
Once the file opens in Excel desktop, highlight the rows and columns (including headers) you wish to include in your chart.
Navigate to the 'Insert' tab on the ribbon, click the 'Combo Chart' icon in the Charts group, and select 'Create Custom Combo Chart'.
After configuring your secondary axes and chart types, save the document. The file will automatically sync back to your cloud storage.
Submit a Feature Request via the Feedback Portal
Inform Microsoft about your need for combo charts in the web version to help prioritize future updates.
Create Complex Combo Charts Easily with WPS Office
Tired of the limited features in Excel for the web? WPS Office provides a powerful desktop alternative. You can effortlessly create complex combo charts and seamlessly save them in highly compatible Microsoft Excel formats without relying on a web browser.
- 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the data you want to visualize.
- 2. Select the data range: Highlight the columns and rows that will make up your chart, ensuring you include the headers.
- 3. Insert a Combo Chart: Navigate to the 'Insert' tab, click on the 'Chart' icon, and select 'Combo' from the list of available chart types.
- 4. Customize and save: Assign different chart types (like line and column) to your respective data series, adjust the axes, and save your document in .xlsx format.
Frequently Asked Questions
Is there a planned release date for combo charts in Excel for the web?
Currently, Microsoft has not announced a specific timeline or roadmap for adding combo-chart creation capabilities to Excel for the web. Development priorities are largely driven by user feedback on the official portal.
Can I view existing combo charts in Excel for the web if someone else made them?
Yes. If a combo chart was created using the Excel desktop application and saved to OneDrive or SharePoint, you can typically view the chart online. However, you will not be able to modify its chart type or structure from the web interface.
Why does Excel for the web lack certain features found in the desktop version?
Excel for the web is designed as a lightweight, browser-based tool optimized for quick edits and basic collaboration. Due to performance constraints and web browser limitations, computationally heavy or highly advanced visualization features are reserved for the full desktop application.
