Prevent Graph from showing null date

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

Guest

I have a graph in a report that shows the data of 5 'series' based off the
date. I want to be able to view the value for each series by day.

The problem I'm having is the graph will include null dates (such as the
weekend) that have no data. How do I prevent these null dates from appearing
in my graph and taking up room?
 
I have a graph in a report that shows the data of 5 'series' based off the
date. I want to be able to view the value for each series by day.

The problem I'm having is the graph will include null dates (such as the
weekend) that have no data. How do I prevent these null dates from appearing
in my graph and taking up room?
Click to expand...

See if this helps.
In Chart Edit mode, click on
Tools + Options + Chart + Empty Cells Plotted as

Select the Not Plotted (Leave Gaps) option.
 
Back
Top