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="]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="]get the right format [/FONT][FONT="]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!
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="]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="]get the right format [/FONT][FONT="]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!