excel chart radar

Excel: Chart - radar

A dedicated page for the radar (spider) chart type. Radar charts display multivariate data on a polar grid, with each category forming a spoke radiating from the center. Ideal for skill assessments, feature comparisons, and balanced scorecard visualizations.

Path: /{SheetName}/chart[N]

Add command shape:

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar \
  --prop title="Team Skills" \
  --prop series1="Alice:8,6,7,9,8" \
  --prop categories="Code,Design,PM,Testing,Communication" \
  <styling props>

See also: Chart - add, Chart - set.

Chart type variants

Type string	Aliases
radar	spider

Radar-specific properties

Radar style

Property	Default	Notes
radarStyle	standard	Visual style of the radar

Style	Description
standard	Lines connecting points (outlined polygon)
filled	Filled polygon areas
marker	Points with markers at each spoke

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar \
  --prop radarStyle=filled \
  --prop title="Team Skills" \
  --prop categories="Code,Design,PM,Testing,Communication" \
  --prop data="Alice:8,6,7,9,8;Bob:6,9,5,7,7"

officecli set data.xlsx /Sheet1/chart[1] --prop radarStyle=marker

Markers

Markers apply when radarStyle=marker or when explicitly enabled.

Property	Default	Notes
showMarker / showMarkers	true	Toggle marker visibility for the entire chart
marker / markers	—	Chart-level marker: "style", "style:size", or "style:size:color"
series{N}.marker	—	Per-series marker override
series{N}.markerSize	—	Per-series marker size

Marker styles

circle (default), diamond, square, triangle, star, x, plus, dash, dot, none

# Diamond markers at each spoke vertex
officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar \
  --prop radarStyle=marker \
  --prop series1="Team A:7,8,6,9,7" \
  --prop categories="Speed,Power,Skill,Stamina,Luck" \
  --prop marker="diamond:8"

# Per-series markers
officecli set data.xlsx /Sheet1/chart[1] \
  --prop series1.marker="circle:6:4472C4" \
  --prop series2.marker="square:6:ED7D31"

Title styling

Property	Default	Notes
title	—	Chart title text
title.font / titleFont	—	Font family
title.size / titleSize	—	Font size (pt)
title.color / titleColor	—	Font color (hex)
title.bold / titleBold	—	Bold (true/false)
title.glow / titleGlow	—	Glow: "COLOR-RADIUS-OPACITY" or "none"
title.shadow / titleShadow	—	Shadow: "COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"

Legend

Property	Default	Notes
legend	true	Position: top, bottom, left, right, none
legend.overlay	false	Float legend on top of the chart
legendFont / legend.font	—	"size:color:fontname"

Axis features

Radar charts have a radial value axis (center to edge) but no traditional category axis — categories map to spoke directions.

Scale control

Property	Default	Notes
axisMin / min	(auto)	Radial axis lower bound
axisMax / max	(auto)	Radial axis upper bound
majorUnit	(auto)	Concentric ring interval
minorUnit	(auto)	Minor ring interval
axisNumFmt / axisNumberFormat	General	Number format for radial labels (e.g. "0.0")

# Lock radial axis to 0-10
officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar \
  --prop series1="Scores:7,8,6,9,5" \
  --prop categories="A,B,C,D,E" \
  --prop axisMin=0 --prop axisMax=10 --prop majorUnit=2

Axis visibility and styling

Property	Default	Notes
axisVisible / axis.visible	true	Show/hide the radial axis
axisLine / axis.line	—	Radial axis line: "color:width:dash"
majorTickMark / majorTick	—	out, in, cross, none
minorTickMark / minorTick	—	Same as major tick
tickLabelPos	nextTo	nextTo, high, low, none

Fills and borders

Property	Default	Notes
plotFill / plotAreaFill	—	Plot area background: hex, gradient "C1-C2[:angle]", or "none"
chartFill / chartAreaFill	—	Chart area background
plotArea.border / plotBorder	—	Plot area outline: "color:width:dash" or "none"
chartArea.border / chartBorder	—	Chart area outline

