0

I exported data as text file from CST Studio in order to plot them in an excel sheet. Everything was fine except that the angles on top of each other. How to display the angles on the plot at an interval of say 30 (i.e. 0 -> 30 -> 60 -> 90 -> .... -> 330)? I tried converting the chart into a line and then adjust the tick and label position to 30, but when I converted it back to a radar chart, I got the same original plot.

enter image description here

1 Answer 1

1

The outside labels of a radar chart are category labels and will always be text. Formatting options for these labels have always been very limited.

Excel determines automatically how many labels are showing in the available space. In your example it looks like every fourth label is visible.

i.e. 0 - 4 - 8 - 12 - 16 etc.

While you cannot change that algorithm to show every nth label according to your preference, you CAN simply clear some of the source cells so only some of the calculated labels are showing.

In the screenshot, I have highlighted every 4th cell. All the highlighted cells will be showing as category labels. Note how clearing some of the highlighted cells reflects in the chart.

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .