Graph axis adjustment

[SMC]

I have a graph that is made from a query.

To make the query I have two date inputs that then filter the query appropriately.

My graph auto-adjusts the x axis so it is the same size as available data the query produces.
I want the graph to retain the same x-axs min and max as the date inputs.

EX:
6/1/2014 - 8/1/2014
This could return data with the minimum date being 6/15/2014.
Since 6/15 is the minimum date, the graph will adjust its axis to 6/15 as the minimum.

How do I retain 6/1 as the minimum?


The purpose is to show the absence of data points.

[June7]

You might be able to programmatically manage that with code. Depends on the graph type. I have graph (XY Scatter or Line, I forget which one worked) on report and use the Detail section Format event. Excerpt from my db:

Me.Graph1.Axes(xlCategory).MinimumScale = MinAC
Me.Graph1.Axes(xlCategory).MaximumScale = MaxAC

[SMC]

can "MinAC" be something like, [Forms]![Form_Name]![Textbox] ?

[June7]

Yes. MinAC is a variable in my code. Use whatever you want to provide the desired value.