Z
z.ghulam
Hi,
I have a line graph used to tally up the number of orders each engineer
does in a week. This works well apart from 2 things:
1) If an engineer is off for a week or completes 0 orders, then there
is no record of a 0 in the database and so there is a break in the line
graph. Whjat I would like is the line graph to show a value of 0 for
these periods. Is there any way to get Access to create a default zero
value in the graph if no records exist?
2) There are a number of engineers who are represented by the lines on
the graph. I would like to change the colour of the key, but when I go
into the graph design, only 3 of the engineers show up on the key, even
though all of them show up when the graph is in preview mode.
Is this some sort of glich - or is it a setting that has to be tweaked.
Thanks in advance - any help greatly appreciated.
I have a line graph used to tally up the number of orders each engineer
does in a week. This works well apart from 2 things:
1) If an engineer is off for a week or completes 0 orders, then there
is no record of a 0 in the database and so there is a break in the line
graph. Whjat I would like is the line graph to show a value of 0 for
these periods. Is there any way to get Access to create a default zero
value in the graph if no records exist?
2) There are a number of engineers who are represented by the lines on
the graph. I would like to change the colour of the key, but when I go
into the graph design, only 3 of the engineers show up on the key, even
though all of them show up when the graph is in preview mode.
Is this some sort of glich - or is it a setting that has to be tweaked.
Thanks in advance - any help greatly appreciated.