Link to home
Start Free TrialLog in
Avatar of Physimed
PhysimedFlag for Canada

asked on

How to define the maximum width of the bars, in a Crystal Report XI bar chart?

Hi,

I need to be able to define the maximum width of the bars in Crystal Report XI bar chart.

I know that in the propertiy : Chart expert, Option, Bar size you can define the width (Minimumn/small/average/...)

The problem is, if I set it to small it look fine if I have one of two bars in my chart. But as soon as I have more than 6 they are WAY too tiny and too far apart.

What I would like to be able to do, is define what would be the max width and let the system make them smaller if needed.

Is it possible?

FYI : I'm calling my CR Report from VB.Net 2005.
Avatar of Mike McCracken
Mike McCracken

Have you tried using one of the other settings.  I don't believe there is a way to set them directly.

mlmcc
Avatar of Physimed

ASKER

Yes, I've tried all the bar size settings. Witch are :

Minimum - Make the bars the minimum size possible no mater the amount of bars.

Small - The width change depending of the amount of bars presents
Average - The width change depending of the amount of bars presents
Large - The width change depending of the amount of bars presents

Maximum - The bars takes all space available without leaving any gap between them.


Any other ideas?
None.

Graphs and charts are one of Crystal's weak points.

mlmcc
Do you know a way to change this by code?

I saw that we can edit formulas, but can we use code also?

Lets say I can calculate the amount of column I have. I could set by code if less than 4 make it small, if more make it large.
You may be able to.

I don't use charts so is the setting a drop down or is there a FORMULA button available?

mlmcc
From what I've read there is no way to change that by code.

My workaround :

Create 2 identical charts, one with small size bar one with large size bar.
And I show/hide the one I wants by code.
There was no comment because there is no real answer to this question. Make it closed if you want but it has not been abandoned.
ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial