Re: Joining the lines in a Line Chart with Null data
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Wed, 12 Mar 2008 09:54:13 -0600
Evi wrote:
My Line chart shows Fuel usage by over several years.
The grid across the bottom (x axis) shows the month numbers The grid up the
left side shows the amount spent. Each line on the chart represents a
different year.
In November 2006 no fuel was purchased.
Instead of the line being joined from October 06 to December 06 (as one
would in a hand-drawn graph) there is a break in the line.
I can force all 12 month numbers to appear in the Row Headers of the
crosstab query on which the Row Source of the Chart is based by using a left
join with a query containing 2 other queries, one showing all the potential
months 1 to 12 and the other showing all the years in the database. but this
doesn't help because the Values are null
You should force all the months to be present. You can use
IIf or the Nz function to convert Null to 0 so the rest of
the processing has a valid value.
It is not necessary to use a Left Join to get all 12 months.
Instead you can just list the month numbers in the crosstab
query's Column Headings property.
--
Marsh
MVP [MS Access]
.
- Follow-Ups:
- References:
- Prev by Date: Re: Joining the lines in a Line Chart with Null data
- Next by Date: Re: Display Grid
- Previous by thread: Joining the lines in a Line Chart with Null data
- Next by thread: Re: Joining the lines in a Line Chart with Null data
- Index(es):
Relevant Pages
|
