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
tjkaiserAsked:
Who is Participating?
 
frodomanConnect With a Mentor 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.
0
 
tjkaiserAuthor 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
0
 
mlmccCommented:
Check the format for major and minor labels

mlmcc
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
tjkaiserAuthor 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
0
 
mlmccCommented:
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
0
 
tjkaiserAuthor Commented:
Thanks for the assistance!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.