Skip to main content Accessibility help
×
Hostname: page-component-8448b6f56d-mp689 Total loading time: 0 Render date: 2024-04-23T16:11:38.536Z Has data issue: false hasContentIssue false

Appendix B: Excel plot functions

Published online by Cambridge University Press:  05 September 2014

David V. Thiel
Affiliation:
Griffith University, Queensland
Get access

Summary

The Microsoft Excel® program has many standard plot functions. As the program is icon based, the plotting of a 2D discrete data set requires the selection of the appropriate plot function (scatter). This function does not include interconnecting lines between the points (as required when plotting data points). It is necessary to highlight the x array and y array when prompted. Axis labels can be added during the formation of the plot.

Once the plot has been completed it can be edited by right clicking on an appropriate part of the graph (e.g. axis labels, data points, axis scale, etc). The plot can be selected, copied and placed into another document as part of a report.

Users are directed to the on-line help functions to assist in more complicated plotting operations.

Type
Chapter
Information
Publisher: Cambridge University Press
Print publication year: 2014

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

Save book to Kindle

To save this book to your Kindle, first ensure coreplatform@cambridge.org is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.

Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.

Find out more about the Kindle Personal Document Service.

Available formats
×

Save book to Dropbox

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.

Available formats
×

Save book to Google Drive

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.

Available formats
×