Solved

Line graph w/ date on the x-axis - not to scale

Posted on 2006-11-14
3
1,176 Views
Last Modified: 2008-02-01
Hi Experts-

I'm hoping there's an easy way to resolve this...

I'm working in Crystal Reports 10 and have a line graph that charts values on the y-axis and dates on the x-axis.  The problem is that the x-axis is not displaying to scale - that is, if I have a value on Jan 19, another value on Feb 24, and another value on Dec 15, those three dates will appear on the x-axis spaced equally.

Is there a way to get Crystal to graph such that dates on the x-axis are properly spaced?  The only option I can think of right now is to add a table to my database that would hold all dates and include that, but it's not really practical.

Thanks for your assistance!
Anne
0
Comment
Question by:cummina
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 500 total points
ID: 17939366
RightClick on the chart and in the options area..under the AXES tab you need to choose SHOW GROUP AXIS and SHOW TIME SCALE. This worked for  me.

I use CR XI, but see what your version has available.

MikeV
0
 
LVL 1

Author Comment

by:cummina
ID: 17940129
Thanks for the help, Mike.  That works nicely.  I knew it had to be something simple.

For those using Crystal 10, this option is found by right-clicking on the chart, selecting Chart Options -> Grid, and then clicking on the Group Axis tab on the left.

Anne
0
 
LVL 17

Expert Comment

by:MIKE
ID: 17942186
Annie:

Sure thing...I'm glad I could be of service...

MikeV
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question