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??

The table of months got the x-axis working, which was the biggie. I figured
out which part of the chart to click on to get the y-axis customized (that
would the actual numbers, and if you see a Scale tab you're in the right
place), so count this one resolved.

Thanks, Crystal & Duane!

Regards,

Shay Buchanan

On Mon, Jul 11, 2011 at 8:37 AM, Shay <shay.buchanan@gmail.com> wrote:

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