Chemical Forums

Chemistry Forums for Students => Undergraduate General Chemistry Forum => Topic started by: WK95 on November 02, 2013, 11:18:02 AM

Title: Making an energy level diagram with excel?
Post by: WK95 on November 02, 2013, 11:18:02 AM

For a lab, we are to make an energy level diagram for the hydrogen atom based on our observations and measured wavelengths. Just how can I make such a graph with Excel?

Title: Re: Making an energy level diagram with excel?
Post by: curiouscat on November 02, 2013, 11:34:07 AM

Show us your numbers.

Title: Re: Making an energy level diagram with excel?
Post by: WK95 on November 02, 2013, 05:03:21 PM

I was only able to see 3 Emission lines for Hydrogen. Their wavelengths as I've measured are 435nm which reflects a drop from n=5 to 2, 485nm which reflects a drop from 4 to 2, and 650nm which reflects a drop from 3 to 2.

Title: Re: Making an energy level diagram with excel?
Post by: WK95 on November 05, 2013, 10:52:40 PM

I need to make this sort of graph with Excel only.

http://utopia.cord.org/step_online/st1-1/Fig1-13.gif