Problem with radar chart, and with activex text box

[stefanlearnsexcel]

Hi guys, I need help with a couple of things.

In the photo you can see that the series lines, for example between SDG3 and SDG4, are connected with a line. The chart uses scores for each SDG. For SDG3 in this case, the score is 4, and for SDG4 the score is 2. I don't want to connect the scores with that line that's between them in the photo. I would like it to end like the line at SDG7. Do you know how to do that?

The activex text box appears double after clicking in it. It's just a box linked to a cell. I want to use it for bringing a lot of text from a cell, in this scrollable text box, that would be easier to use. However, it fuc*s up big time. Any ideas why?

Thanks!

 

[Hui]

First Question use a Scatter Chart not a Radar Chart, you have much more control

Second, I've never seen that behaviour

 

[stefanlearnsexcel]

Thank you, I'll try the scatter chart.
Cheers!

 

[p45cal]

Take a look at some of my posts in this thread (Is msg#8 there the kind of thing you're looking for?):
https://forum.chandoo.org/threads/how-can-we-visualise-this-data-worth-a-try.30349/

 

[stefanlearnsexcel]

Take a look at some of my posts in this thread (Is msg#8 there the kind of thing you're looking for?):
https://forum.chandoo.org/threads/how-can-we-visualise-this-data-worth-a-try.30349/

Thank you, I took a quick look and it seems like very useful information. I will dive into it tomorrow and maybe post some further questions later on. Did not expect a reply anymore haha