Graph in Form doesn't show all Values

[JuliePritchard]

I have a graph with Date and Time info along the X Axis - The data it is using goes on for a month, but the graph only displays about the first ten days - any one have any ideas why ???

Julie

 

[MichaelRed]

Julie,

I do not rember the exact cause/resoloution for this. I had a similar problem (long away and far ago?) but I think it was basically the scale setting. If I rember it correctly, I initally generated the graph with less data than the final product, and when it was recreated/refreshed with the full set of data, it was truncated. I needed to set the scale to accomodte the full range of data from the production process.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[JuliePritchard]

Michael,

Where excatly is the scale setting ?

Julie

 

[MichaelRed]

In the Ms. Graph 'applet'. IF memory serves me correctly (and this is a BIG question for me), the applet sets this property when a graph is created, but it does not reset is when the data is changed. It is possible to change it via code form Ms. Access, but I decided to NOT do this as the overall appearance of the chart changed more witht the re-scaling than from just scaling it to the MAX and letting the 'white space' appear on the right of the chart. As I noted previously, I haven't done this in a while, so take these comments with a grain (or several) of 'salt'.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over