'%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 Fix Incorrect Column or Bar Charts in Excel
Question details
The user needs to fix an issue where Excel column or bar charts display incorrectly or show raw data instead of proper visuals.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Creating or interacting with column and bar charts within an Excel workbook.
- Observed behavior
- Excel generates charts that display raw data or use incorrect formatting due to a damaged Office installation or configuration error.
Ensure you have saved your work and completely closed Microsoft Excel before starting the Office repair process to prevent any potential data loss.
Run a Quick Repair for Microsoft Office
Using the built-in Windows repair tool can fix corrupted Office configuration files that cause chart formatting issues without reinstalling the entire software.
When Excel fails to render charts correctly and displays raw data instead, it is often tied to a corrupted application installation. A Quick Repair scans for and replaces damaged files locally.
Click on the Start menu and select Settings (the gear icon).
Go to the 'Apps' section, then click on 'Installed apps' (or 'Apps & Features' on older Windows versions).
Scroll down or search to find your Office installation, such as 'Office Professional Plus 2016'. Click the three-dot menu next to it and select 'Modify'.
In the modification window, choose the 'Quick Repair' option and click 'Repair'. Wait for the process to complete.
Reopen Microsoft Excel, select your data range, and try creating the column or bar chart again to verify the formatting is correct.
Create Stunning Charts Effortlessly with WPS Office
If Microsoft Excel continues to experience installation corruption or formatting bugs, switch to WPS Office. It provides a lightweight, highly compatible alternative for generating flawless column and bar charts without the heavy installation problems.
- 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet containing the raw data.
- 2. Select the data range: Highlight the specific cells, including headers, that you want to visualize.
- 3. Insert the chart: Navigate to the Insert tab on the ribbon, click the Chart icon, and select your preferred Column or Bar chart.
Frequently Asked Questions
Why does my Excel chart show raw data instead of a visual graph?
This typically occurs when Excel's internal configuration files are damaged, or if the selected data format is set to text instead of numbers. Repairing the Office installation usually resolves the underlying software corruption.
What is the difference between Quick Repair and Online Repair in Office?
Quick Repair fixes most issues quickly without needing an internet connection by replacing corrupted files locally. Online Repair takes much longer, requires an active internet connection, and performs a complete reinstall of the Office applications.
I can't find 'Apps & Features' in my Windows Settings. Where is it located?
In newer versions of Windows 11, the 'Apps & Features' menu has been renamed to 'Installed apps'. You can find it by navigating to Start > Settings > Apps > Installed apps.
How do I change the chart type if it still formats incorrectly after repair?
Right-click on the existing chart and select 'Change Chart Type' from the context menu. From there, you can browse different column, bar, or pie chart layouts that might better represent your selected data range.
