home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Archive Magazine 1996
/
ARCHIVE_96.iso
/
discs
/
gerald
/
7_06
/
ReadMe
< prev
next >
Wrap
Text File
|
1994-02-02
|
7KB
|
151 lines
%OP%VS4.13 (28-Apr-92), Gerald L Fitton, R4000 5966 9904 9938
%OP%DP0
%OP%IRY
%OP%PL0
%OP%HM0
%OP%FM0
%OP%BM0
%OP%LM4
%OP%PT1
%OP%PDPipeLine
%OP%WC1026,2262,48,1748,0,0,0,0
%CO:A,72,72%
%C%Charts from the Beginning - Part 3
%C%by Gerald L Fitton
Keywords:
Multiple Non-consecutive Charts Fitton
Warning!
Apart from this [ReadMe] file, do not attempt to load and run any of
the other files in this directory from the master disc!
Why is this? Colton Software's hot linked graphics package operates by
saving copies of chart files back to disc. The original file I have
included in this directory will be over written. For that reason I
strongly suggest that you work with back up copies of the files in this
directory rather than the originals.
You can read more about using backup files rather than originals
(including the creation and use of a RAM disc to hold working copies of
the files) in the directory Charts01 (the first of the 'Charts from the
Beginning' tutorials) on another disc.
Outline Fonts
To use the PipeDream Charts facility you will also need outline fonts.
The Homerton and Trinity fonts must be loaded (if in doubt then click
on the !Fonts application) before you load PipeDream to the icon bar.
PipeDream only recognises those fonts which have been loaded before it
is. PipeDream can not add fonts to its 'private' font list after it
(ie PipeDream) has been loaded to the icon bar. If you don't know
whether you had the fonts loaded when you loaded PipeDream then Quit
PipeDream, make sure the fonts are loaded and then load PipeDream back
to the icon bar.
Again, you can read more about my approach to this need for outline
fonts in Charts01. If you send us a Charts application for inclusion
in PipeLine then please use only the Homerton and Trinity fonts.
Introduction
In this, the third tutorial of the Charts series I am going to explain
how you can draw multiple bar charts using data which is not in
consecutive rows. Although I shall concentrate on bar charts, the
principles I explain can be used to draw multiple line graphs using
data which is not in consecutive rows.
Before I start, let me acknowledge that the inspiration for this
article was a problem sent to me by Peter Paddisson. It is his [Stats]
file which I am using as the data for this tutorial. I believe that
the file is the monthly rainfall measured in inches and the original
data he sent me runs from 1888 to about 1970. I'm sorry but I forget
which part of the UK it was for!
If any of you do have problems with Charts (or with anything else) then
it is most likely that others are having similar problems and that the
solution will almost certainly be of interest to other PipeLine
subscribers. Let me make my usual plea for you to send me a worked
example of your problem on a disc so that I can work through the
solution using your data files.
The Statistics
I have included a reduced version of Peter's [Stats] file because the
original is 19áKb whereas the [Stats] file I'm using is only 2áKb.
Double click on [Stats] and you will see that the month names are in
row 2, the year names in column A and the data in the block B3M12.
Peter has calculated an average in column N. We won't be using it in
this tutorial but I would like to see a line graph of the 12 month
moving average at some time - but not today!
The Easiest Chart
Mark the block A2M3 and then execute <CtrláCHN> (CHart New). You will
find yourself with a chart which looks much like [Chart1888], the only
difference being that in the chart you have just produced all the bars
are red whereas, in [Chart1888], the colours of the bars cycle through
a set of nine colours. You can 'convert' your chart to one of many
colours by executing the following sequence. Click the mouse menu
(middle) button on the chart (not on the data) and a menu called Chart
will pop-up. Run the pointer through Gallery and click on Bar. In the
version of PipeDream which I have (Vá4.13) there are seven types of bar
chart presented, a top row of three and a bottom row of four. Click on
the third from the left (the right most) of the bar chart types in the
top row and your bar chart will turn into one having nine differently
coloured bars.
Separated Rows
Now for a harder problem. How to draw a bar chart for the 1889 data
without including one for the 1888 data.
Mark the block [Stats]B2M2 which contains Jan to Dec. Be careful; make
sure that you do not include neither A2 nor N2. I find the easiest way
of marking the block B2M2 to click select in B2 and click adjust (the
right mouse button) in M2.
Execute <CtrláCHN> to create a new chart. You will see a pop-up
message box which reminds you that there is no numeric data in the
marked block. Although there is no numeric data you must choose to
continue by clicking on the Yes box.
Place the pointer in the new chart and click the mouse menu button.
Select Galleryá-áBar and then select the third type of bar chart from
the first row of bar charts. That is the one which gives the multi
colour bars. Finally, click on the OK box.
Mark the block [Stats]A5M5 (note that the year is included in the slot
A5) and then execute <CtrláCHA> (CHart Add) to add the data to the
(blank) chart. You will observe that the legend (contained as text in
slot A5) shows in the chart as year 1890.
Two Sets of Data on One Chart
You can add a second set of data to a bar chart but, personally, I
don't really like the result. I prefer the multiple line graph of
[1888_1889]. The method of crating a line graph with multiple lines,
adding as many as you like, by a second and third line is fairly
straightforward.
Mark the block B2M2 and execute <CtrláCHN>. Click on Yes to proceed
even though there is no numeric data in the marked block. When the
box containing the Chart appears click menu - Bar - Line. Turn off the
3D button, ensure that the first type of line chart has been selected
(the one at the top left) and click on OK.
Now you can mark any row such as the 1889 results in A4M4 and execute
<CtrláCHA> to draw the line graph for that year's data.
If you mark a block such as A6M9 to include three year's data then you
will draw three lines at once (all in different colours)!
In Conclusion
If you do have any problems with creating the Chart you want, then,
like Peter, please send me a disc file of typical data and an
indication of the many things you've tried that didn't work. It does
save me considerable time and allows me to send you back a reply which
uses your data and a chart in the format you want.