Skip to main content
Chemistry LibreTexts

4: Google Workbook (Sheets) - Charts

  • Page ID
    347242
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)

    ( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\id}{\mathrm{id}}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\kernel}{\mathrm{null}\,}\)

    \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\)

    \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\)

    \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    \( \newcommand{\vectorA}[1]{\vec{#1}}      % arrow\)

    \( \newcommand{\vectorAt}[1]{\vec{\text{#1}}}      % arrow\)

    \( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vectorC}[1]{\textbf{#1}} \)

    \( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)

    \( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)

    \( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)

    \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)

    Charts

    Charts Basics

    Sheet Skills Video

    Making and editing a chart, titles

    Instructions

    Video \(\PageIndex{2}\): 3:49 video on inserting and editing a chart (https://youtu.be/201tlRiHmw0) ***Note Graphing Lab 1 Exponential chart is LN(S) vs T, this video shows 1/T vs LN(S) a graph we will use later in the semester

    Insert a Chart

    To insert a chart first highlight the cells you want in your chart

    If you highlight the columns this will use all data in those columns which is useful if you add more later

    Next click Insert then Chart

    Edit a Chart

    To edit a chart click the three dots in the right hand corner of the chart, this will open the chart tool bar to the right.

    Setup lets you choose the type of chart and the other basic set up for the chart. Figure 1 below explains the different options in the setup menu.

    clipboard_e98196cfe2273b2d35ffeaaeeff892d49.png
    Figure \(\PageIndex{1}\): Labeled Chart Editor Toolbar (Poirot)

    You can also customize a chart using the customize tab. This lets you change the look of a chart.

    Chart & Axis Titles

    You can change the title of the chart or the x and y axis of a chart. If you have Use row 1 as headers checked the sheet should automatically use your first row as the title for the axis.

    To change the title you can go to the chart toolbar then customize and select Chart & Axis Titles.

    You can switch between the Chart Title, the Horizontal Axis (x), and the Vertical Axis (y) and change the title text.

    Alternatively you can change the text by double clicking on the title you want to change

    clipboard_e46fd2bf131e40b75ea99bd2946fd3df5.png
    Figure \(\PageIndex{2}\):Changing the title of a chart or axis. (Poirot)

    Trendline and Equations

    Sheet Skills

    Making a line of best fit and types of equations

    Instructions

    You can add a trendline to get the equation for your graph. To add a trendline go to the chart toolbar then customize and select series.

    Scroll down and check off trendline. Use type to select the type of chart then go to label and select Use Equation.

    Type Description Equation
    Linear For data that closely follows a straight line. \(y = mx+b \)
    Exponential For data that rises and falls proportional to its current value. \(y = A*e^{Bx} \)
    Polynomial For data that varies \( ax^{n} + bx^{(n-1)} + … + zx^{0} \)
    Logarithmic For data that rises or falls at a fast rate and then flattens out. \( y = A*ln(x) + B\)
    Power series For data that rises or falls proportional to its current value at the same rate \( y = A*x^{b} \)

     

    clipboard_ea1f07595b149e6c0003e4eca2a0ba751.png
    Figure \(\PageIndex{3}\): Add a trendline and equation. (Poirot)

    Multiple Series

    Sheet Skills Video

    Creating a chart to compare data

    Instructions

    Making Chart with Multiple Series

    Make columns for your data, starting with your independent variable (x axis), then a column for each series. Select your first two columns and make a chart In chart editor select Add Series Click the four boxes to select a data range and select your next column

    Adding Trendlines and Equations

    The steps for adding trendlines and equations are the same for a regular chart but with the added option to Apply to all series or select from the dropdown which series to edit.

    You can also change the color or style of the points by selecting the series from the dropdown


    This page titled 4: Google Workbook (Sheets) - Charts is shared under a not declared license and was authored, remixed, and/or curated by Robert Belford.

    • Was this article helpful?