you're welcome, Shay ;) happy to help
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Mon, 7/11/11, Shay wrote:
> 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 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 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
> >>
> >>
> >>
> >> > From: shay.buchanan@gmail.com
> >>
> >> >
> >> > 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
> >> > > >
> >> > >
> >> > >
> >> > >
Tidak ada komentar:
Posting Komentar