Bar chart, dual axis, auto scale, Zero at same level for both axis

[poujor]

Hi

I'm using Crystal Reports XI and doing an advanced bar chart in a group footer based on product types.

The chart is displaying 3 different set of values on a quarterly basis.

First set of values are Expenses, displayed as negative numbers (using the Y1 axis). Values are typically in the range -50,000 to -20,000,000.

Second set of values are Income, displayed as positive numbers (using the Y1 axis). Values are typically in the range 20,000 to 50,000,000.

Third set of values is a percentage, typically in the -100 to 100% range (Displayed on Y2 axis)

The Y1 axis is set to Auto-Scale to handle the differences between groups - One group might require Y1 scaling from -100,000 to 70,000. The next Group -2,000,000 to 15,000,000

I would like to ensure both axis have zero value at same level.

Does any of you if this is possible? And if yes, how?

An example illustrating the issue:
Using auto-scale and expenses and income ranging from -4,600,000 to 9,000,000 result in an Y1 axis from -5,000,000 to 10,000,000.
This means 'zero' is one third up the axis.
If percentages range from -47 to +43 the Y2 axis results in a Y2 axisx from -50 to 50. Here 'zero' is half way up the axis.

Regards Poul

 

[Madawc]

You could create formula fields that add to the sums and ensures none of them are negative.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[tbear6602]

Hello!

Using CR10 with Oracle 9i.

I'm trying to create what I call a combo-chart. It basically has an X-axis that is common to two sets of data (i.e. month) and then on the left hand axis is on set of data and on the right is another. However, I need the data for the left axis to be represented as a bar chart, and the data on the right axis overlays the bar chart using a line chart.

Make sense? should look something like:

4 |--------/-------| 20
3 |-/\----/--------| 15
2 |/--\--/--|X|----| 10
1 |-|X|\/---|X|----|  5
  |_|X|_|X|_|X|____|
     J   F   M

Please excuse the poor ascii drawing. I hope it gets the idea across. I know how to do this in excel, but can't find the options in Crystal.

Any suggestions?

 

[lbass]

tbear, you should start a different thread, since you are asking a different question.

-LB

 

[poujor]

Madawc, I don't see how your suggestion will help me out. I want to display negative and positive values.

If it was an option to handle max and min values on the Y-axis using a formula, I'd solved it long ago.

I think I'm dreaming about a setting: "Make Y-axis minimum and maximum have same absolute value" ...

This setting would ensure a 'zero' value half way up the Y-axis.

Regards,
Poul