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

Stacked Column Charts

P: n/a
Does anyone know if stacked column charts are possible in Access and if
so, where I can get some information on them? They don't appear as one
of the choices in the standard Access graphing tool, but I'm hoping
there is a workaround.

Any help is appreciated.

Jan 23 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Wayne wrote:
Does anyone know if stacked column charts are possible in Access and
if so, where I can get some information on them? They don't appear
as one of the choices in the standard Access graphing tool, but I'm
hoping there is a workaround.

Any help is appreciated.


Correction. They don't appear as a choice in the chart creation wizard. You
can change to stacked bar after the chart is created though. Never assume that
the wizards represent everything you can do. Most of them only represent a
small subset of what you can do manually.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 23 '06 #2

P: n/a
Thanks for the reply Rick. Can you point me to any info on how to
accomplish this?

Jan 23 '06 #3

P: n/a
Wayne wrote:
Thanks for the reply Rick. Can you point me to any info on how to
accomplish this?


You double-click on the chart and the chart designer interface opens up. From
there you can modify the chart much the same as would in Excel. On a report you
can only do this in design view of the report. In a form you can do it when in
design view, but can also do so from normal view if the chart's enabled property
is set to yes. The latter is preferred because you will always see the chart
designer with your own data. When you open the chart designer from design view
you will often just see sample data.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 23 '06 #4

P: n/a
Thanks again Rick. I feel like a goose now! I'd never even tried that
because I incorrectly assumed that if stacked column wasn't in the
chart wizard, then it couldn't be done. I'd also trawled the newsgroup
a couple of times before and posted a similar question, but got no
response - in hindsite maybe because the answer was so obvious. I'll
now go and eat humble pie for the rest of the day!

Regards.

Jan 24 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.