View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Michael Hessler Michael Hessler is offline
external usenet poster
 
Posts: 1
Default Chart with add. line and text

Using Graph 9.0 from ACCESS 2000, I created some charts from
ACCESS tables/queries, X-axis: date, Y-axis: values 0..30. In
order to visualize limits, added some text, f.e. "max. 20
allowed" and a horizontal line at 20. Everything is fine, so far.

Now added some code to get identical X-axis for all charts, not
regarding if data is present or not:
Me.ChartName.Axes(xlCategory, xlPrimary).MaximumScale = Date
Me.ChartName.Axes(xlCategory, xlPrimary).MinimumScale = Date-180

With this the X-axis is fine but the limit line and text moves to
a (random?) location. Wherever possible, I deselected Format -
Letterings - Automatic scale (Not sure about English wording, as
I'm using a German version).

Any suggestions to keep the additional items in place?
Thanks.
Michael