connecting graph lines for missing data

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

Guest

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
 
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).
 
Back
Top