| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphing Negative Time
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Graphing Negative Time
hi Jamie,
see for the workaround with the text formula: http://social.technet.microsoft.com/...-297a6e819487/ isabelle Le 2013-01-03 05:23, a écrit : 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| graphing data vs time for different patients | Charts and Charting in Excel | |||
| Graphing time (In weeks) | Excel Discussion (Misc queries) | |||
| Graphing error using Time as X axis. | Excel Worksheet Functions | |||
| Graphing a Time Series of Several Options | Charts and Charting in Excel | |||
| Graphing A Time Series OF Stocks | Charts and Charting in Excel | |||
Linear Mode
