Crystal Reports Line Chart

tjkaiser
tjkaiser used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Keep it weekly.  Rt-click on the chart and select Grid.  Select the Group tab and then click on the Labels tab.  Check Use Manual Number of groups and then enter a number - start with 3.  This will space out your labels so you keep the data points but don't have the labels for every week cluttering up the axis.

Author

Commented:
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 McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Check the format for major and minor labels

mlmcc
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Author

Commented:
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 McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

Author

Commented:
Thanks for the assistance!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial