Help Making Data More Efficient?

[jhern87]

So I'm working on an assignment and have this Excel file so far.. My professor told me "Looks good to me on the calcs. The data presentation is not as efficient though.". I was just hoping to get opinions on how I can make this more "efficient"?Spreadsheet.xlsx

[MarvinP]

Have you ever thought of having 7 columns instead of 7 rows?? You would be able to see a lot more of your data that way.

[jhern87]

Have you ever thought of having 7 columns instead of 7 rows?? You would be able to see a lot more of your data that way.

Yes and I actually did that.. But I transposed the data so it went down but now I can't delete the top data without it effecting my bottom data. Is there a way around this?

[MarvinP]

I'd expect you would need to change your formulas also. The only formulas in the original are in Row 7.

Look at those formulas and change them so they are dealing with Column 7 instead.... This might make you understand the formula and Excel a lot better.

Check the attached to see if it is correct...

[jhern87]

Yeah that looks good (except for the negative prices).

I also need to graph the prices and am having trouble getting them on a line graph (which I'm assuming is the kind to use for this). What might I be doing wrong?