Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
having problems with X-axis scales
Hi I'm drawing a line graph in which the X axis is "Days after surgery" and Y axis is the "concentration". However, I'm having problems with Excel automatically converting my 'days' into a date format when i choose the time scale option for the primary axis. Furthermore, I'm not allowed to have the number zero (0) for my X axis because the Y axis is in Logarithmic mode. This means that I have to start my X axis on Day "1", so that when i try to set the major unit for 5 day intervals (eg 0, 5, 10, 15, 20) it looks like 1, 6, 11, 16, 21. If there is a way around this please let me know, it will be greatly appreciated. -- Shoque ------------------------------------------------------------------------ Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320 View this thread: http://www.excelforum.com/showthread...hreadid=560996 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problems about line breaks in axis titles | Charts and Charting in Excel | |||
Stacked AND Clustered AND Different axis scales | Charts and Charting in Excel | |||
axis problems in excel | Charts and Charting in Excel | |||
"Broken" chart axis for data of different scales | Charts and Charting in Excel | |||
Problems with true value on secondary Y axis | Charts and Charting in Excel |