Displaying data: distance from a point

[anna.tenhunen]

Hi!

I'm having trouble displaying information from my questionnaire, which is part of my thesis. I have to display answers in a way that demonstrate how far is the answer in km from a point of origin. I have a certain percentage of answers for each distance interval. I have demonstrated the way I would like to display the info in a drawing from paint (:frusty:), it is attached. Is there any way I can do that in excel? Or anything similar? Ty!

Here's the data:

Distance from point	% of answers
0 - 0,5 km	75 %
0,5 - 1,0 km	15 %
1,0 - 3,0 km	7 %
3,0 -5,0 km	3 %