• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1145
  • Last Modified:

Add an additioanl axis/scale to Crystal Reports chart

Hi,

I have created a report in Crystal Reports XI which displays two data series, one represented with a bar, the other with a line.  

This is all working fine but I would like to show each chart with different scales on the Y axis as they have very different data ranges.  Is it possible therefore to add an additional axis e.g. Z so that each data series has its own scale?
0
CAMSYSTEMS
Asked:
CAMSYSTEMS
  • 3
  • 2
1 Solution
 
MIKESoftware Solutions ConsultantCommented:
Think about using crosstabs for this chart....if you can get your data into a single crosstab ...you can use the crosstab charting option to create you chart...and format it there.

Hope it helps..if not..please provide a sample of your data or report..and we'lll take it from there.

MikeV
0
 
CAMSYSTEMSAuthor Commented:
Thanks I'll try that and see how it goes
0
 
CAMSYSTEMSAuthor Commented:
I have tried a cross-tab but it still isn't giving me what I'm looking for.  I have included the sample data I am using.  There are 2 fields Actual Movement and Actual Closing Balance (which is a running total of Actual Movement) accross 11 periods.

Actual Movement      Actual Closing Balance
-£51,928.41      -£51,928.41
-£972.85      -£52,901.26
-£1,002.85      -£53,904.11
-£1,002.85      -£54,906.96
-£1,036.86      -£55,943.82
£11,038.72      -£44,905.10
-£1,018.20      -£45,923.30
-£1,010.18      -£46,933.48
£11,059.20      -£35,874.28
-£13,079.56      -£48,953.84
£11,062.60      -£37,891.24

If I put this data into Excel and create a chart selecting the option 'Line-Column on 2 Axes' (from Custom Types in Excel pro 2003) I get exactly what I'm looking for.  So my question really is how best to replicate this in Cryastal?

Thanks again
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
Dan WeingartAuthor / CRChartCommented:
You need to create a "dual-Y" axis chart. It is one of the basic chart types on the first tab of the ChartExpert dialog. This creates a chart with Y1 axis on the left and Y2 axis on the right. By default, your first series will be assigned to Y1 and the 2nd to Y2, but you can modify this if you like in the Chart General Options dialog.
0
 
CAMSYSTEMSAuthor Commented:
Thanks for the suggestion Dan3D but I don't have this option in the ChartExpert dialog.  Is it possible this is an additional option in a custom install of Crystal reports XI?
0
 
Dan WeingartAuthor / CRChartCommented:
OK do this:
Go to right mouse menu CHART OPTIONS.  Then go to the AXIS tab. Then click on the "Dual Axis" checkbox.

That should do the trick.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now