Graph

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

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.
 
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
 
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".
 
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.
 
Back
Top