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

chart object drives me nut

P: n/a
I have a make-table query which output to a temp table like this
AgeGroup NumberInAgeGroup
0: 9 1
10: 19 2
30: 39 3
40: 49 4
50: 59 4
60: 69 3
80: 89 1

I then base a chart object on this table.
Problem is the chart always consider the first row (which is 0:9 1
in this instance) as the column headings.
How do I let it know that the entire sheet should be charted, not
excluding the first row?

Thanks in advance
NB

Mar 1 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If you use Pivot Chart, that won't happen. You need AccessXP or later for
Pivot Chart.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1125 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
<do******@hotpop.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
I have a make-table query which output to a temp table like this
AgeGroup NumberInAgeGroup
0: 9 1
10: 19 2
30: 39 3
40: 49 4
50: 59 4
60: 69 3
80: 89 1

I then base a chart object on this table.
Problem is the chart always consider the first row (which is 0:9 1
in this instance) as the column headings.
How do I let it know that the entire sheet should be charted, not
excluding the first row?

Thanks in advance
NB

Mar 1 '06 #2

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:WE*****************@newsread3.news.atl.earthl ink.net...

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1125 users have come to me from the newsgroups requesting help '1125 users ????
re******@pcdatasheet.com



--
To Steve:
Over 420 users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R
Mar 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.