[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 729
  • Last Modified:

Chart/Graph tutorial

Hello, I need to quickly gain some knowledge in access charting/graphing and dont have any time to search.
Does anyone know of some good resources that will point me in the right direction. I am using access 2003/2007.
Thanks.
0
RickJ
Asked:
RickJ
3 Solutions
 
jjafferrCommented:
Hi Rick

Have a look at this Q, it has some example mdbs for a pie chart:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22435833.html

jaffer
0
 
RickJAuthor Commented:
Thanks jaffer, I will have a look.
0
 
GRayLCommented:
Access Help has a wealth of info
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
RickJAuthor Commented:
Thanks, GrayL. I will check there too.
0
 
GRayLCommented:
I'm running A2003 :) and on clicking Help and entering Charts, I get 30+ hits on good info.
0
 
Jeffrey CoachmanMIS LiasonCommented:
RickJ,

The biggest stumbling block in creating Charts in Access 97-2003 is the wizard.
IMHO, it leaves a lot to be desired.
If you commonly create charts in Excel, this can be frustrating.
The other odd thing is that you can have a chart and a report with two separate sources.
You have to remember if you change the Report criteria, you also have to change the Report's rowsource!

Here is what I do:

Start the wizard (Insert-->Chart) and pick your Table and fields, then just click finsh.
Right-click the chart and modify the Rowsource so that the "Data" is what you want.
Then Double-click on a blank section of the chart to edit it.
In this mode, all the same "Chart Options" you know and love from Excel are available (Just right-click)!
:)
Play around with the options (Toggling between Design View and Preview) until the chart looks the way you want.

It's akward at first, but after a few charts, it's pretty straightforward.

Good Luck!
:)

JeffCoachman
0
 
RickJAuthor Commented:
Thanks Jeff,
That sort of information is very helpful, thankyou.
Thanks again to everyone else.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now