How do I create a dual y-axis? 1

[gillonia]

CR 9 against Oracle

Hi all,
I have a current bar chart created which charts against values in the region 0 - 12000. I've been asked to add another column in the form of a Trendline for values in the region 140,000 - 200,000. Is there any way to create a different scale on a second y-axis so that I can show all this information on the one chart?

This seems like a pretty simple thing to do but I can't find any info on how to progress this.

As usual thnx for any advice/pointers.
cheers, Ian

 

[IdoMillet]

Right-click, Chart Options, Format, General, Layout...

Use the Dual Axis checkbox.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[gillonia]

Excellent, can't think how I didn't see it.... Works like a charm now!
Thnx a lot for your help IdoMillet, Ian