Challenge! Chart Problem in Crystal Reports
I have create a chart in Crystal Reports that uses the following data table to plots the points on the chart:
ARTICLE PRODUCTPROFIT (X-axis) PRODUCTPOPULARITY (Y-axis)
Beef Steak 18.32 euros 5.88%
Pork Cheeks 15.50 euros 11.76%
Lamb Cutlets 17.19 euros 23.53%
Sheep Fillet 16.32 euros 32.29%
Duck Magret 16.26 euros 23.53%
The issues I have are the following:
1. For each point that is plotted, how can I show the Article name instead of the plotted points as the data label? For example, it shows (18.32,5.88) near the point for Beef Steak, but I want it to show "Beef Steak".
2. The above table belongs to the "Meat Dishes" category. For that category I have created two calculated numbers:
Popularity Index (calculated result = 14%)
AverageProductProfit (calculated result = 4.92 euros)
The X-axis should have a line going from point (x4.92,y0) straight up away from the X-axis - I guess dividing the chart into two sections.
The Y-axis should have a line going from point (x0,y14) to the right, away from the Y-Axis - I guess dividing the chart into a further two sections (the end result is a chart with four sections.
Can anyone help with this? I would really appreciate it. If you send your email, I can send you what the chart looks like until now and how I would like it to be.