Pivot Chart

[livvie]

I have a pivot chart with weeks on the Category Axis. If I select weeks 24,25,26 and 27 but there is only data for 24 and 26 (these are then shown on the graph) how do I show that the others have no data in them I need them to be shown on the chart as it is problems that I am reporting and weeks with no data are very important.

 

[The_Doc_Man]

If you have absolutely no records at all in the time period, you might have to fake something. Normally, Access omits missing data entirely.

Or are you talking about MS Graph pivot charts? (That was ambiguous in your question.)

 

[livvie]

If you have absolutely no records at all in the time period, you might have to fake something. Normally, Access omits missing data entirely.

Or are you talking about MS Graph pivot charts? (That was ambiguous in your question.)

I was afraid of that, was hoping not to have to make dummy records.
Thanks