asked on

Crystal Reports Line Chart

I am preparing a chart in Crystal Reports XI. This is a line chart, showing weekly sales for one year. I would like to change the time axis to display months, rather than the week.

If I use onChangeOf Week, I see all of the data points, but the labels for each week are too cluttered. If I use OnChangeOf Month, then I don't see the weekly data points.

Thanks,

Tom

ASKER CERTIFIED SOLUTION

frodoman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tjkaiser

ASKER

Thanks for your response Frodoman,

Just to clarify, I did not see the "Grid" option you mention in your response. In Preview mode, depending on where you right-click, (either an x-axis label or white space in the chart), I did see the "Group (x) Axis Options". When I select that option, there is a checkbox on the Layout tab called "Skip Group Labels", and a box where you can enter a number. I was able to get this to work, where now I can print a label every 4th week. This is closer to the requirement.

I was wondering if there is another way to display weekly data points, but monthly x axis labels.

Thanks,

Tom

Mike McCracken

Check the format for major and minor labels

mlmcc

tjkaiser

ASKER

Mlmcc,

I don't see any properties for major and minor labels. There are majjor and minor gridlines.

Can you be more specific

Thanks,

Tom

Mike McCracken

I don't use chart so it probably is the gridlines. If you make the major the ones you want labeled then don't have a label n the minor you should get what you need.

mlmcc

tjkaiser

ASKER

Thanks for the assistance!