473,401 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Insert Chart into Access 2007 Report

This is what I want to do:

Each report page will list some details about a sample (like time
sampled, where, who sampled) and below it a chart showing the
distribution of the sample (i.e. numbers in categories of less than 2
oz, 2-2.5oz, 2.5oz-3oz, etc.)

I thought that I could add a chart just like in Excel but either I
cannot or am doing something very wrong. In Report Design I click on
Design at the top and then Insert Chart

The first problem I have is that I can only add 6 fields from each
record (and I have more categories for the chart than that).

The second problem is that the chart only gives a sum of the field for
all records and places that chart on all report pages (one page per
record).

And finally - it shows the sample data and not my data in the design,
report, and print preview!

Any help would be appreciated,
Scott.
Oct 2 '08 #1
0 3998

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dave Stone | last post by:
I have a chart in an Excel worksheet which I want to appear in an Access report. The report has an OLEUnbound object which is where I want the chart to appear. The snag is that it needs to be done...
1
by: Paul | last post by:
Let say, I have a table called USERS with the following fields: UserID, Date, Name, ComType. ComType gets it's info from another table called TYPE with fields: TypeID, TypeOfCom, with options:...
3
by: StBond | last post by:
Hi everyone, I am new to Access and Visual Basic so things my be getting across a bit cloudy. I only started using VB for one week. I am having a little problem with the database that I am...
9
by: Patrick.O.Ige | last post by:
I have a code below and its a PIE & BAR CHART. The values now are all static but I want to be able to pull the values from a database. Can you guys give me some ideas to do this? Thanks ...
0
by: JohnnyB | last post by:
I've been wrestling with this off and on for a few days and came close but it's still not right. I'll try to explain it as best I can. I created a report with a pie chart on the first page that...
3
by: dorlesky | last post by:
I've tried numerous times to get Excel to recognise the Excel Chart Object inserted into an Access Report. No Luck. I can get Access to start an instance of Excel, I can get Access to send the...
6
by: Wayne | last post by:
I have an Access 2003 database that has several reports with charts on them that all work fine under A2003. All but one works fine under Access 2007. On this particular chart the chart columns...
2
by: TGG61 | last post by:
I have an Access 2000 query that asks the user for the start date & end date for a report or chart. In the Access report, I can display the start & end dates entered in the query in the header of the...
14
by: Wayne | last post by:
I posted about this problem over 12 months ago and even after Vista SP1 the problem still exists when running an Access database (A2003 and A2007 tested) under Vista. A workaround was suggested by...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.