Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / April 2008

Tip: Looking for answers? Try searching our database.

How to Create a Custom Chart in a Report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Odeh Naber - 17 Apr 2008 22:57 GMT
Hiya folks!

In my report, I have a table that shows the following calculated
fields/number for each type of product sold in a restaurant (I
included a sample data):

Product Name - example: Cheeseburger
Product Cost: 1.20 Euros
Product Popularity Percentage: 70%
Average Cost (all products): 2.00 Euros
Average Popularity (all products): 65%

The chart I am trying to create in the same report is as follows:

1. The y-axis on the left side of the chart will show the Product Cost
(in Euros).
2. The x-axis on the bottom side of the chart will show the Product
Popularity (in percentage).
3. The plots in the chart will be each product, depending on its
Product Cost and Product Popularity - and at each plot, I want the
Product Name to appear.
4. There should be a horizontal line appearing starting from the y-
axis where y = the value of Average Cost - this line should continue
horizontally to the right to the end of the chart.
5. There should be a vertical line appearing starting from the x-axis
where x = the value of Average Popularity - this line should continue
vertically upwards to the end of the chart.

I cant seem to find any way to do this?

I hope someone can help!

Thank you!
Odeh Naber - 21 Apr 2008 09:11 GMT
This is a tough one isn't it?  Are there any charts that already exist
in Access to be used in this way? I tried but cant find anything.

What about the properties in SQL behind the chart?  Where would I find
them so I can try myself to alter the data?

Thank you!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.