Chart & Visualization Issues

How to Create Excel Charts With Different Colors by Category

Algirdas JasaitisAlgirdas Jasaitis Oct 23, 2026 871 views

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.

How to Create Excel Charts With Different Colors by Category
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.
Before you start

Ensure your dataset does not contain merged cells in the header rows, as this can disrupt how Excel reads your categories and series.

Solution 1Recommended

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.

1
Select the Chart

Click anywhere on your existing chart to reveal the chart formatting tools.

2
Open Chart Styles

Click the 'Chart Styles' icon (which looks like a small paintbrush) located in the upper-right corner next to the chart.

3
Apply Color Scheme

Navigate to the 'Color' tab within the Chart Styles menu and select the desired color scheme to apply different colors to your categories.

Use Built-in Chart Styles for Simple Data
Quick Formatting: You can also access color options by selecting the chart and navigating to the 'Chart Design' tab on the top ribbon, then clicking 'Change Colors'.
Professional Charting Software

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. 1. Open Your Data: Launch WPS Spreadsheet and open your workbook containing the category data.
  2. 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. 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. 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.
100% format compatibility with Microsoft Excel (.xlsx and .xls) files.Intuitive UI for adjusting chart elements, data series, and color themes.Built-in advanced data processing tools like PivotTables for complex layouts.Free to download and lightweight, suitable for Windows, Mac, and Linux.
microsoft office alternative - wps office

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.