Shay,
It seems your problem occurs when you don't have data to display for all months yet you want all months to display. If this is the case, create a query to use as a row source that guarentees displaying of all months. You can create a simple table of all months and use it in an outer join so all months are displayed.
It might help if you provided the SQL view of your row source and tell us what is missing or wrong with your chart.
Duane Hookom
MS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: shay.buchanan@gmail.com
> Date: Sat, 9 Jul 2011 21:24:25 -0700
> Subject: Re: [MS_AccessPros] How to make line graph charts in report behave??
>
> The table i'm pulling from tracks when a document was submitted and when it
> was processed. I am basing the charts off a query which returns the
> processor, the month of submission, the number of submissions, the processed
> month & number processed. I have pie charts for the processors that are
> working right, and I'm trying to get an overall picture from the same query.
>
> The chart I'm having trouble with is supposed to display the number of
> submissions in each month and another chart shows the number of those
> documents processed by month.
>
> So, for instance, I could have documents that start getting submitted in
> January, but processing may not start until March. Ultimately,I want both
> charts to show the same reference points for both axises, with the bottom
> one showing all 12 months. Combining the charts is only an option after
> I've ruled out the separate charts.
>
> The report was originally built in Excel, and i'm comfortable with those
> right-click menus. I can't seem to get the chart wizard to display real data
> so I went with the pivot charts, and with those I can't get either axis to
> change reference points via menu options.
>
> Regards,
>
> Shay Buchanan
>
>
> On Fri, Jul 8, 2011 at 7:30 PM, Crystal <strive4peace2008@yahoo.com> wrote:
>
> > **
> >
> >
> > Hi Shay,
> >
> > the trick to getting exactly what you want on a graph is to modify the
> > RowSource (and everything else!) after the wizard creates it ...
> >
> > sounds like maybe you want an X-Y plot with lines between the markers, 1-12
> > for X-values and something else for Y? What are you charting?
> >
> > If the x-axis values are month numbers, you can use the Month function on a
> > date to pull out the month as a number (or Format to get it as a string)
> >
> > field --> MonthNbr: Month( [datefield])
> >
> > The wizard always wants to aggregate something ... you can see this in the
> > RowSource it creates, which you modify :)
> >
> > what does a chart need? X and Y values ... sorting ... criteria.
> >
> > Just use the wizard to get the chart object
> >
> > then change the RowSource to be anything you want. If you are comfortable
> > with charting in Excel, you can use that knowledge to become a master with
> > Access charts. Right-click is your best friend ;)
> >
> > RowSource -->
> > SELECT x-field, y1-field, y2-field, etc
> > FROM TableOrQuery
> > ORDER BY sort-field
> >
> > WHERE
> > y1-field is the field for the first series
> > y2-field is the field for the second series
> >
> > the wizard always wants to aggregate the data and it is not necessary.
> >
> > Warm Regards,
> > Crystal
> >
> > *
> > (: have an awesome day :)
> > *
> >
> > --- On Fri, 7/8/11, Shay > wrote:
> >
> > > From: Shay
> >
> > >
> > > I want to make my line graph charts display from 1 to 12 on
> > > the bottom
> > > category axis even when I don't have data for that
> > > category. The category
> > > axis is from a month([event date]) field in the query.
> > >
> > > I created the line graph as a pivot chart, mainly because I
> > > couldn't get the
> > > chart wizard control to work.
> > >
> > > Any ideas? Anything more I should add?
> > >
> > > Regards,
> > >
> > > Shay Buchanan
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar