472,954 Members | 2,006 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,954 software developers and data experts.

URGENT: Need to Get charts in Access 2003

Ive never used charts in Access. Somehow I managed to format well shaped charts in Excel but I cant find the way to understand how to create a report in Access that produces a bar or a pie chart based on a one record (summarized) query.
For example: I have a table with statistics. I run a query that sums and gets the total for each category and calculates the percentages over the totals. I need a report that shows those results in a well formated and presented chart.
My query record looks like this (column name in brackets and value in numbers) I could not show it here in horizontal way because it messes up:
[Tot. Cases] 150
[Red] 35
[Red%] 23%
[Green] 35
[Gr%] 23%
[Blue] 60
[Blue%] 40%
[Orange] 10
[Or%] 6%
[Others] 10
[Oth%] 6%
I would like a chart with X axis showing Categories (Red, Blue, etc) and the Y axis showing the # of cases and/or the percentages with the Tot.Cases as the maximum value.
Sorry, I read about PivotCharts but could not figure it out.
I need to present the application tomorrow before the Chairman.
thank you,
Aug 31 '07 #1
3 2279
1,206 Expert 1GB
Have you tried the crosstab query wizard? It might be helpful and worth a shot.

Charts are available in the report design mode by selecting insert and then charts. There are also many chart/graph options contained in the activex controls listing.
Aug 31 '07 #2
Thank you JKIng for your answwer. I cant get an Excel-type graph from the chart option in the report design. I tried with the query I showed but Im unable to get anything. I found getting graphs in Access a real headache. I'm not a VB skilled person as to program the graph myself. I need to know how this wizard works in Access if at all possible.

Or, could I export the query to Excel, make it produce the graph and then call it from within Access? Or is there an easier way?
Aug 31 '07 #3

If you need it in Access the a crosstab query is the way to go.

But here is some food for thought.

I had the same problem. Access Graphing is awful!!!!! and overall Excel is more flexable.

The way I sloved this was to link the my query data into excel.

You might want to try this.
In Excel
1. Go to the Data Menu / Import External Data / Import data.

2. Find you DB, Connect to it.

3. You can select you query right there from the list.

OR (very optional)
if after you select one (table or query) you can "Edit Query"
under "Command Text" you can Select SQL instead of TABLE and just paste youe SQL code there. (This is how I do it, I'd have too many sved queries in my DB if I didn't.)

NOTE: you might want to check out the "Properties" button to see options. Mostly post import formating.

Either way it ends up in Excel and you can format it and make it look nice.

In the future you can right click on the data and select "Refresh Data" (also under the Data Menu).

I doubt you want all this info but i like the way it works for me and want to spread the word.

I hate being hindered by Access lack of charts.

-- Boxcar
Aug 31 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Gargamil | last post by:
How can I display a chart with more than 6 columns of data? Are there third party applications? Can someone point me in the right direction here?? g
by: streamline1000 | last post by:
I have been trying to get a chart built on the fly for a report for about 3 days. I have tried multiple query formats, table references, etc and I keep getting the same problem. The chart will...
by: NickJ | last post by:
Dear all, I've encountered an unusual problem having just recently upgraded an Access 97 database to Access 2000 format and was hoping somebody could point me in the direction of a solution. ...
by: Tom Rahav | last post by:
Dear All! I use Visual Basic .NET 2003 and want to produce graphs by using Office Chart 11.0. I would like to provide this chart with data from an Office Spreadsheet 11.0 and I use the...
by: Wayne | last post by:
I have posted this problem a couple of times over the last few years but have been unable to find a solution that works. Sometimes charts in reports will display showing the design data instead of...
by: Xeijin | last post by:
URGENT I have an assignment to hand in tomorrow, I need to know how to perform numeric calculations in access, I dont know very much about databases so consider this a beginner's query! Well...
by: JonathanParker | last post by:
Looking for some help urgently with some VB SQL Access stuff. You'll have to excuse the messiness of the code, I'm a newbie at all this. I'm running this code with a selection of check boxes to...
by: bubbles | last post by:
Access 2003 front-end with SQL Server 2005 backend. I have charts in the Access application, and these charts have polynomial trend lines. Is there a way, programmatically, to define the...
by: Wayne | last post by:
Several of my Access 2003 databases are exhibiting the same problem under Windows Vista. Charts in forms are not showing any data. Reports are not affected. Charts in reports display as they...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.