Excel offers Chart Wizard, which is a series of dialogue boxes that walks you through the
necessary steps to create a chart. To create a chart using the Excel Chart Wizard, follow the
procedure explained here.- Select the data range as was explained earlier in this chapter.
- Click the Chart Wizard icon from the toolbar buttons.
- Select the XY (Scatter) Chart type. The XY Chart type offers four Chart sub-type options.
(It is important to note here that the Linechart is often mistakenly used instead of XY
(Scatter)). - From the four Chart sub-type options, select the “data points connected by smooth lines”
Chart option. - Click on the Next button.
- The selected data range will show in the Data Range box.
- Click the Next button.
- In the Chart Option dialog boxes enter the Chart title, Category (X) axis (this is the x axis
title), Value (Y ) axis (this is the y axis title), and click the OK button.
When creating an engineering chart, whether you are using Excel or using freehand meth-
ods, you must include proper labels with proper units for each axis. The chart must also con-
tain a figure number with a title explaining what the chart represents. If more than one set of
data is plotted on the same chart, the chart must also contain a legend or list showing symbols
used for different data sets.Example 14.6 Using the results of Example 14.1, create a graph showing the value of air density as a function
of temperature.- First you will selectthe data range as shown.
14.6 Plotting with Excel 435
- Next, Pick the Insert tab and then select Scatter with the Smooth Lines and Markers
button.
Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