ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart with add. line and text (https://www.excelbanter.com/charts-charting-excel/162112-chart-add-line-text.html)

Michael Hessler

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