Chart with add. line and text

M

Michael Hessler

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reverse axis not working as before... 0
X Axis Tick Labels 0
Line Chart - Problems with labeling X-Axis 3
Date values not appearing correclty in the x-axis 1
Unwanted chart plot area resized when .Axes(xlValue).MinimumScale = "-0.1" 0
Line chart - time series - category axis date format (2007 VBA) 1
secondary Y axis 1
Excel 2007 chart line width + axis labelling with VBA 6

Top