Solved

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

Posted on 2006-11-14
3
1,170 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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