Forum Discussion
Formating Graph vAxis with mm:ss time format. HOW?
Hi All, I am new here. I have a small Excel (2010) job where I need to format the secondary vAxis and define the min. and max. value (I try to add a screen shot). So let me explain. Currently and bas...
Hi,
In Excel days are integers and time are decimal numbers (01:00 hour represents number = 1/24, etc.). Graph takes your time as numbers. You may enter into the cells you max and min time, apply General format and add that values to axis format. Same for the step. Like this
and attached
Hi Sergei, awesome that worked well. Much appreciated. Your added file helped a lot. See my screenshot.
Read you another time.
So far so good, you are welcome
