Chart Help

[IanWaterman]

CR2011 on Oracle 11 using a command

I am trying to build a chart which shows growth of an investment over 10 years by month.
However, I only want to see the years as markers on the X axis, however, crystal insists on showing the months making axis too crowded and unreadable

I am using a simple line chart. I have tried numeric axis which gets me closer but still refuses to show just years. My month formula is text YYMM I have another formula for Years but the chart expert will not allow me to add to report along with months.

Thank you

Ian

 

[IanWaterman]

Found out how to do this

This is my month formula

totext({Date_field},"yy/MM")

1) Place chart in Report Header, insert a new Report Header b section

2) Insert a Crosstab on this Report Header b section

3) Go to Crosstab Expert > In the Row section use the @Month formula and in the Summary fields section use the Measure field

4) While in the Crosstab Expert, select the formula in the 'Row' and select Group Options > Options tab > Check 'Customize Group Name Field' > 'Use a formula as a Group Name' and click on the formula button beside it. Use this code:

split({@Month},"/")[1]

5) Refresh the report and while in the Preview Mode, right-click the Crosstab and select Insert Chart > Go the Chart Expert > Choose Line Chart.

Ian