Timeline Problem

  • Thread starter Thread starter Andibevan
  • Start date Start date
A

Andibevan

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
 
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
 
Hi - your correct - I mean the horizontal axis that in this situation is
actually the Y axis.

How do I format the horizontal axis as a date - this may be a help.

When you say "make sure you use the datevalue for entering max and min on
the axis" I presume you mean the number i.e. 5th April 05 = 38447?

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
 
double click on the numbers at the axis and select number date and the date
format you want.
 
Back
Top