View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mark Dutton Mark Dutton is offline
external usenet poster
 
Posts: 1
Default Getting the minimum value on the x axis automatically

Hi there

I am graphing times and dates with a stacked bar graph. The first value on
each bar is the start date/time and the second bar is the difference from
the first time. I make the first bar invisible and what I end up with is a
nice little bar going from start time to finish time.

The problem I have is that the start time of say midnight 1/1/08 is 39448.
So my graph which is hours wide is a tiny blip at the right hand end. The x
axis config only lets me set auto (which seems to be 0), or a constant that
I need to type in. I just want the minimum to be the lowest value on my
chart.

Is there a way to do this? I really need it!

Regards

Mark Dutton