Mac excel graphing format axis number for an hour

broken image
broken image

in the Format dialog box, which varies for each type of chart element.

broken image

Found inside – If Excel doesn't position the data labels correctly, select an individual label. The whole problem arises because Excel follows the same axis ordering scheme for bar chart category axes as for any other axis in any other chart. I formatted the column for the data as Date and custom “Mar-12”. Excel chart not displaying dates correctly Select Data.