Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have two columns in my Excel spreadsheet. The first column is a date time column, the second column is a numerical value.

I want to print a chart so that on my X axis the date times are displayed (first column) and on the Y axis the numeric value is (the second column).

Any tips?

Thanks.

share|improve this question

3 Answers 3

How to create a chart.

share|improve this answer

There are built-in tools in Excel to do this. Here's a link for an old version of Excel (you don't specify which one you are using): http://www.ncsu.edu/labwrite/res/gt/graphtut-home.html It will most likely work in a similar way in your version.

share|improve this answer

I have had the best results doing this when I have formatted the date/time column in the form I want it to appear in the plot, prior to creating a scatter plot. ie. If I want Month/day/year Hour:min then I apply that format to the appropriate cells first. It's also possible to specify a custom format for the date/time. Excel 2010 seems to create the plots differently depending on the formatting.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.