connecting graph lines for missing data

C

cutthroatjess

Hello,

I have made some graphs, however, if there is missing data there will be
gaps in the graph.
For example, I want the graph to display the total number caught for a trap.
I want it to do it by day. However, if we didn't set a trap on the weekend,
those two days are left out of the graph and a hole appears. It is
specifically formatted by day for a reason, so that shouldn't change.
Any help?

Thanks!

Jesse
 
F

fredg

Hello,

I have made some graphs, however, if there is missing data there will be
gaps in the graph.
For example, I want the graph to display the total number caught for a trap.
I want it to do it by day. However, if we didn't set a trap on the weekend,
those two days are left out of the graph and a hole appears. It is
specifically formatted by day for a reason, so that shouldn't change.
Any help?

Thanks!

Jesse
Click to expand...

In Report Design View, click on the graph.
Tools + Options + Chart
Set the Empty Cells Plotted As to Zero (or interpolated).
 
Top