CHART: dates on Y-axis and time on X-axis

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,790
Office Version
  1. 2016
Platform
  1. Windows
I am trying to figure out how to build a schedule chart with the dates on the vertical axis and times on the horizontal axis, and then use error bars for horizontal duration...

The dates ae irregular and the on t horizontal axis is from 6 AM to 6 PM.

I have worked with some charts I found on internet.

The cha has a primary ad secondary axis and I have all the axis showing so I can try to figure it to...

Sample data:

DATE TIME EVENT V ERTICAL POSITION
13 Oct 0700 Test1 30
13 Oct 0800 Test2 40
14 Oct 0900 Test2 30
15 Oct 1000 Test1 35
15 Oct 1100 Test2 45
15 Oct 1200 Test1 55
 
Last edited:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,898
Messages
6,175,274
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top