Simple Timeline Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having a tough time creating a graph in Access that shows a simple time
line of equipment failures. The data to graph looks like this;
Expr1 FailDate Start End
0 2/11/2005 Aug-2003 Jul-2004
0 2/10/2005 Aug-2003 Jul-2004
0 3/21/2005 Aug-2003 Jul-2004

What I want to do is have the Start and End dates the range on the x axsis
and a data point at each of the FailDates on a single line. I can do it in
excel by plotting the FailDate column as the x values in series 1 and the
first row of the Start and End date as the x values series 2 (then just not
show the series 2 data points on the graph), and set the column Expr1 as the
y axsis values.

The Start and End dates are fixed for each call of the report and all
FailDates will be between the Start and End. I hope this is enough
information and thanks in advance for your help.

Thanks,

Jim
 
Duane,

I thank you for the examples however, I had already seen them since they
seem to be your answer to all of the previous timeline reporting questions.
If any of the schedule reporting examples were close to what I was looking to
do I would have used one of them and not botherd posting a question here.

Can anyone give a more relevant example or know of a resource that may be
able to help?

Thanks again for your help,

Jim
 
I have the graph working except for the x axis scaling. How do I
dynamically assign the Min and Max values of a graph's x axis?

Thanks again,

Jim
 
I usually create a similar chart in Excel. Then turn on the macro record and
make the changes in the min and max values of the X axis. Stop the recorded
and find the code. This code can usually be modified and applied to the
Access report chart.

I still wouldn't even use a chart control. Doing a little math in report
events seems much easier to me. However, you seem to have chosen a different
path.
 
Back
Top