This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
hy i was making a chart of light intensity through out the day. i am able to make graph of light intensity but when i try to add time with it in horizontal axis it just make a mess. it would be very helpful if someone tell me the right way to do it
and here when i try to add date and time
may be i am using wrong options
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi DabuXD
Greetings! I am Vijay, an Independent Advisor. Under format code, put following
hh:mm
Do let me know if you have any more question or require further help.
thanks