Solved

extrapolating missing values in a chart-line

Posted on 2004-08-31
4
205 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 125 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now