Plotting a Graph - how to

[MeghaJ]

Hi,

I have a range of data for which graph needs to be plotted.

[TABLE="width: 396"]
<TBODY>[TR]
[TD]Performance Indicator</SPAN>[/TD]
[TD] Obj Value</SPAN>[/TD]
[TD] Node1</SPAN>[/TD]
[TD] Node2</SPAN>[/TD]
[TD] Node3</SPAN>[/TD]
[/TR]
[TR]
[TD]Call Setup Success Rate</SPAN>[/TD]
[TD="align: right"]100%</SPAN>[/TD]
[TD="align: right"]98%</SPAN>[/TD]
[TD="align: right"]85%</SPAN>[/TD]
[TD="align: right"]66%</SPAN>[/TD]
[/TR]
[TR]
[TD]Immediate Assignment Success Rate</SPAN>[/TD]
[TD="align: right"]100%</SPAN>[/TD]
[TD="align: right"]0%</SPAN>[/TD]
[TD="align: right"]0.43</SPAN>[/TD]
[TD="align: right"]34%</SPAN>[/TD]
[/TR]
[TR]
[TD]Assignment Success Rate - MO/MT only</SPAN>[/TD]
[TD="align: right"]100%</SPAN>[/TD]
[TD="align: right"]85%</SPAN>[/TD]
[TD="align: right"]99%</SPAN>[/TD]
[TD="align: right"]0.54</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=3></COLGROUP>[/TABLE]



Please let me know how to plot the graph when Node has percentage aswell as decimal values.

 

[Gerald Higgins]

Have you tried doing this ?

As percentage values in Excel are really just decimal values that have been formatted to look like percentages, I would have thought that any chart would ignore the formating.