By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Pivot Charts SUCK - need help

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a

<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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a

"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.
Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

P: n/a
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

Nov 13 '05 #6

P: n/a
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
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.