Excel Help

ducis

Active Member
I have to graph this in excel 2007:
capturedta.jpg

so that it is a double line graph. the problem is I have no clue how to do this when there is missing data?
help please?
 
I use Power Point to create graphs...You can "Insert Chart" with a Power Point Slide. There are many different kinds to choose from (bar, line) are just two of about 15 styles. It will ask you the values on an excel looking box, cut and paste the information from your excel document.

I would actually have to do it and write down all the steps...it takes about 50 steps and I can't really put it into words without doing it. It is complicated the first couple times but it gets easy after a few:)

You can do millions of things with excel...I know a guy at work who has created games with all the formulas...absolutely insane. I have seen excel graphs but do not have any idea on how to create one. Try this article...
http://phoenix.phys.clemson.edu/tutorials/excel/graph.html
 
not really looking for how to do a curve of best fit, I just want to have excel interpolate the missing data
thanks though
 
decided to manually interpolate and use excel's auto complete function... love to learn how to do it right though if anyone knows.
edit figured it out, pm me if your having the same problem
 
Last edited:
Back
Top