Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

extrapolating missing values in a chart-line

Posted on 2004-08-31
4
Medium Priority
?
215 Views
Last Modified: 2006-11-17
Dear Sirs,

I have to draw in CR9 a line-chart based on some daily values along several years.
And I have the next situations:
for year 2000 - I have 20 values
2001 - 60 values
2002 - 350 values
2003 - 350 values
Total: 780 values

Actually the values of 2000 takes cca 3% from all values, 2001 takes cca 8%, 2002 takes 45% and 2003 takes 45% of total chart space.
My challenge is that all 4 years shall use the same space of total chart space/values: 25% each.

Any idea how shall be done this in CR????
(in EXCEL this problem can be covered using the "Time-Scale" option from the context menu "Chart Option" and then "Axes")

Many thanks for the answers!

Yours,
Ovidiu
0
Comment
Question by:is77dia2
  • 2
  • 2
4 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 375 total points
ID: 11941608
There's a time-scale option in Crystal.  Create your chart, rt-click on it and select Chart Options -> Grid -> Group Axis.  Click the option for "Show Time Scale"   Click the 'Scale' tab and select "Day(s)" from the dropdown.

If that doesn't give you what you're expecting then let me know.

frodoman
0
 

Author Comment

by:is77dia2
ID: 11950349
hy frodoman,

meantime I found by myself exactly the same solution as you also described, but I still have some small other ... challenges: now the chart is starting to be drawn from 200 and not from 100 (as should be) and second, in the end of the line chart I have a drop line, even the last values in my array are ok.
So all my values represented daily are percentages, varying in my case between 100% - the initial value to 257% the last value.

Any idea??

thanks a lot!

ovidiu
0
 

Author Comment

by:is77dia2
ID: 11950499
meantime I also solved myself the problem.

no everything is ok.

THANKS frodo!!!


Ovidiu
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11951164
Glad I could help
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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 …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

916 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