Fix Blank Color Menu for Box and Whisker Charts in Excel
Question details
The user is unable to change the color of a Box and Whisker chart because the color selection menu appears completely blank.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Customizing the appearance and data series colors of a Box and Whisker chart using the Chart Design tab.
- Observed behavior
- When opening the color menu from the Chart Design tab, the dropdown interface is completely blank, preventing any color selection.
Ensure your current Excel workbook is saved before making structural or software changes. It is also helpful to check if this graphical glitch occurs in a brand new spreadsheet or only in your current file.
Use the Format Data Series Pane
Bypass the buggy ribbon menu by using the right-click formatting pane to change chart colors directly.
When the Chart Design ribbon fails to load UI elements properly, the built-in side formatting pane is often unaffected. This pane provides direct access to all fill, border, and visual settings for your chart.
Navigate to your Box and Whisker chart and double-click or right-click the specific data series or box that you want to recolor.
If you right-clicked, choose 'Format Data Series' from the context menu. A side panel will appear on the right side of your screen.
Click on the 'Fill & Line' icon (shaped like a paint bucket) in the formatting pane. Expand the 'Fill' section to choose your desired colors manually.

Repair the Microsoft Office Installation
If the formatting pane is also unresponsive or missing, repairing the Office suite can fix underlying software corruptions.
Try WPS Office for Flawless Charting and Data Visualization
If Microsoft Excel continues to experience frustrating UI glitches like blank color menus, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for data analysis without the annoying bugs.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office suite and install it on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx file. Your data and previous charts will load perfectly.
- 3. Create and Edit Charts Easily: Select your data and use the Insert tab to add charts, then format their colors seamlessly using the intuitive toolbars.

Frequently Asked Questions
Why does the color menu disappear in Excel 2016?
Blank menus in Excel 2016 are typically caused by temporary UI rendering glitches, outdated system graphics drivers, or corrupted Office installation libraries that specifically affect the Chart Design ribbon interface.
Does updating Excel fix the blank Box and Whisker chart menu?
Yes, Microsoft frequently releases patches. Installing the latest Office updates can resolve known graphical bugs and interface issues, including missing color palettes in the chart design tools.
Can I change individual box colors in a Box and Whisker chart?
Yes. By double-clicking a specific data point or box to select it individually, you can use the Format Data Point pane to change its specific fill color without affecting the whole data series.
What if the Format Data Series pane is also blank?
If the side formatting pane is also missing its controls, the software library may be severely corrupted. You will likely need to perform an Online Repair of Microsoft Office through the Windows Control Panel to download and restore missing components.




