Hello,
I need to create a stock graph which needs more than 24 hours on the y axis.
How do you show more than 24 hours?
One graph needs 27 hours while the other needs 31 hours.
Any help appreciated.
Thanks, Manda.
Hello,
I need to create a stock graph which needs more than 24 hours on the y axis.
How do you show more than 24 hours?
One graph needs 27 hours while the other needs 31 hours.
Any help appreciated.
Thanks, Manda.
Hi manda,
Welcome to the forum.
If you want to show that kind of time, you need to format the time as [h]:mm, see the attachment.
Show more than 24 hrs in a chart.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
DILIPandey,
Thank-you for your help; it worked!
I'm glad you posted your example too, because I saw I had to change my data from 3:30 to 27:30 for it to work properly as well.
Thanks again!
Manda.
You are welcome Manda....
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
Thanks this was a big help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks