Issue with Graph in excel

[Gautham A]

Hi Team,

Using the following data, I'm trying to plot a line graph with time on y axis and date on x axis. All I'm getting is a single horizontal line. Not sure what to do. Can someone help me on this?

26-10-2020​	20:30:00​
27-10-2020​	19:30:00​
28-10-2020​	19:45:00​
29-10-2020​	21:30:00​
30-10-2020​	22:00:00​
31-10-2020​	23:15:00​
01-11-2020​	23:30:00​
02-11-2020​	22:45:00​
03-11-2020​	22:54:00​
04-11-2020​	23:41:00​
05-11-2020​	16:40:00​
06-11-2020​	18:30:00​

 

[pgc01]

Hi

First thing that comes to mind is that those are not time values but strings.

Assuming cell B2 has one of the values that you posted that seem like time, try in another cell:

=ISNUMBER(B2)

You should get true if it's a time value.

 

[Gautham A]

Hi
I'm getting TRUE when i applied that formula.

 

[pgc01]

Hi

I don't understand the chart you posted. Very strange numbers in the Y axis and all zeros in the X axis?

I just copied your values and tried a line chart and got:

 

[daverunt]

The OPs .png shows 2 series lines. Single series data?

 

[Gautham A]

Hi
This is how I exactly want. But all I'm getting is a flat line. Not sure where it is getting wrong in my excel
The numbers in Y axis are the time at which a file came on different days.

 

[Gautham A]

Hi daverunt,
Yes I'm getting 2 series lines. Ideally I should get only one

 

[pgc01]

Hi

Simply select the time values and insert line chart.
What do you get?

 

[Gautham A]

When I select only column B(time values) I get the values correctly.
But I need the dates in X axis. When I try to include the date as well, then i get a single horizontal line

 

[pgc01]

After you insert the time values, to get the horizontal axis values:

Select the chart.

Ribbon->Chart Tools->Design->Select Data

Click on the Edit button below the Horizontal (Category) Axis Labels

In the box enter the range of the X axis values (or select it in the sheet)