Yes—Excel can use a radar chart to compare measurements from different dates, but a radar chart does not have a true time axis. Put the measurements around the chart as categories and each date in a separate series; for a trend that reads clearly from one date to the next, a line chart is usually the better choice.
What “over time” means on a radar chart
A radar chart, also called a spider chart, plots several categories on spokes radiating from a center point. Each series gets a value on every spoke, and Excel connects those values into a shape. The chart is useful for comparing profiles: for example, how a product, team, or service performs across a fixed set of attributes.
Time is not a continuous horizontal axis in this chart type. Excel treats dates or periods as series names, much as it would treat product names in a comparison chart. If you chart January, February, and March, the three months become three overlaid shapes. The spokes remain the attributes—such as quality, delivery, support, cost, and reliability. This shows how the profile differs among the selected periods, not the usual chronological path of a time series.
That distinction matters. A radar chart can make a period-to-period comparison, but it is not automatically a time-series visualization just because the series labels are dates. It also does not show how values changed between dates; the connecting lines join categories within each period, not successive dates.
Arrange the data for a period comparison
For a useful comparison, keep the categories consistent and put each time period in its own column. For example, a worksheet could contain:
- Column A: the five measures—Quality, Delivery, Support, Cost, and Reliability.
- Columns B, C, and D: values for January, February, and March.
- Row 1: clear headers, with the measure name in A1 and the period names in B1:D1.
Each value should use the same measurement and scale across every period. If the measures are percentages, enter percentages consistently; if they are ratings from 1 to 5, use that scale for all dates. Avoid mixing unlike units, such as dollars for one spoke and a percentage for another, unless the purpose and scaling are carefully explained. A radar chart’s common value axis can otherwise make the comparisons misleading.
Keep the list of categories in the same order for every period. Avoid inserting a different measure for just one month or changing a category’s definition midway through the data. If the underlying measures have very different natural ranges, consider converting them to a common, meaningful scale before charting, and document that transformation for readers.
Create the radar chart in Excel for Microsoft 365
- Arrange the worksheet with category names in the first column and period names across the top row, as described above.
- Select the entire table, including its headers—for example, A1:D6 for five measures and three periods.
- On Windows, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Choose Radar with Markers if you want a marker at each category value, or Filled Radar if filled areas suit the comparison.
- Check the chart’s orientation. If the months appear as categories around the spokes and the measures become shapes, choose Chart Design > Switch Row/Column so the measures are the categories and each month is a series.
- Add a descriptive chart title and make sure the legend identifies the periods. For clarity, show only a manageable number of periods at once.
In Excel for Mac, use the Insert tab’s chart controls to choose a Radar chart; the menu layout and wording can vary by release. The data arrangement and interpretation are the same. Excel for the web also has chart-insertion controls, though some chart-formatting options can differ from the desktop app.
Choose a radar style and read it carefully
The standard Radar chart draws a line around the category values. Radar with Markers adds visible points, which can help when there are only a few categories or when a reader needs to identify individual values. Filled Radar colors the area inside each series. With multiple dates, filled areas overlap and obscure one another easily, so a line-based version is often easier to compare.
Read each spoke using the value scale shown on the chart. A point farther from the center represents a larger value, but the shape alone does not reveal exact values. Add data labels when exact readings matter, or keep the source table visible beside the chart. The area enclosed by a shape can look dramatic even when individual changes are modest, so do not treat the apparent size of the filled region as a precise measure of overall performance.
Use a consistent axis scale when comparing separate radar charts. If one chart starts its value axis at zero and another uses a higher minimum, their shapes may look comparable while representing very different magnitudes. In Excel, select or right-click the value axis and open Format Axis to inspect the available bounds and scale settings. The axis runs outward from the center, so check that the chosen bounds make sense for the data.
How many time periods should you show?
There is no fixed Excel limit that makes a particular number of periods automatically readable. The practical limit depends on the number of categories, the differences between values, and how the chart will be viewed. A handful of periods may be manageable; many monthly or daily series usually create a tangle of lines, a crowded legend, and too many competing colors.
For a long history, consider one of these approaches:
- Show a small set of meaningful dates, such as the start, midpoint, and latest period.
- Make separate charts for selected periods, using the same categories and value scale.
- Filter the chart to show one or a few series at a time, where the available chart filters fit your workflow.
- Use a line chart for a long sequence, or a small-multiple layout when each period’s profile needs its own panel.
A radar chart is strongest when the reader is asking, “How does this period’s profile compare with that one?” It is weaker when the question is, “What happened month by month?” The latter requires a visual encoding that makes the order and spacing of time straightforward to follow.
Common problems and fixes
- The chart has the wrong spokes and shapes: Excel may have interpreted rows and columns in the opposite way. Use Chart Design > Switch Row/Column, then confirm that categories are spokes and dates are series.
- Dates appear in an odd order: Radar charts use category order rather than a continuous date scale. Put the date columns in the intended order in the source data; do not expect the chart to space periods by elapsed time.
- Lines overlap: Reduce the number of displayed periods, remove fill, use markers, or choose a line chart. Adding more colors does not solve the underlying clutter.
- The shape exaggerates differences: Review the value-axis minimum and maximum and compare the plotted values with the source table. A truncated range can make small changes look much larger.
- Some values are blank or inconsistent: Check the source cells and category definitions. Missing data may leave gaps or alter the chart’s appearance, while inconsistent scales make comparisons unreliable.
When a line chart is a better alternative
Choose a line chart when the main purpose is to show change through time. Put dates in the first column and one or more measurements in adjacent columns, then select the table and choose Insert > Insert Line or Area Chart and a line option. Excel can plot dates along the horizontal axis, making chronology easier to see than with a radar chart. A line chart also handles many more time points without turning each date into another overlapping polygon.
Use a radar chart when the categories are a stable set of dimensions and you want to compare a few snapshots across those dimensions. Examples include quarterly customer-service scores across the same service attributes, or product test ratings across a fixed set of criteria. Use a line chart when you are tracking a single measure—or a small group of measures—across many dates. For a dashboard, both can be useful: a line chart for the historical trend and a radar chart for a focused comparison of selected periods.
Frequently Asked Questions
Can an Excel radar chart show dates?
Yes. Dates can be the series names in the chart legend, with categories such as measures or attributes around the spokes. They are labels for separate series, not points on a continuous time axis.
How do I put months around the radar chart?
You can arrange months as categories in the source table, but that answers a different visual question: the months become spokes, and each measured variable becomes a series. Because radar charts do not space time continuously, a line chart is generally clearer for month-by-month trends.
Why does my radar chart show the months as spokes?
Excel has likely read the rows and columns in the opposite orientation from what you intended. If measures should be spokes and months should be separate shapes, select the chart and use Chart Design > Switch Row/Column.
Can I animate a radar chart through time in Excel?
A standard Excel radar chart does not automatically animate from one date to the next. You can change which series are displayed or create separate charts for different periods, but a static radar chart compares the series currently shown.
Is a radar chart good for monthly data?
It can compare a few selected months across the same measures, but it is usually a poor choice for a long monthly history. Use a line chart when the goal is to follow a trend in chronological order.
Related
- Excel Meal Plan Template: Build a Weekly Planner That Works
- Excel Keyboard Shortcuts: Essential Keys and Tips Guide
- Excel MAX Between Dates: Find the Highest Value in a Range
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pareto Chart Data Labels: Add and Format ThemTo show data labels on a Pareto chart in Excel for Microsoft 365 on Windows, select the chart,…
- Excel Line Chart Zero Values: What to ChangeExcel plots a numeric zero as a real data point, so a line chart will show it on…
- Excel Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Excel, list each task with a start date and finish date, place…
- Excel Pivot Table Sort by Sum ColumnTo sort an Excel pivot table by its Sum column, right-click any value in that column, choose Sort,…
- Excel Pivot Table Months Not in Order? Fix the DatesIf Excel PivotTable months are out of order, first check whether the source column contains real dates or…
- KPI Dashboard Excel Template: Free ExamplesFree KPI dashboard Excel templates are available through sources such as Microsoft Create and Excel’s File > New…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.