Physimed
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.
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.
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?
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
Graphs and charts are one of Crystal's weak points.
mlmcc
ASKER
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.
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
I don't use charts so is the setting a drop down or is there a FORMULA button available?
mlmcc
ASKER
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.
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.
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc