Prevent Graph from showing null 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?
 
F

fredg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot get graph to work properly 1
Graph Report 3
Duane Hookom's Line graph by code 8
graph problem 2
Graph in Report 9
Graph in Access Report 1
Graph of Group data in Group Footer 1
How do I display a custom date range for a graph in a report? 1

Top