Graphing Negative Time

  • Thread starter Thread starter jamiefletcher
  • Start date Start date
J

jamiefletcher

Hi all,

I've set my workbook to the 1904 time calculation so have negative time appearing correctly. My problem occurs when trying to represent this in a bar graph. The Y-Axis will number above zero but not below zero. The bars, however, are drawn correctly below zero.

Is there anything I can do to make this graph show negative time on the Y-Axis?


Thanks,
Jamie
 
hi Jamie,

see for the workaround with the text formula:

http://social.technet.microsoft.com/Forums/en-US/excel/thread/fa946ec9-2951-4f15-a86f-297a6e819487/

isabelle


Le 2013-01-03 05:23, (e-mail address removed) a écrit :
Hi all,

I've set my workbook to the 1904 time calculation so have negative time appearing correctly.
Click to expand...

My problem occurs when trying to represent this in a bar graph.

The Y-Axis will number above zero but not below zero. The bars, however,
are drawn correctly below zero.
 
Back
Top