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!