How to Fix Excel Dashboard Not Displaying in Google Sheets
Question details
The user's Excel dashboard fails to display properly after being converted to Google Sheets, often resulting in missing charts or broken visual layouts.

- Product
- Excel and Google Sheets
- Device & OS
- not provided
- Scenario
- Uploading an Excel portfolio project containing a customized dashboard to Google Sites via Google Sheets conversion.
- Observed behavior
- The dashboard elements, particularly Microsoft-specific charts and formatting, disappear or fail to render entirely in the converted Google Sheets document.
Check your original Excel file to identify any advanced charts, custom macros, or complex pivot table configurations that might not be natively supported by Google Sheets.
Embed the Dashboard Using Excel for the Web
Bypass Google Sheets conversion issues by hosting the original Excel file on OneDrive and embedding it directly.
Since Google Sheets does not support all Excel charting features, retaining the native Microsoft format is the most reliable way to display your dashboard. By using Excel for the Web (Office Online), you can generate an embed code that works perfectly with Google Sites.
Log in to your Microsoft account and upload your original .xlsx dashboard file to OneDrive.
Click on the uploaded file to open it in your browser using Excel for the Web.
Navigate to File > Share > Embed. Customize the display options to show your dashboard sheet, then copy the generated HTML embed code.
Open your Google Sites editor, select the 'Embed' widget, switch to the 'Embed code' tab, and paste the code you copied.

Recreate Unsupported Elements in Google Sheets
Modify the original file by replacing Excel-specific features with basic charts that Google Sheets can successfully render.
Open and Edit Excel Dashboards with WPS Office
WPS Spreadsheet fully supports advanced Microsoft Excel charts and dashboard elements. You can seamlessly open, edit, and share your data visualization projects without losing formatting or relying on problematic web conversions.
- 1. Download WPS Office: Install WPS Office for free from the official website and launch WPS Spreadsheet.
- 2. Open Your Workbook: Click 'Open' and select your original Excel dashboard file (.xlsx).
- 3. View and Edit Dashboards: Interact with all your charts, slicers, and pivot tables exactly as they were designed in Microsoft Excel.
- 4. Share with Others: Use the built-in sharing features to send a link to your unaltered dashboard without risking format loss.

Frequently Asked Questions
Which Excel charts are not supported in Google Sheets?
Advanced Microsoft Excel charts such as Waterfall, Sunburst, Treemap, and certain 3D or custom combo charts often fail to render when converted to Google Sheets.
Can I embed an Excel dashboard directly into Google Sites?
Yes, you can embed an Excel dashboard into Google Sites by uploading the file to OneDrive, opening it in Excel for the Web, and generating an HTML embed code to paste into your site editor.
Why did my pivot tables break after converting to Google Sheets?
Google Sheets handles pivot tables and data models differently than Excel. Complex pivot charts or Power Pivot data models may lose functionality or display incorrectly upon conversion.
Is there a way to prevent format loss when sharing dashboards?
To prevent format loss, share the file in its native .xlsx format using cloud storage links or use highly compatible software like WPS Office instead of converting to web-based spreadsheet formats.




