Axes setting to display mm:ss

[Blake 7]

Hi Guys, could someone recommend axes sttings for the attached graph? This graph reflects mm:ss and i'd like to avoid 0.0!!

The graph in question is Avg. Session Duration on the summary tab


Cheers

[martindwilson]

format axis /number/custom mm:ss and apply

[Blake 7]

ah, ha! that did it! cheers m

[Andy Pope]

If you format AJ10:AL10 with same number format as source cells the chart would automatically pick up the mm:ss format

[Blake 7]

thanks Andy. hope you are well Sir! its actually the axes settings I cant seem to get right as in the min max and major unit and minor unit.. its a bit fiddly! I was trying to create nice increments on the axes! cheers dude for your input

[Andy Pope]

Well thanks

Quickest way is to enter the time values in a cell, for example 0:03:00 and 0:00:30, and then format them as general so you can see the numeric values
Max = 0.002083333 and
Major = 0.000347222

Make sure that the base line of the column charts is always zero, to avoid distorting the charts meaning

[Blake 7]

ahhh - nice one!!! Cheers Andy!