Fix Blank Excel Pie Chart Showing Only Title and Legend
Question details
The user is trying to resolve an issue where an Excel pie chart fails to render data slices, displaying only the chart title and legend.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a pie chart from two nonadjacent ranges, or opening existing workbooks after a recent Microsoft 365 update.
- Observed behavior
- The pie chart area remains entirely blank without any slices, though the chart title and data legend are visible.
Before troubleshooting, ensure that your dataset contains actual numeric values rather than numbers formatted as text, as Excel cannot render text values into pie chart slices.
Test with Contiguous Data Ranges and Validate Number Formats
Verify if the issue stems from mismatched nonadjacent selections or text-formatted numbers by creating a simplified, contiguous test range.
Pie charts created from nonadjacent ranges often fail to render if the two selected areas are not perfectly aligned in size or if the underlying data is improperly formatted. Testing with a basic dataset isolates the problem.
Open a new or existing blank sheet and enter a simple, contiguous dataset (e.g., type Category A, B, C in cells A1 to A3, and numbers 10, 20, 30 in cells B1 to B3).
Select this contiguous range (A1:B3), navigate to the 'Insert' tab on the ribbon, and click the 'Pie Chart' icon to insert a basic 2D Pie chart.
If the test pie chart appears correctly, check your original nonadjacent data ranges. Ensure that the category selection and the data selection contain the exact same number of cells.
Highlight your original numeric data, press 'Ctrl+1' to open the Format Cells dialog, and ensure the category is set to 'Number' rather than 'Text'.
Repair Microsoft 365 and Disable Conflicting Add-ins
If the pie chart fails across all workbooks, a recent Office update or a conflicting third-party add-in might be causing graphical rendering issues.
Easily Create and Edit Pie Charts with WPS Office
Avoid chart rendering issues and update bugs by using WPS Spreadsheet. It effortlessly handles both contiguous and nonadjacent data ranges, providing a stable, user-friendly environment for creating professional data visualizations.
- 1. Import your dataset: Open your workbook in WPS Spreadsheet and select your data ranges. To select nonadjacent ranges, highlight the first range, hold the 'Ctrl' key, and highlight the second range.
- 2. Insert the chart: Navigate to the 'Insert' tab on the top ribbon menu and click on the 'Chart' icon.
- 3. Select the Pie Chart type: From the chart type list on the left side of the dialog box, select 'Pie' and choose your preferred 2D or 3D design, then click 'OK'.
- 4. Customize the visualization: Use the Chart Elements menu that appears next to the inserted chart to toggle data labels, adjust the legend position, and format the chart title.
Frequently Asked Questions
Why does my Excel chart only show the legend and no data?
This typically occurs if your data values are formatted as text instead of numbers. Excel cannot calculate or visually render text values in a pie chart. It can also happen if you select nonadjacent ranges that do not match in size.
Can a Microsoft 365 update cause charts to break?
Yes, occasional update bugs can affect Excel's graphical rendering engine. Running an Online Repair for Microsoft 365 or temporarily rolling back to a previous update version often resolves these sudden graphical glitches.
How do I correctly select nonadjacent data for a pie chart?
Highlight your first range of data (such as the category names), hold down the 'Ctrl' key, and highlight the second range (the numeric values). Ensure both selections contain the exact same number of cells before going to the Insert tab to add your chart.
