Draw Smooth Transparent Shapes on Radar Chart


New Member
Jan 18, 2011
Hi guys,

I have tried to run the code given to draw smooth transparent shapes on radar chart, as suggested by Peltier as shown in the website below.


I believe some of you should be an expert in handling the chartin Excel, therefore your help will be greatly appreciated!

It seems there is some customization needed in order for this code to run smoothly at any excel file. You guys can help me to highlight anything that I might miss out on the code written.

Once again, thank you for your great assistance and help, guys! Looking forward to hearing back a good news from you guys soon!

Warmest Regards,


Sub DrawTransparentShapesOnRadarChart()
Dim cht As Chart
Dim srs As Series
Dim iSrs As Long
Dim Npts As Integer
Dim Ipts As Integer
Dim myShape As Shape
Dim Xnode As Double, Ynode As Double
Dim Rmax As Double, Rmin As Double
Dim Xleft As Double, Ytop As Double
Dim Xwidth As Double, Yheight As Double
Dim dPI As Double
Dim iFillColor As Long
Dim iLineColor As Long

'Dim Pict As Object
'Dim xlApp As Excel.Application
'Dim xlWB As Workbook

'Set xlApp = New Excel.Application
'Set xlWB = xlApp.Workbooks.Open(excelfile)
'Sheets("CMP Tool Capacity Model").Select
'Set Pict = ActiveSheet.ChartObjects("Chart 2")
Set cht = ActiveChart
Xleft = cht.PlotArea.InsideLeft
Xwidth = cht.PlotArea.InsideWidth
Ytop = cht.PlotArea.InsideTop
Yheight = cht.PlotArea.InsideHeight
Rmax = cht.Axes(2).MaximumScale
Rmin = cht.Axes(2).MinimumScale
dPI = WorksheetFunction.Pi()
For iSrs = 1 To cht.SeriesCollection.Count
Set srs = cht.SeriesCollection(iSrs)
Select Case srs.ChartType
Case xlRadar, xlRadarFilled, xlRadarMarkers
Npts = srs.Points.Count
Xnode = Xleft + Xwidth / 2 * (1 + (srs.Values(Npts) - Rmin) / (Rmax - Rmin) * Sin(2 * dPI * (Npts - 1) / Npts))
Ynode = Ytop + Yheight / 2 * (1 - (srs.Values(Npts) - Rmin) / (Rmax - Rmin) * Cos(2 * dPI * (Npts - 1) / Npts))
With cht.Shapes.BuildFreeform(msoEditingAuto, Xnode, Ynode)
For Ipts = 1 To Npts
Xnode = Xleft + Xwidth / 2 * (1 + (srs.Values(Ipts) - Rmin) / (Rmax - Rmin) * Sin(2 * dPI * (Ipts - 1) / Npts))
Ynode = Ytop + Yheight / 2 * (1 - (srs.Values(Ipts) - Rmin) / (Rmax - Rmin) * Cos(2 * dPI * (Ipts - 1) / Npts))

.AddNodes msoSegmentLine, msoEditingAuto, Xnode, Ynode
Set myShape = .ConvertToShape
End With
For Ipts = 1 To Npts
myShape.Nodes.SetEditingType 3 * Ipts - 2, msoEditingSmooth
Select Case iSrs
Case 1
iFillColor = 44
iLineColor = 12
Case 2
iFillColor = 45
iLineColor = 10
Case 3
iFillColor = 43
iLineColor = 17
End Select

With myShape
.Fill.ForeColor.SchemeColor = iFillColor
.Line.ForeColor.SchemeColor = iLineColor
.Line.Weight = 1.5
.Fill.Transparency = 0.5
End With
End Select

End Sub

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...