0

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.

Improve this question

3 Answers 3

Reset to default
2

How to create a chart.

Improve this answer
0

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.

Improve this answer
0

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .