Graph

[Guest]

I need to generate a graph covering a 12 month period (Jan - Dec). Often, no
data exists for one or more months; however, I need to show the month in the
X axis. Is there a way to do this?

Thanks.

 

[AlCamp]

Paco,
You probably will need to have all 12 Dates, but if you have no value for
each date, try
Tools/Options/Charts in MSGraph. You can plot the missing data as 0, or
interpolate the missing values.

hth
Al Camp

 

[PC Datasheet]

If your data is numeric, set the default value of the data field in the
table to 0. If the data is text, set the default value to "N/A".

 

[SA]

Paco:

Sure. Assuming that you are using a cross tab query to generate the data by
month in the query's properties, set the columns property to be 1, 2, 3
etc., or Jan, Feb, Mar, Apr etc. depending on how the data is format for
output.