Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

Stacked Column Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Wayne - 23 Jan 2006 08:31 GMT
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.
Rick Brandt - 23 Jan 2006 12:39 GMT
> 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.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Wayne - 23 Jan 2006 21:27 GMT
Thanks for the reply Rick.  Can you point me to any info on how to
accomplish this?
Rick Brandt - 23 Jan 2006 23:45 GMT
> 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.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Wayne - 23 Jan 2006 23:54 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.