How to Change Chart Colors in the Excel Data Visualizer Add-In
Question details
The user wants to know how to change the fill colors of dynamic charts created using the Excel Data Visualizer add-in.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Customizing the appearance and fill colors of dynamic flowcharts or organizational charts generated by the Data Visualizer add-in.
- Observed behavior
- The user is unable to find direct color formatting options within the add-in and needs guidance on product-specific options or subscription requirements.
Verify that you are using the Microsoft Visio Data Visualizer add-in and check if you are signed in with a Microsoft 365 account that includes an active Visio Plan 1 or Plan 2 subscription, as advanced formatting requires editing access.
Edit Diagram Colors via Microsoft Visio
Because the Data Visualizer add-in relies on Microsoft Visio to render charts, changing specific element colors requires opening and editing the source diagram in Visio.
The Excel Data Visualizer add-in provides a convenient way to generate charts from data, but it offers limited native formatting tools within Excel itself. To change the fill colors of individual shapes or the entire chart theme, you must edit the linked diagram in the Visio web or desktop application.
Click anywhere on the diagram created by the Data Visualizer add-in within your Excel workbook to activate the add-in interface.
Click the '...' (More Options) menu or look for the 'Edit' button in the add-in header. Select 'Open in Visio' to launch the diagram in your web browser.
In the Visio interface, click on the specific shape or chart element you want to modify. Navigate to the 'Home' tab on the ribbon, click 'Fill', and select your desired color.
Once you have applied the new colors, your changes will automatically save in Visio. Return to your Excel workbook and click the 'Refresh' button on the Data Visualizer add-in to update the chart's appearance.

Create and Customize Professional Charts Free with WPS Office
Avoid complex add-ins and premium subscription hurdles. WPS Spreadsheet offers a robust, built-in charting engine that allows you to easily generate, format, and color dynamic charts for free, without needing external visualization plugins.
- 1. Download and Install: Get WPS Office for free from the official website and open WPS Spreadsheet.
- 2. Insert a Native Chart: Highlight your data table, navigate to the 'Insert' tab, and select from a variety of built-in chart types.
- 3. Customize Colors Instantly: Click on your new chart and use the 'Chart Tools' ribbon to freely change fill colors, borders, and layouts without any add-in restrictions.

Frequently Asked Questions
Why can't I change the shape colors directly in the Excel Data Visualizer add-in?
The Data Visualizer add-in in Excel is primarily designed to generate and view diagrams based on spreadsheet data. Detailed shape formatting, such as changing specific fill colors, is intentionally restricted to the Visio application to maintain diagram structure.
Is the Visio Data Visualizer add-in free to use?
Anyone with a basic Microsoft 365 work or school account can view, print, and share basic diagrams for free. However, advanced customization, creating complex data-linked charts, and editing colors require a specific premium Visio license (Plan 1 or Plan 2).
How do I update my Excel chart after changing the colors in Visio?
After applying your new color formatting in the Visio web or desktop app, simply return to your Excel workbook. Click on the Data Visualizer diagram and press the 'Refresh' button at the top of the add-in window to sync the updated colors.




