Solved

extrapolating missing values in a chart-line

Posted on 2004-08-31
4
210 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
[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
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
New and Previous Value in Crystal Report 8 85
Cyrstal Reports formula to check IsNull 8 47
Sum not calculating correctly 22 62
Additional letters added to Fieldnames - 4 29
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. …
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 …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

752 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