Pivot Charts SUCK - need help

[streamline1000@gmail.com]

I have been trying to get a chart built on the fly for a report for
about 3 days. I have tried multiple query formats, table references,
etc and I keep getting the same problem. The chart will only show the
count() of a field. Yes I've tried selecting SumOf(), but this returns
0 for every record, even though all of them contain whole numbers (ie
354, 3, 83, etc). What I really need is to graph a percent of timely
deliveries. I have 3 departments who each use the same 8 carriers.
for each d1/c1, d1/c2...to d3/c8, I would like to graph the percent of
timely deliveries. Anyone help?

[WindAndWaves]

Re: Pivot Charts SUCK - need help


<streamline1000 @gmail.com> wrote in message news:1107388118 .172998.118270@ g14g2000cwa.goo glegroups.com.. .[color=blue]
> I have been trying to get a chart built on the fly for a report for
> about 3 days. I have tried multiple query formats, table references,
> etc and I keep getting the same problem. The chart will only show the
> count() of a field. Yes I've tried selecting SumOf(), but this returns
> 0 for every record, even though all of them contain whole numbers (ie
> 354, 3, 83, etc). What I really need is to graph a percent of timely
> deliveries. I have 3 departments who each use the same 8 carriers.
> for each d1/c1, d1/c2...to d3/c8, I would like to graph the percent of
> timely deliveries. Anyone help?
>[/color]

what version of access are you using? It would probably be easiest if we could see the actual thing... Could you make a screenshot
and post it on the web?

- Nicolaas

[Ed Robichaud]

Re: Pivot Charts SUCK - need help

It's the same charting engine in both applications.
-Ed

news:1107458246 .306932.110970@ o13g2000cwo.goo glegroups.com.. .[color=blue]
> The charting capablity in Access is something less than wonderful.
> Export the data to Excel and do the chart there. You will save
> yourself many headaches.
>
> Tom
>[/color]

[WindAndWaves]

Re: Pivot Charts SUCK - need help


"Tom" <rtmnews@swbell .net> wrote in message news:1107458246 .306932.110970@ o13g2000cwo.goo glegroups.com.. .[color=blue]
> The charting capablity in Access is something less than wonderful.
> Export the data to Excel and do the chart there. You will save
> yourself many headaches.
>
> Tom
>[/color]

In Access 2003 I have made some amazing charts, it is not as versatile as Excel, but you can definitely do a lot and make them look
great.

[Tom]

Re: Pivot Charts SUCK - need help

It may be the same charting engine, but its a whole lot easier to deal
with in Excel. I've spent days beating on a chart in Access and never
got it right. Had it done in Excel in 30 minutes (add another 4 hours
to automate from Excel).

Tom

[Tom]

Re: Pivot Charts SUCK - need help

I've only dealt with charting in A2K - probably should have specified
that.

Does that imply that its gotten easier to deal with in Access 2003, or
just that you were able to beat it into submission?

Tom

[Terrell Miller]

Re: Pivot Charts SUCK - need help

Tom wrote:[color=blue]
> I've only dealt with charting in A2K - probably should have specified
> that.
>
> Does that imply that its gotten easier to deal with in Access 2003, or
> just that you were able to beat it into submission?
>
> Tom[/color]

Pivot Charts in A2002 are a lot easier and more versatile than anything
in earlier versions of Access. We can do things in A2002 that we had to
do in SAS before ebcause Access charts were so kludgy.

Still not quite as robust as the Excel impplementation , but then again
neither is the VBA window, so who's complaining ;)

--
Terrell Miller
millerto@bellso uth.net

"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison