ACCESS FEED: Re: [MS_AccessPros] How to make line graph charts in report behave??

Senin, 11 Juli 2011

Re: [MS_AccessPros] How to make line graph charts in report behave??

I'll try the table of months and let you know how that works :)

Regards,

Shay Buchanan

On Sun, Jul 10, 2011 at 11:40 AM, Duane Hookom <duanehookom@hotmail.com>wrote:

> **
>
>
>
> 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]
>
>
>