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.
LVL 8
RickJAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RickJAuthor Commented:
Thanks Jeff,
That sort of information is very helpful, thankyou.
Thanks again to everyone else.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.