Chart with duration datas in Numbers '09

Question

Level 1

0 points

Chart with duration datas in Numbers '09

Hello,
here's my problem (and sorry for the bad english).
I created a Table and filled with data. In the first column i entered DVD movie's titles and in the second column the duration of those movies. I formatted the cells correctly with the "duration" option so that they show "1h 12m" for example. Now i want to create a Chart with the duration in the Y axis and the movies on the X axis but I'm unable to do so because when I try to select "duration" in the format cell of "Value of X Axis" of the chart options it's greyed out. How can i do? (I can successfully create Charts from numeric values but not from "duration" values.

I'll appreaciate any answer thank you again.

MacBook, Mac OS X (10.6.2), iWorks 09

Posted on Dec 21, 2009 9:33 AM

Reply

Answer 1

Jan 4, 2011 9:56 AM in response to Crysis

C,

You have determined what you can and can not chart. Now all you need to do is change your data to a type that can be charted. Numbers has a function that should do the trick for you: DUR2MINUTES().

For example, if your Durations are in column B, then you could use this formula in column C: =DUR2MINUTES(B).

Regards,

Jerry

Reply

Answer 2

Badunit

Level 7

30,348 points

Jan 4, 2011 9:56 AM in response to Crysis

This is a limitation in the application, they did not fully implement the duration number type. Durations won't plot except in the scatter chart. You have to convert your durations to hours or minutes using DUR2HOURS or DUR2MINUTES and plot that instead. If you want your axis value labels to display as durations, create a one-column table and put it in place of the chart-generated Y axis labels. In that table you will type the duration values that correspond to each gridline of your chart.

Reply

Answer 3

Crysis Author

Level 1

0 points

Jan 4, 2011 9:57 AM in response to Badunit

Thank you very much guys

Reply