Can you help with a radar chart?

How can I obtain a similar chart where the radar will show a line from the 0 value to the achieved value (in this case 3). See example attached.
I can only obtain a dot at the moment.

Thanks

The "Results" column is displaying #DIV/0!

Whatever function that is... it's probably an average or a sum, right?

Let's say that function is called F(). In the "Results" column, wrap an IF around it that does this:

IF( F()=#DIV/0!, 0, F() )

Well, if F() is a monster, then you might want to simplify the zero check to just using COUNT() on the input range that you're dividing by, for example; but if it's just AVERAGE() or something, use F() itself so it's clearly visible what's going on.


...As an aside, showing a line from the zero value to the display value on either side of the radar point will look exactly the same as what you have.