Joined: 17 May 2018
Online Status: Offline
Posts: 25
Topic: Crystal Report Chart Posted: 29 Jun 2018 at 9:13am
Hello,
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?
Joined: 17 May 2018
Online Status: Offline
Posts: 25
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
Thanks
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum