Line Chart with dates / hours

[Akbarov]

Hello Dear community,

I am trying to generate line chart from 3 columns.

I am selecting this 3 columns and trying to insert Line Chart, but result is fail all the time. Can anyone tell me please how to make line chart like in following image?

Is there need for any helper column? Excel not even recommending me any chart for this data.

Thanks in advance.

 

[awoohaw]

Would you be kind enough to post your data instead of using an image. Your task is very data specific and you're asking the forum to recreate your scenario manually which is incredibly time consuming. Mr. Excel has a tool, xl2bb add in (Link Below) that allows you to post mini worksheets of your work. If you cannot use that then please post your data as a table.

Please help the forum help you. Thanks in advance.

 

[Akbarov]

Hello, thanks for reply. here is the sample file.

Book2forum.xlsx

Shared with Dropbox

www.dropbox.com

 

[awoohaw]

What column is the source data of the yellow line?
what column is the source of the red line?
What column is the source of the purple line?
What column is the source of the y-axis?
I am guessing column A is the source of the x-axis.

 

[Akbarov]

What column is the source data of the yellow line?
what column is the source of the red line?
What column is the source of the purple line?
What column is the source of the y-axis?
I am guessing column A is the source of the x-axis.

X-Axis =Column A / in 1 hour increment
Y-Axis = Column F (This column shows time difference between 2 times.)

And colors represent column D, that chart I was shared above is PivotTable Chart. I am hoping to do same without Pivot.

 

[awoohaw]

Where is the the pivot table? That would be super helpful.

 

[Akbarov]

I need to remove Pivot Table, because that chart will be updated by result of VBA. With Pivot I can't do that.

Here is image of Pivot and Chart if usefull

Dropbox

www.dropbox.com

 

[awoohaw]

I need to remove Pivot Table, because that chart will be updated by result of VBA. With Pivot I can't do that.

Here is image of Pivot and Chart if usefull

Dropbox

www.dropbox.com

that isn't really legible.