Excel Graph

[randomwalker]

Hi,

I have data in two columns. The data in Column A are, for example, 100, 200, 300, etc. The data in column B are, for example, 100000, 200000, 300000, etc. Now I want to do a graph (using smooth line, for example) in Excel with the two columns of data. I only want to do a graph. The graph appears ugly because the magnitude of the two columns of data is so different. Is there a way to make the graph looks better?

Thank you!

 

[tusharm]

Graphical display of numbers that differ by a magnitude
http://www.tushar-mehta.com/excel/charts/plot magnitude differences.htm