Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 217

# extrapolating missing values in a chart-line

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")

Yours,
Ovidiu
0
is77dia2
• 2
• 2
1 Solution

Commented:
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 Commented:
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 Commented:
meantime I also solved myself the problem.

no everything is ok.

THANKS frodo!!!

Ovidiu
0

Commented: