Print Page | Close Window

Crystal Report Chart

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
Printed Date: 23 Sep 2020 at 2:41am

Topic: Crystal Report Chart
Posted By: dax007
Subject: Crystal Report Chart
Date Posted: 29 Jun 2018 at 9:13am
I am trying to create a stacked bar chart using following data set.

Dept     Jan Feb Mar Apr May
A-Curr    10 29 46 23 44
A-Bud     34 23 57 55 24
B-Curr    50 56 56 67 33
B-Bud     56 89 47 67 35
C-Curr    80 78 76 26 45
C-Bud     18 73 56 63 84
Now when I created "Stacked Bar Chart" it give me one bar for January and split that in 6 different color, same for "Feb" and so on

But instead of that I wan 2 bar for January, one Represent Dept Curr (A-Curr and so on) and 2nd bar represent Dept Bud (A-Bud and so on) same way for other months as well
So i looked at the chart options but can not find an option to split in such a way.

Can somebody please guide me as how can I do this?

Thank you.

Posted By: dax007
Date Posted: 29 Jun 2018 at 10:58am
I think I found the solution. What I found is click on Chart Options -> Axes -> Checked Dual Axes, then multi-Axes will enable. Click on Multi-Axes, there I setup the fields that i wanted to to display on Primary Axis and on secondary Axis.
If you have any other better solution, please reply.
BTW I'm using Crystal Report X11

Print Page | Close Window