i have bar chart showing durations category labels:
the current chart this:
time washington, dc ottowa
by car ---------- 9.435345 hours
on bicycle ------------------- 42.12398918 hours
on foot -------------------------------------------------------- 303.32490324 hours
i want use duration labels using format: 9h 25m 9s.
how can achieve this?
- there no option format 'duration'.
- using 'time' format maxes out @ 24 hours
- if format data strings want, chart unable draw bars.
hi appleforthewin,
sorry, missed using mac.
yes, using excel convert time format , not feasible select "choose cell" when doubling click data label in excel mac.
given situation, can try using custom format time duration cells in excel mac , create chart, copy presentation.
1. copy data in first column excel worksheet. select b2:b4, under home tab, click general in number section. in drop down menu, choose more number formats.
2. in format cells dialog box, under number tab, select custom category, type following string in edit box, click ok.
[h] "h" mm "m" ss "s"
3. in duration time column, input time hh:mm:ss format.
for example, input 09:26:54 9h26m54s, input 42:58:33 42h58m33s, input 303:47:52 303h47m52s.
we should result following picture shows.
4. select a1:b4 first, under insert tab, insert bar chart. click chart, , click add chart element add data labels. the chart should following picture.
5. open presentation, copy chart excel worksheet slides.
please let know if works on side.
regards,
joanne
Office / PowerPoint / Mac / Office 365 for business
Comments
Post a Comment