Graphs

[cheeneyeverton]

Here's hopping one of you can help me

I am trying to create a graph. Week no along the bottom, 0-100% along the left hand side and a Line for each name's percentage.

[TABLE="width: 325"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Week No[/TD]
[TD]Sara Cheeney[/TD]
[TD]Kim Brierley[/TD]
[/TR]
[TR]
[TD]Week 2013 41[/TD]
[TD]64.1%[/TD]
[TD]99.8%[/TD]
[/TR]
[TR]
[TD]Week 2013 42[/TD]
[TD]76.6%[/TD]
[TD]77.2%[/TD]
[/TR]
[TR]
[TD]Week 2013 43[/TD]
[TD]74.9%[/TD]
[TD]93.7%[/TD]
[/TR]
[TR]
[TD]Week 2013 44[/TD]
[TD]81.7%[/TD]
[TD]99.3%[/TD]
[/TR]
[TR]
[TD]Week 2013 46[/TD]
[TD="align: right"]0[/TD]
[TD]92.1%[/TD]
[/TR]
[TR]
[TD]Week 2013 47[/TD]
[TD="align: right"]0[/TD]
[TD]86.8%[/TD]
[/TR]
[TR]
[TD]Week 2013 48[/TD]
[TD]66.3%[/TD]
[TD]93.6%[/TD]
[/TR]
[TR]
[TD]Week 2013 49[/TD]
[TD]65.1%[/TD]
[TD]88.5%[/TD]
[/TR]
[TR]
[TD]Week 2013 50[/TD]
[TD]71.0%[/TD]
[TD]83.1%[/TD]
[/TR]
[TR]
[TD]Week 2013 51[/TD]
[TD]100.2%[/TD]
[TD]100.0%[/TD]
[/TR]
[TR]
[TD]Week 2013 52[/TD]
[TD]103.5%[/TD]
[TD]96.9%[/TD]
[/TR]
</tbody>[/TABLE]

When I do it it leaves the line hovering at the bottom and not at the % it is.

Can you help?

Thanks
Chris

 

[wigi]

Do you have real numbers in the cells, instead of text?

0.641 is the real number
64.1% can be the formatted result

Input the raw numbers as in the first case and you will be able to plot them.