Line Chart in excel with date times

0
votes

I'm trying to create a line chart in excel where the x axis is date time.

ie, the format is

Format

But when I highlight the columns and click the line chart icon I get

Problem

Excel seems to insist on using only one of the dates and always puts the data series in the title.

This seems very strange to me.

What am I doing wrong here?

2
exceldatelinechart
It works so easy for this guy youtube.com/watch?v=c-maLQM66bQ - sav
hmm I probably should have posted on Super user now that you mention it. I found this question posted there. superuser.com/questions/541868/… It seems like there is a work around but its not the greatest solution. - sav
@pnuts I'm using 2013 - sav
The First Image appears when I highlight the dates column, right click it and select Format Cells ... - sav
I figured it out, excel was formatting my second column of numbers as text. So the graph was not generating. - sav

2 Answers

0
votes

You should mark the complete range A and B and then press the button for adding a line chart.

0
votes

I figured it out, excel was formatting my second column of numbers as text. So the graph was not generating.

I didn't notice it at first, but the column indentation indicates that those numbers are actually text fields.