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.