I have a crystal report bar chart of weekly sales. I can get either the number of sales or the percentage of total sales, but not both. To circumvent this I simply totaled up the sales and did a little math in the section below, but when a day had no sales it does not show up in the bar chart and the percentages are misaligned.
Is there a way to include both value and percentage in the bar chart itself? (By percentage I mean for example Tuesday would be 336/1196 or 28%)
My attached file shows just the values. Please note that Monday had no data and is therefore missing. Therefore, the percentages, had I included them, would be misaligned with the risers. I could always do something like "mon= 0%, Tue=28%.." in the section below but I would really like to include these percentages in the chart itself, or figure out some way to always align them exernally from the chart beneath or on the riser bars.