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
|