Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

extrapolating missing values in a chart-line

Posted on 2004-08-31
4
Medium Priority
?
214 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 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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 …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

704 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