Chart & Visualization Issues

How to Fill or Shade Polygons in an Excel Chart

Steve KSteve K Oct 10, 2026 871 views

Question details

The user needs to apply fill colors or shading to closed polygon loops within a chart.

How to Fill or Shade Polygons in an Excel Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating advanced data visualizations where multiple closed polygon loops in a chart must be filled or shaded with distinct colors.
Observed behavior
Excel line charts do not natively support filling closed polygon loops with different colors, requiring manual shape drawing or complex data generation to achieve a shaded effect.
Before you start

Determine the number of polygon areas you need to fill in your chart. For a small number of polygons, drawing manual freeform shapes is the fastest method, while handling more than 90 areas requires advanced data transformations.

Solution 1Recommended

Create and Fill Freeform Shapes Manually

This is the most straightforward method and is highly recommended if you only have a few polygon loops to fill in your chart.

By tracing over your chart data with freeform shapes, you bypass the limitations of native line charts. You can customize the exact fill color and transparency for each shape.

Keep in mind that if your chart data changes, you will need to manually adjust the vertices of the freeform shapes to match the new contours.

1
Insert a Freeform Shape

Navigate to the 'Insert' tab on the ribbon, click on 'Shapes', and select the 'Freeform: Shape' tool from the Lines category.

2
Trace the Polygon

Click along the data points on your chart that form the closed polygon loop. Double-click or click on the starting point to close the shape.

3
Apply Fill and Transparency

Right-click the newly created shape and select 'Format Shape'. In the Format pane, choose 'Solid fill', select your desired color, and adjust the Transparency slider so the chart gridlines remain visible behind it.

Create and Fill Freeform Shapes Manually
Grouping Shapes: To ensure the filled shape moves whenever you reposition the chart, hold the 'Ctrl' key, select both the chart and the shape, right-click, and choose 'Group'.
WPS Spreadsheet Feature

Quickly Draw and Format Chart Shapes in WPS Office

WPS Spreadsheet offers an intuitive interface for managing charts and overlaying freeform shapes. You can easily trace, fill, and group polygons directly over your visualizations with precision.

  1. 1. Open Your Chart: Launch WPS Spreadsheet and open the document containing the chart you want to shade.
  2. 2. Select the Freeform Tool: Go to the 'Insert' tab, click on 'Shapes', and choose the 'Freeform' tool from the dropdown menu.
  3. 3. Trace and Fill: Trace the polygon area on the chart. Once closed, right-click the shape, open 'Object Formatting', and apply your custom Fill Color and Transparency.
  4. 4. Group with Chart: Hold down 'Ctrl', click both the chart border and the new shape, right-click, and select 'Group' to keep them locked together.
Completely free to download and useSeamless format compatibility with Microsoft Excel (.xlsx)Intuitive Insert Shape, formatting, and transparency controlsLightweight software with exceptional performance
microsoft office alternative - wps office

Frequently Asked Questions

Can I use a Radar chart to fill polygons in Excel?

Yes, you can use the 'Filled Radar' chart type to create filled areas. However, radar charts strictly plot data radiating from a central point, so they are not suitable for plotting arbitrary, non-circular polygons on a standard Cartesian (X-Y) plane.

Are there add-ins that automatically fill polygon areas?

Yes. There are several third-party charting add-ins available for Excel that are specifically designed to map complex polygons, contour plots, or geographic geographic regions, saving you the manual effort of drawing shapes or setting up scanlines.

Why is my freeform shape not moving when I resize the chart?

By default, freeform shapes and charts are separate objects. To make sure the filled shape scales or moves with the chart, you must group them. Select the chart, hold the 'Ctrl' key, select the shape, right-click either object, and select 'Group'.