![]() |
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 |
All times are GMT +1. The time now is 08:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com