Plotting with EXCEL |
Top Up Down
A A |
First try the "Plots" pull-down menu.
Plotting: This is conveniently and flexibly done with EXCEL:
(A) Check that your copy of EXCEL works.
(B) Download the free Excel chart-labeler add-in from www.appspro.com/Utilities/ChartLabeler.htm
(C) Run XYChartLabeler.exe
The Excel add-in "XY Chart Labels" is added to the Excel Tools pull-down menu.
(D) To plot
Write PFILE= or IFILE= from two analyses, or copy from Output Tables.
Copy and paste each of these into EXCEL:
Use "Data" "Text to Columns" to put values in columns
Put the columns to be plotted next to each other:
x-axis values to left of y-axis values.
Highlight numbers to be cross-plotted.
To make a plot:
Click on "Chart Wizard"
Click on "XY Scatter"
"Next"
"Next"
Fill in "Chart Title" and "Value" names
"Next"
Click "A new sheet"
"Finish"
On the plot:
Click "Series 1"
"Clear"
Right click a data point
Click "Format data"
Click "Marker none" (the data points will soon disappear!! - Don't worry!)
Click "OK"
Right click a gridline
"Clear"
Add point labels:
Click on "Chart" tab
Click "Tools"
Click "XY Chart labels"
Click "XY Add"
Click "Centered"
Click "Select label _"
Click "Sheet 1" tab
Highlight point labels
Click red marker
Click "OK"
Point-labeled XY plot appears.
Use the plot to communicate:
Click on plot
Use handles to make the plot square
If drawing toolbar is not active:
Right click a toolbar
Click on Drawing
Click on "line" tool
Draw in a useful line.