Shading a single line polygon on a chart in Excel

Question

I want to put shading inside polygons I made on an excel chart.  The polygons are simply a closed loop single line. I have more than 90-100 polygons in total and I would like to use more than one colour.  The table below displays actual data for 4 of these polygons. Is there a way to shade these polygons?

48.352334	59.295721
48.366813	59.234931
48.369504	59.171265
48.330552	59.263696
48.274942	59.3358
48.280836	59.391988
48.331192	59.35747
48.352334	59.295721
48.38629	58.933858
48.398975	58.945364
48.412813	58.882849
48.38629	58.933858
48.268985	59.174448
48.27525	59.157894
48.267566	59.145808
48.251562	59.163241
48.261057	59.17269
48.268838	59.174594
48.333001	58.989792
48.334567	58.984958
48.320081	58.96357
48.309509	58.98569
48.325856	58.998582
48.333001	58.989499

Answer 1

Hi Bill

Please view the following document to Vary the colors of same-series data markers in a chart

https://support.microsoft.com/en-us/office/vary-the-colors-of-same-series-data-markers-in-a-chart-395f0c1c-ea89-4fd9-9c5e-fed830e45851

I hope this helps.

Best,

Shannah

Answer 2

Excel 365 Pro Plus with Power Query.

Fill area of polygon.

Laborious for one polygon.

https://www.mediafire.com/file_premium/ktsuklh35e6g3in/03_24_24.xlsx/file

https://www.mediafire.com/file_premium/wevld0tasoqgws2/03_24_24.pdf/file

Answer 3

Well, I don't have any VBA code ready for that, but theoretically we can add a series that draws a lot of lines creates by a scanline algorithm. https://en.wikipedia.org/wiki/Scanline_rendering

So if the distance between the lines are the same as the thickness of the lines you should see a filled poly.

Andreas.

Answer 4

There is another very simple way to create a filled poly, we can create a FreeForm shape from your coordinates. But that will not match the contour on the chart.

Is it possible to create such shapes in a sheet?

Tell us more what's the sense behind and what you want to accomplish.

Andreas.