ACCESS FEED: RE: [MS_AccessPros] Re: Dealing with missing data in chart

Senin, 05 November 2012

RE: [MS_AccessPros] Re: Dealing with missing data in chart

I do that. It is FAR superior.

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Monday, November 05, 2012 2:56 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Dealing with missing data in chart

James

As you've seen, Access has the worst charts in the Office Suite. Why don't you just create the chart in Excel and use your query as the source?

Bill

--- In MS_Access_Professionals@yahoogroups.com, James McAlister <forums01@...> wrote:
>
> Bill, no I haven't. What I need is the average of the previous value
> and the next value when one is missing and was hoping for a chart
> option such as in Excel to automatically interpolate in those cases.
> What I have done to get this one last chart out before the election is
> to create a table where I just entered the desired numbers for the two
> missing days and then used a UNION query to join that to my "real"
> data. Works OK but is admittedly crude.
>
> If there's no built in option, at some point after the election I'll
> review my queries and post SQL here to look for specific ways to
> modify them to accomplish the desired result. This just popped up at
> the last minute when the client wanted to see interpolated on days
> where no data existed. We used this program two years ago and this year, and he was OK with "blanks"
> in the trend line. I'll get if fixed right later but for now have just
> forced it.
>
> Thanks--and I'll be back in touch!
>
> James
> www.james-mc.com
> Words To Live By
>
>
> On Mon, Nov 5, 2012 at 3:38 PM, Bill Mosca <wrmosca@...> wrote:
>
> > **
> >
> >
> > James
> >
> > Have you tried using Nz() in the queries to force a value if null?
> >
> > MyData: Nz([MyField],0)
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com Microsoft Office Access MVP
> >
> > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64
> > 270730881E
> > My nothing-to-do-with-Access blog
> > http://wrmosca.wordpress.com
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, James McAlister
> > <forums01@>
> > wrote:
> > >
> > > In Access 2010 I have a trend chart plotting percentage (y-axis)
> > > versus days (x-axis). This all works well except there are a
> > > couple of days
> > where
> > > there is no data, and there's a break in the trend line. This
> > > happens because I have my queries set up so as to show all days on
> > > the x-axis,
> > even
> > > when there's no data, and that's the way I'd like to keep it. In
> > > Excel there are chart options (such as interpolate) to
> > > automatically deal with missing data points, but I don't see such in Access.
> > >
> > > I'm on a very tight time constraint and am about to add a table to
> > > put in two days of "fake" interpolated data for this one final
> > > chart run before the election tomorrow. That will be OK with the
> > > client, but I may need to investigate a more proper approach later.
> > >
> > > So here's my real question now: is there a chart option that I'm
> > > just overlooking to deal with missing data automatically? And if
> > > so, where is
> > it?
> > >
> > > Thanks!!
> > >
> > > James
> > > www.james-mc.com
> > > Words To Live By
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.