Hi
Sarah,
Yes, it is
possible to create a
round radar chart in Excel. Here are the
steps:
- First, create a radar chart using the data you want to display.
- Right-click on the chart and select "Select Data" from the drop-down menu.
- In the "Select Data Source" window, click on the "Switch Row/Column" button to switch the data series to the opposite axis.
- Click on the "OK" button to close the window.
- Right-click on the chart again and select "Format Chart Area" from the drop-down menu.
- In the "Format Chart Area" window, click on the "Size & Properties" tab.
- Under "Properties", set the "Angle of first slice" to 90 degrees.
- Set the "Chart Rotation" to 0 degrees.
- Click on the "Close" button to close the window.
Your radar chart should now be displayed as a
circle.
If you want to customize the appearance of your chart further, you can use Excel's formatting options or explore add-ins such as the "
Radar Chart Creator" by Excel Campus.