Crystal Reports XI: Both value and percentage on bar chart.

Hello,

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.
ExpertsExchange.docx
OutOnALimbAlwaysAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Would adding a cross tab to the report be sufficient?

mlmcc
0
OutOnALimbAlwaysAuthor Commented:
Hi mlm,

I didn't even realize anyone commented on the question-- e-e never emailed me concerning it, or I never saw the email.

What I ended up doing was using a subreport that showed percentages. However, I thank you for answering.  Evidently there is no built in way to do it.
0
mlmccCommented:
I never found a way to do it.  You can have both in the legend but not on the chart itself

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OutOnALimbAlwaysAuthor Commented:
Thanks, you stopped me from fruitless effort on that in the future.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.