Incorrect date/time format in bar graph

Toobor

New Member
Joined
Jun 8, 2017
Messages
1
Hi,
I have a table where I have summed up a number of "times" and I want to present these sums in a bar graph where the y-axis is in number format DD:hh:mm:ss.

My problem is that the y-axis starts from "30:00:00:00" instead of "0" even though I have stated the Axis bound to 0-5.

I have search on the internet and come to the conclusion that the startdate is sometimes 1899-12-30 instead of 1900-01-01 which was implemented because of a bug in [FONT=&quot]Lotus 1-2-3. That is why my graph starts from "30:00:00:00". What I don't understand is why I [/FONT][FONT=&quot]get the right format [/FONT][FONT=&quot]in my table but not in the bar graph. And also when I in a cell enters the value "0" and change the format to "date" I get 1900-01-01.

My question is how do I get the bar graph to starts from 00:00:00:00 instead of 30:00:00:00? [/FONT]


Thank you for your help!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

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