Tony:
> I can't get my graph to display conventional date format.
I am not sure whether your situation is one to which the extract
below is the answer.
--
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)
QPW v10 and above use a new charting engine, which treats dates
differently than previous versions for numeric axes (like the Y
axis, or
both the X and Y axes in XY charts). You've got to go through
some new
steps for now, for these numeric axes. It's clumsy, but we're
hoping
Corel puts thumb-screws to the people who produced the engine to
change
this back to the old way.
1. Your numeric axis series values MUST conform to
a new format. The cell cannot just contain numeric
data using the date's Julian Time/Date #. If you
want dates or times to appear correctly on your
axis you must first set the axis values for the
date and/or time as a single number in the
following format : YYYYMMDDhhmmss.
For example :
20011231235959 = December 31st, 2001 at 11:59:59 pm.
This is not a suggestion, this is MANDATORY. STUPID,
but mandatory, nonetheless.
2. RightClick the axis, and choose "? Axis Properties",
where "?" is the axis in question (X or Y).
3. Choose the "Scale" tab, and turn off "Automatic"
4. Set your "Max Value" to the NUMERIC value of your most
recent date/time (which is the highest number).
5. Set your "Min Value to the NUMERIC value of your oldest
date/time (which is the lowest number).
6. Choose the "Numeric Format" tab, and set "Category" to
"Date, then "Format" to your desired format.
7. If you press <Help> at this point, click <How To>, and
then <Display> in the next dialog, you will be
presented with help on how to set the Numeric format.
You absolutely *must* conform to the two notes there,
which are reproduced below :
Notes
==========
· In order to format dates and times to properly display in a
chart, you
must first concatenate the date and time as a single number as
follows:
YYYYMMDDhhmmss. For example, 20011231235959 = December 31st,
2001 at
11:59:59 pm.
· Maximum, minimum, and increment values must be set precisely
in the
axis properties dialog box to allow dates to properly appear on
the axis
of your chart. For example, to create a y-axis scale that ranges
from
the start to the end of the year 2001, incremented by month, you
would
use 20011201000000 as the Max value, 20010101000000 as the Min
value,
and 100000000 as the Increment value.
--
=====================
Michael Scott [C_Tech Volunteer - Quattro Pro]
|
Roy:
>I am not sure whether your situation is one to which the extract
below is the answer.
I tried reformatting the date column as described in the extract and had
limited success. The dates show up on the X-axis, but for data that spans
over years, large gaps occur in the graph at the ending/beginning of year.
Perhaps something more persuasive than thumbscrews could be used on the
people responsible, or maybe I'll just switch to Excel. Thanks for your
help.
Tony
|