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

Question

Level 1

4 points

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?

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

Posted on Sep 20, 2016 1:45 PM

Reply

Answer 1

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:

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)

Reply