University:
Georgia Southern University
Course:
ENGR1121 | Computing in Mechanical Engineering
Academic year:

2024
Views:

396

Pages:

41
Author:

Jalen W.

Graphs/charts • In Excel, graphs are referred to as charts. • x-y graphs (called Scatter Charts or XY Charts in Excel) • Line graphs (called Line Charts in Excel), bar graphs (called Column Charts in Excel), and pie charts • horizontal axis (the x-axis) as the abscissa and the vertical axis (the y-axis) as the ordinate. • In Excel, the horizontal axis is called either the Category Axis or the Value Axis, depending on the chart type. (Category Axis is used in most charts, though Value Axis is used for XY charts.) The vertical axis is always called the Value Axis. CHARACTERISTICS OF A GOOD GRAPH x-y graph in which the data points represent individual measurements - data scatter measured data with a trendline passed through the data two different data sets within the same graph CREATING A GRAPH IN EXCEL • Select a block of contiguous cells containing the data to be plotted (the source data). • The selection may include column headings if the data are entered vertically or row labels if the data are entered horizontally (a less common layout). • Go to the Ribbon’s Insert tab, select the Charts group and click on Recommended Charts. X-Y GRAPHS (EXCEL SCATTER CHARTS, OR XY CHARTS) An x-y graph is created by plotting a series of paired data points. Example 5.1 Creating an X-Y Graph in Excel The voltage drop across a capacitor varies with time in accordance with the formula Example 5.2 Adding Data to an X-Y Graph add two additional data points to the existing data Insert a new row above row 3 and enter the value 0.5 in the new (now empty) cell A3. Copying the formula in cell B2 to cell B3 then produces the corresponding value of the voltage. Since this new data point falls within the existing range of time values, it automatically shows up in the graph Enter the value 12 in cell A14 and copy the formula in cell B13 to cell 14. Next, we drag the outlines surrounding the data in columns A and B so that they include the new data in row 14. The new data point will appear in the graph Example 5.3 Adding Dependent Variables to an X-Y Graph add an additional set of voltages for a second device To add the new voltage data to the graph, simply drag the corner of the outline so that it includes column C. The new data will then be included in the graph automatically Legend: Chart Tools/Design within the Ribbon. Then on Add Chart Element/Legend/Right within the Chart Layouts group. SEMI-LOG GRAPHS voltage versus time data exponential equation Example 5.4 Creating a Semi-Log Graph in Excel LOG-LOG GRAPHS EXAMPLE: POWER EQUATION volume of a sphere Example 5.5 Creating a Log-Log Graph in Excel Create a log-log graph of the area and volume of a sphere as a function of the radius LINE GRAPHS (EXCEL LINE CHARTS) are used to represent single-valued (categorical) data. Usually, the data points represent different values of the same entity, such as the average daily temperature for each of several consecutive days. Example 5.6 Creating a Line Graph in Excel A computer assembly plant operates seven days a week, 16 hours per day. The number of units assembled during a two-week period is given below. BAR GRAPHS (EXCEL COLUMN CHARTS) used to represent single-valued (categorical) data. Unlike a line graph, however, a bar graph utilizes a series of vertical rectangles (bars) to represent the data. Example 5.7 Creating a Bar Graph in Excel PIE CHARTS shows the distribution of individual data items within a data set. Like line graphs and bar graphs, pie charts represent singlevalued data. Example 5.8 Creating a Pie Chart in Excel

Creating an Excel worksheet (Graphs & Charts)

Creating an Excel worksheet (Graphs & Charts) - Page 3

Creating an Excel worksheet (Graphs & Charts) - Page 4

Creating an Excel worksheet (Graphs & Charts) - Page 5

Creating an Excel worksheet (Graphs & Charts) - Page 6

Creating an Excel worksheet (Graphs & Charts) - Page 7

Creating an Excel worksheet (Graphs & Charts) - Page 8

Creating an Excel worksheet (Graphs & Charts) - Page 9

Creating an Excel worksheet (Graphs & Charts) - Page 10

Creating an Excel worksheet (Graphs & Charts) - Page 11

Creating an Excel worksheet (Graphs & Charts) - Page 12

Creating an Excel worksheet (Graphs & Charts) - Page 13

Creating an Excel worksheet (Graphs & Charts) - Page 14

Creating an Excel worksheet (Graphs & Charts) - Page 15

Creating an Excel worksheet (Graphs & Charts) - Page 16

Creating an Excel worksheet (Graphs & Charts) - Page 17

Creating an Excel worksheet (Graphs & Charts) - Page 18

Creating an Excel worksheet (Graphs & Charts) - Page 19

Creating an Excel worksheet (Graphs & Charts) - Page 20

Creating an Excel worksheet (Graphs & Charts) - Page 21

Creating an Excel worksheet (Graphs & Charts) - Page 22

Creating an Excel worksheet (Graphs & Charts) - Page 23

Creating an Excel worksheet (Graphs & Charts) - Page 24

Creating an Excel worksheet (Graphs & Charts) - Page 25

Creating an Excel worksheet (Graphs & Charts) - Page 26

Creating an Excel worksheet (Graphs & Charts) - Page 27

Creating an Excel worksheet (Graphs & Charts) - Page 28

Creating an Excel worksheet (Graphs & Charts) - Page 29

Creating an Excel worksheet (Graphs & Charts) - Page 30

Creating an Excel worksheet (Graphs & Charts) - Page 31

Creating an Excel worksheet (Graphs & Charts) - Page 32

Creating an Excel worksheet (Graphs & Charts) - Page 33

Creating an Excel worksheet (Graphs & Charts) - Page 34

Creating an Excel worksheet (Graphs & Charts) - Page 35

Creating an Excel worksheet (Graphs & Charts) - Page 36

Creating an Excel worksheet (Graphs & Charts) - Page 37

Creating an Excel worksheet (Graphs & Charts) - Page 38

Creating an Excel worksheet (Graphs & Charts) - Page 39

Creating an Excel worksheet (Graphs & Charts) - Page 40

Creating an Excel worksheet (Graphs & Charts) - Page 41

of 41

Description

Struggling with your assignment and deadlines?

Free up your schedule!

Take 5 seconds to unlock