Pivot Chart: Stop skipping Dates on X-Axis

P

Prince

I have a pivot chart which pulls 2 pieces of information from one table 1 and
1 from Table 2. All three entries are included for each day. Except somedays
which may have only the one piece of data from Table 2 or none at all. How do
I get the table to automatically fill in all the days whether they have
information or not?
 
B

Bob Quintal

I have a pivot chart which pulls 2 pieces of information from one
table 1 and 1 from Table 2. All three entries are included for
each day. Except somedays which may have only the one piece of
data from Table 2 or none at all. How do I get the table to
automatically fill in all the days whether they have information
or not?
Click to expand...
You'll have to fake the data for the missing days. build a calendar
table and use a query that returns all rows from the calenday and the
data from the tables where the dates match.
 
Top