How to Fill or Shade Polygons in an Excel Chart
Question details
The user needs to apply fill colors or shading to closed polygon loops within a 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.
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.
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.
Navigate to the 'Insert' tab on the ribbon, click on 'Shapes', and select the 'Freeform: Shape' tool from the Lines category.
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.
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.

Use a Scanline-Based Series Algorithm
A theoretical approach for data-driven charts where you generate multiple lines to simulate a filled area without manually drawing shapes.
Use Power Query Data Transformation (Excel 365)
Suitable for Excel 365 users who want to programmatically generate coordinate areas to shade specific regions, though the setup can be quite laborious.
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. Open Your Chart: Launch WPS Spreadsheet and open the document containing the chart you want to shade.
- 2. Select the Freeform Tool: Go to the 'Insert' tab, click on 'Shapes', and choose the 'Freeform' tool from the dropdown menu.
- 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. 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.

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'.




