Paradox 9 graph only shows half the values

Hi,

I've created a simple graph that plots approximately 6000 items with three Y values.

Unfortunately, it only shows half of the X values. I have played around with the minimum and maximum X values and other properties without any success.

To verify that it is possible, I imported the data and created a Microsoft Access 2000 form which showed all of the data.

I have also played with different types of charts with no success.

Thanks for any advice.
Larry

Larry Chop, Ottawa

Oh yes, I forgot to add that the same behavior occurs in a report.
Larry

Larry Chop, Ottawa

Yes, I can send the form and test data if that would help.
Larry

Larry Chop, Ottawa

hi all, it does not look good.
I have spent numerous hours fiddling with the chart in the form with no success. The chart seems to break with the overflow between 1200 and 1500 Max X Values.
And I did research on the Web and found the following which I have pasted below.
Dan, any comments?

I hate to recommend to the client to switch to Microsoft Access but if I can't get the graph to work consistently with a varied set of data, I may have no choice. (Sigh)
Yes this is a know bug and on http://www.thedbcommunity.com/ Wish List of Fixes. Has been a problem since Paradox 7 and is still a
problem in 10. Some of the work arounds I have found are contained in the e-mail below.

HTH

-------- Original Message --------
Subject: Re: Charting problems
Date: Wed, 21 Nov 2001 07:12:26 -0700
From: Rick Rans
Organization: TransCanada
Newsgroups: corel.wpoffice.paradox-opal
References: <3BFB115E.6DAD1177@zoolink.com>

Don't you wish the graphing was better. The only way I have found of controlling the Bar Width is to set the "Max x-values"/"Min
x-values" property for graphs in forms and a Group by number of records band/"Min x-values" property for graphs in Reports. (The
Group by Number of Records Band is needed because there is no "Max x-values" options for graphs in Reports that I could find.) By
changing the amount of data displayed, the bar widths change. The user can scroll the graph on screen for forms with the "VCR"
record controls and for reports the graphs will be repeated until all of the data is reported.

Hope this helps.

Rick

Peter Rousseau wrote:

> Hi,
> I have created a bar chart and ran into a couple problems:
>
> 1) The label font is too big and overlaps. I tried setting the font to a
> smaller size but that only showed a result when I printed the chart,
> nothing on the screen. I couldn't find a way to manually adjust the
> column widths (widening the screen is not an option) any suggestions for
> what can I do?
>
> 2) I was thinking of having the user being able to update the graph
> while viewing it. I put a pushbutton on the screen but it won't do
> anything. I am wondering if updating while viewing is disallowed.
> Thanks.
>
> Peter Rousseau

Larry Chop, Ottawa

Just to be sure....


You are looking to create a graph that plots 6,000 points?