Series shadow and outline

Property	Default	Notes
series.shadow / seriesShadow	—	"COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"
series.outline / seriesOutline	—	"COLOR-WIDTH" e.g. "FFFFFF-0.5" or "none"

Data labels

Property	Default	Notes
dataLabels	false	Toggle data labels
labelPos / labelPosition	—	Position: center, outsideEnd, bestFit
labelFont	—	"size:color:bold"
dataLabel{N}.text	—	Custom text for individual label
dataLabel{N}.x/y/w/h	—	Manual layout of individual label
dataLabel{N}.delete	—	Hide individual label
dataLabels.separator	—	Separator between label parts
dataLabels.numFmt	—	Number format for labels

Transparency and opacity

Property	Default	Notes
transparency	0	Series transparency (0-100%)
opacity / alpha	100	Series opacity (0-100%)

# Translucent filled radar for layered comparison
officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar --prop radarStyle=filled \
  --prop series1="Team A:8,6,7,9,7" \
  --prop series2="Team B:6,9,5,7,8" \
  --prop categories="Speed,Power,Skill,Stamina,Luck" \
  --prop transparency=40

Layout control

Property	Default	Notes
x, y	0	Chart position (column/row index)
width	8	Chart width (column units)
height	15	Chart height (row units)
plotArea.x/y/w/h	—	Manual plot area layout (0-1 decimal)
title.x/y/w/h	—	Manual title layout
legend.x/y/w/h	—	Manual legend layout

Display blanks

Property	Default	Notes
dispBlanksAs / blanksAs	gap	How blank cells are handled: gap, zero, span/connect

Conditional coloring

Property	Default	Notes
colorRule / conditionalColor	—	Color data points conditionally
point{N}.color	—	Individual data point color (hex)

Full example: presentation-grade radar chart

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar \
  --prop radarStyle=filled \
  --prop title="Team Comparison" \
  --prop title.size=16 --prop title.bold=true \
  --prop title.font="Arial" --prop title.color=1F2937 \
  --prop series1="Alpha:8,6,7,9,7,8" \
  --prop series2="Beta:6,9,5,7,8,6" \
  --prop categories="Speed,Power,Skill,Stamina,Luck,Defense" \
  --prop colors="4472C4,ED7D31" \
  --prop transparency=30 \
  --prop marker="circle:5" \
  --prop axisMin=0 --prop axisMax=10 --prop majorUnit=2 \
  --prop plotFill=FAFBFC \
  --prop legend=bottom \
  --prop "legendfont=9:6B7280:Arial" \
  --prop x=0 --prop y=0 --prop width=14 --prop height=20

HTML preview support

Feature	Preview	Notes
Polar grid (spokes + rings)	Yes	5 concentric rings
Outlined polygon	Yes
Filled polygon	Yes
Markers at vertices	Yes
Data labels	Yes	Value text at vertices
Custom radial scale	Yes	axisMin/axisMax/majorUnit
Shadow effects	No	Decorative; not rendered
Glow effects	No	Decorative; not rendered

Known quirks

• Radar has no traditional gridlines property. The concentric rings serve as gridlines and are controlled by the radial axis scale (majorUnit), not the gridlines property.
• radarStyle is set at creation for best results. Changing via set works but may not update marker visibility automatically.
• Category axis is directional, not spatial. Categories map to equally-spaced spokes; there is no concept of axis reversal or log scale on the category axis.

Inspect an existing radar chart

# List all charts
officecli query data.xlsx chart

# Inspect a specific chart
officecli get data.xlsx "/Sheet1/chart[1]"

# Render to HTML preview
officecli view data.xlsx html > preview.html

See Also

• Chart - Overview of chart operations
• Chart add - Generic chart add (all types)
• Chart set - Modify existing charts
• Chart get - Read back chart properties

---

Based on OfficeCLI v1.0.64