How to Create Excel Charts With Different Colors by Category
Question details
The user wants to format Excel charts so that different categories (such as weekly peak, daytime, and off-peak values) are represented by distinct colors, especially when dealing with data across multiple regions.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Visualizing complex datasets where multiple subcategories are arranged across columns and require distinct visual distinction through color.
- Observed behavior
- When creating a chart from the complex layout directly, Excel defaults to a uniform color or incorrect grouping, making it difficult to format the chart by category automatically.
Ensure your dataset does not contain merged cells in the header rows, as this can disrupt how Excel reads your categories and series.
Use Built-in Chart Styles for Simple Data
Apply a built-in color scheme to quickly format charts that are properly grouped into multiple data series.
If your data is already separated into distinct series (columns) for each category, you can use Excel's quick customization tools to automatically apply distinct colors to each one.
Click anywhere on your existing chart to reveal the chart formatting tools.
Click the 'Chart Styles' icon (which looks like a small paintbrush) located in the upper-right corner next to the chart.
Navigate to the 'Color' tab within the Chart Styles menu and select the desired color scheme to apply different colors to your categories.

Transform Complex Data with Power Query and PivotCharts
Use Power Query to unpivot complex data layouts into a flat table, making it easier to chart and color-code by category.
Easily Create and Customize Charts in WPS Spreadsheet
WPS Spreadsheet provides highly intuitive charting tools that make it simple to visualize complex data layouts. Effortlessly manage data series and customize chart colors by category for professional reporting.
- 1. Open Your Data: Launch WPS Spreadsheet and open your workbook containing the category data.
- 2. Insert a Chart: Highlight your data range, navigate to the 'Insert' tab, and select your preferred chart type (such as Column or Bar).
- 3. Access Chart Options: Click on the generated chart to activate the 'Chart Tools' menu on the ribbon and the floating quick-access menu.
- 4. Customize Colors: Click 'Change Colors' to apply a vibrant palette across your categories, or double-click an individual data point to fill it with a custom color.

Frequently Asked Questions
Why are all the columns in my Excel chart the same color?
By default, a chart assigns a single color to a single data series. If your categories are listed in one single column as data points rather than separated into multiple columns, the chart treats them as one series. To change this, you can check 'Vary colors by point' in the Format Data Series menu.
How do I manually change the color of just one bar in a chart?
Click once on any bar in the chart to select the entire data series. Then, click a second time specifically on the bar you want to change (only that bar should remain highlighted). Right-click it, select 'Format Data Point', and choose a new fill color.
Can I use conditional formatting to change chart colors automatically based on values?
Standard conditional formatting rules do not apply directly to charts. However, you can achieve this effect by creating 'helper columns' in your data source using IF formulas (e.g., separating values into 'High' and 'Low' columns). Plotting these helper columns as a stacked chart allows you to assign a specific color to each condition.




