| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
| change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
Linear Mode
