Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2006-11-14
3
Medium Priority
?
1,187 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 2000 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 October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free 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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

604 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