Radar graph

[Debbie Hurlbut]

I have created a 24 point radar graph. I need to figure
out how to graph just 4 points only on the graph,
without "changing the shape" of the graph. Basically the
graph is round (with 24 points) I want to graph just 4
points which would show a "Box shape" on the round graph.
The 4 points have to connect.

The 4 points are in fixed positions and will not change.

 

[Jon Peltier]

Hi Debbie -

I selected this data and created a radar chart. Excel gave me 24 points
around the periphery of the radar chart, plus four points at N, E, S, and W.

1 1
1
1
1
1
1
1 1
1
1
1
1
1
1 1
1
1
1
1
1
1 1
1
1
1
1
1

The 24 points are all connected. To get the 4 to connect, I selected
the chart, selected Options from the Tools menu, clicked on the Chart
tab, and picked the Plot Empty Cells As: Interpolated option.

- Jon