Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
When you refer to the X axis are you refering to the vertical or horizontal
axis? Excel treats the Horizontal axis of a Bar chart as the X axis for some applicaitons but not all. are you generating your stacked bar data by doing delta dates after the first one? did you try formating the horzontal Axis as date? I can do on my computer what I think you are trying to do make sure you use the datevalue for entering max and min on the axis "Andibevan" wrote: Hi All, I am trying to create a time-line graph by usineg a stacked bar chart. I am having problems setting the min and maximum for the X axis (date). Whatever values I put in for the min and max values seem to reset to 0 and 100,000 - is there a resoon for this? How do I set my min and max as 1/1/04 and 15/6/05 respectively? I have tried putting the date and the numerical date in but this doesn't seem to work. Regards Andi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Timeline Chart? | Charts and Charting in Excel | |||
Timeline: where it will match up data automatically | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |