How do i graph ratio

[mcjavier]

Can you please help me represent the return on investment in a graph? I have Revenue, cost and was able to compute for the ROI using the formula "IF(ISERR("1:"&ROUND(N25/N8,1)),"NA",("1:"&ROUND(N25/N8,1)))"

Legend:
N25 for revenue ($242,278.50)
N8 for cost ($20,674.49)

ROI (1:11.7)

So say i have data for 6 months..how do i graph it?

Helppppppppppp!

Thanks

MC

[Glenn Kennedy]

Your equation is not giving a number that can be charted. It is giving text that Excel doesn't know what to do with. just express your data as a ratio =n25/n8 rounded, if you wish =round(n25/n8,1). This can be charted.