Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Charts IV: Charts for the scientist 
 
  Overview  
 Show/Hide lesson sections Trendlines
 Show/Hide lesson sections Error bars
 Show/Hide lesson sections Complex curves
 Show/Hide lesson sections Tips and tricks
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
Use Excel to create scientific charts  

Learn how to use the chart features in Excel to accomplish scientific tasks such as adding a trendline to data or using error bars.

  • Length: 40–45 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Add a trendline to a set of data.
  • Add error bars to data points.
  • Plot a polynomial curve.
  • Add Greek letters, symbols, superscript, and subscript to chart labels.
  • Use logarithmic scales.
  
ABOUT THIS COURSE

This course includes:

  • Four self-paced lessons and four practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
COURSE TEXT

Charts in Excel can show more than columns of sales numbers. Charts can plot and communicate scientific data.

Finding trendlines, showing error bars, and plotting complex curves, charts can be helpful to any college science student. They have value too for any business that wants to be precise about meeting its numbers.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

  
BEFORE YOU BEGIN

If you are unfamiliar with how to create a chart, take the course Charts I: How to create a chart.

For more information about creating charts in Excel, see these courses:
  Go to previous page (disabled)    Next Go to next page
advertisement