Rich's iMac

Q: Numbers will not format the value for an Average reference line in a chart properly

When I insert a Reference Line for an Average in my chart, I can't find a way to format the value properly.  In the attachment below, I would like the value to display as 6h 48m instead of 6h 48.80952388095238m.

 

Is there a way to do this?

 

Value for Average label does not format properly.png

null, OS X El Capitan (10.11.6), Numbers v3.6.2 (2577)

Posted on Sep 20, 2016 1:45 PM

Close

Q: Numbers will not format the value for an Average reference line in a chart properly

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 20, 2016 2:00 PM in response to Rich's iMac
    Level 6 (19,282 points)
    iWork
    Sep 20, 2016 2:00 PM in response to Rich's iMac

    I suggest:

    - hiding the value for the average

    -  adding a single cell table which calculates the average

     

    It would look like this:

    Screen Shot 2016-09-20 at 3.59.06 PM.png

     

    in the single-cell table on the right

    cell A1 contains the formula:

    =AVERAGE(Table 1::B)

     

    shorthand for this is

    A1=AVERAGE(Table 1::B)