O
Odeh Naber
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!
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!