Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Sign up
Appearance settings

excel chart radar

zmworm edited this page Apr 29, 2026 · 16 revisions

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

Based on OfficeCLI v1.0.64

Clone this wiki locally

AltStyle によって変換されたページ (->オリジナル) /