Pivot Charts SUCK - need help

[streamline1000]

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]

<st************@gmail.com> wrote in message news:11**********************@g14g2000cwa.googlegr oups.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?

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]

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

news:11**********************@o13g2000cwo.googlegr oups.com...

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

[WindAndWaves]

"Tom" <rt*****@swbell.net> wrote in message news:11**********************@o13g2000cwo.googlegr oups.com...

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

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]

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]

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]

Tom wrote:

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

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
mi******@bellsouth.net

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