Charts Driving Me Crazy

[aldeb]

I am trying to create a chart on a Form. In Excel I have no problems arranging my data. This is my first try for charts in Access. I have a table. I created a query summing two fields of this table:

Total Workers
Total Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[ClockNbr]<>'*'")
Total Workers = 120

Total Verified
Verified Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[StaPrimary]=True")
Total Verified = 43

So far so good. That is the correct information. What I want in a Chart is two bars side by side. One bar at 120 and the other bar at 43. I have tried everything and cannot get this to work. I am getting confused on the Axis, Data, & Series. I think I need another Field somehow. The totals I would call Monthly Totals

Could someone please help me get this thing started. I have wasted a week and feel like I have learned nothing except how to count in the Query.

After this I would like to be able to show a percentage of those verified. I have 120 workers and 43 are verified. That would be approx 35%. Anyway I am assuming that there is a solution and that I am just floundering for nothing. Thanks in advance.

 

[ColinEssex]

I never use Access charts - I think they're useless. I always use Excel

Col

 

[aldeb]

How can I automate information in Access to an Excel Chart??

 

[aldeb]

I guess I should close this post down. I have received no answers at all.

Anyone got any info on how to take information from an Access table and turn it into an Excel Chart Automatically?

 

[ColinEssex]

Marvellous things the "Help" buttons. . . . . . . . . . There is a fascility on the query toolbar to analyse the query in Excel. It automatically exports the data for you, then you do the graph in Excel.

Also, had you taken the time to look at Access help, there is a heading "exporting Microsoft Access data to Microsoft Excel"

Is that help enough for you?

Col

 

[aldeb]

Hey Collin,

Thanks for your reply and sorry to put you out so!!! If the Help documents could solve all of our problems there would be no need for this Forum. Also, you are the one who stated that graphs in Access are useless and you always you Excel. My question after that Post was how to get the info to Excel and into a Graph Automatically. (maybe macro etc). When my data changes in Access I would like somehow for the Graph in Excel to be updated after the export from Access automatically. I have searched the HELP documents and found nothing on this. Getting the info to Excel I understand. How to automatically update a chart was my question and issue. Thanks again and keep the rolling eyes to yourself if you don't mind. Looking down on others who do not have the same understanding as you is not too cool!

 

[ColinEssex]

In Excel you can create a query and link to external data - the database query or table. Create the graph (with the wizard in Excel) and then all you have to do is refresh the graph whenever you want, it runs the saved Excel query and updates the graph automatically.

Marvellous things the "Help" buttons. . . . . . . . . .its all in Excel help use "External" as the keyword and you'll find it.

If you copy anything, try to make sure you do a better job than when you copied my name. . . . . . . . . . there's only one "L" in Colin

Col

 

[aldeb]

Thanks Collin. I will give it a try. I did not copy your name I typed it. I guess I could leave the extra L off, but I guess you could leave the rolling eyes off also. Thanks again!

 

[ColinEssex]

you're welcome