{"presentation":{"slides":[{"elements":[{"x":20.76502732240437,"y":19.43844492440605,"width":57.92349726775956,"height":66.95464362850971,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/8BULXhOrpbk","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"9e5d8d6d-3b2c-46e1-9e29-a12d2e66a02a","metadata":{"contentType":"Video","license":"U","title":"Welcome to Week 8"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":26.229508196721312,"y":4.319654427645788,"width":49.18032786885246,"height":6.479481641468682,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Welcome to Week 8: Video Message<\/span><\/strong><\/span><\/p>\n"},"subContentId":"b8a79a6e-41f2-40be-9e13-096554ecb4ad","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":7.625272331154684,"y":15.053763440860214,"width":83.87799564270152,"height":12.903225806451612,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Graphing with Excel, Multiple Data Series<\/span><\/p>\n"},"subContentId":"d759049b-2a80-405a-a2b4-1785384a28db","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":7.625272331154684,"y":27.906666666666663,"width":81.69934640522877,"height":64.51612903225806,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

\n\t
Shifting the y axis<\/span><\/li>\n\t
Single x value, multiple y values with similar magnitudes<\/span><\/li>\n\t
Two different sets of x and y values on the same chart, similar magnitudes<\/span><\/li>\n\t
An XY graph with a secondary x or y axis<\/span><\/li>\n\t
Creating a fake axis<\/span><\/li>\n<\/ul>\n"},"subContentId":"2595a18f-f5cb-46f9-9570-69d32794a0db","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":10.893246187363834,"y":21.50537634408602,"width":84.9673202614379,"height":77.41935483870967,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Numerical data is usually in tables but often one wants to display it in a graphic form to help visualize and interpret the variation, patterns, and trends within the data.<\/span><\/span><\/p>\n\n
What is the goal of the graph?<\/span><\/span><\/p>\n\n
\n\t
\n\t
Showing how values relate to one another<\/span><\/span><\/p>\n\t<\/li>\n\t
\n\t
Showing how the data is distributed<\/span><\/span><\/p>\n\t<\/li>\n\t
\n\t
Showing how values compare to each other<\/span><\/span><\/p>\n\t<\/li>\n<\/ul>\n"},"subContentId":"b1366277-e189-42f2-b8b8-a829f5851dc9","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.278688524590164,"y":12.958963282937365,"width":91.80327868852459,"height":71.27429805615552,"action":{"library":"H5P.SingleChoiceSet 1.11","params":{"choices":[{"subContentId":"36153725-75a0-439a-b5fd-7bca592d0c4b","question":"
In Excel, when graphing x and y, where y = mx+b the chart format to use is <\/p>\n","answers":["
an XY scatterplot<\/p>\n","
a line chart<\/p>\n"]},{"subContentId":"93fbe155-35b9-422a-b1ff-64502819c322"}],"overallFeedback":[{"from":0,"to":99,"feedback":"No. A line chart distributes category data evenly along a horizontal (category) axis , and distributes all numerical value data along a vertical (value) axis. To show a relationship between two variables use a scatter chart also called an XY chart."},{"from":100,"to":100,"feedback":"Yes. When you want to show the relationship between two variable, use the scatter chart. Scatter is often called XY chart."}],"behaviour":{"autoContinue":true,"timeoutCorrect":2000,"timeoutWrong":3000,"soundEffectsEnabled":true,"enableRetry":true,"enableSolutionsButton":true,"passPercentage":100},"l10n":{"nextButtonLabel":"Next question","showSolutionButtonLabel":"Show solution","retryButtonLabel":"Retry","solutionViewTitle":"Solution list","correctText":"Correct!","incorrectText":"Incorrect!","muteButtonLabel":"Mute feedback sound","closeButtonLabel":"Close","slideOfTotal":"Slide :num of :total","scoreBarLabel":"You got :num out of :total points","solutionListQuestionNumber":"Question :num","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."}},"subContentId":"fe1255af-b474-4447-9b74-f3b59530ab7e","metadata":{"contentType":"Single Choice Set","license":"U","title":"Line Chart vs Scatterplot"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":68.96174863387978,"y":90.49676025917927,"width":24.043715846994534,"height":6.479481641468682,"action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"support.microsoft.com\/en-us\/topic\/present-your-data-in-a-scatter-chart-or-a-line-chart-4570a80f-599a-4d6b-a155-104a9018b86e?ui=en-us&rs=en-us&ad=us"},"title":"Line Chart vs Scatter Chart"},"subContentId":"16ff8a80-d27e-4322-9bf4-317ef539b7db","metadata":{"contentType":"Link","license":"U"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":1.0928961748633879,"y":90.71274298056156,"width":75.40983606557377,"height":5.183585313174946,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Confused? Review the Week 7 recorded lecture or follow the link to read more:<\/span><\/p>\n"},"subContentId":"46dc4f2c-145b-43fc-b7a0-23b0c63763b6","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":32.748538011695906,"y":2.3094688221709005,"width":30.409356725146196,"height":11.547344110854503,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Pick the correct answer.<\/span><\/p>\n"},"subContentId":"9decf416-d9ab-4c1b-a188-331ad77dd98c","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":64.27015250544663,"y":10.75268817204301,"width":30.501089324618736,"height":34.62365591397849,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"An excel graph showing negative y values beneath the x axis","file":{"path":"images\/file-6043f4d83fdf1.jpg","mime":"image\/jpeg","copyright":{"license":"U"},"width":734,"height":422}},"subContentId":"dad202b3-19ba-4edc-973b-ef019c817a82","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.357298474945534,"y":10.75268817204301,"width":47.930283224400874,"height":40.86021505376344,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
By default, Excel will plot negative y values below the x axis. In some cases, such as the plots of reaction kinetic data shown below, you will want to shift the negative y values above the x axis.<\/span><\/p>\n"},"subContentId":"5336a4c8-ce7c-4f3c-8d9c-b8f6f48e94c8","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":19.607843137254903,"y":54.83870967741935,"width":71.78649237472767,"height":45.16129032258064,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-6043f17783665.png","mime":"image\/png","copyright":{"license":"U"},"width":936,"height":298},"alt":"Graphs showing plots of rate data. One shows negative y values above the x axis.","title":"" Using Graphs to Determine Integrated Rate Laws" by LibreTexts is licensed under notset ."},"subContentId":"eb5cba6c-b301-4d59-a6e2-50318fd26fad","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":49.01960784313726,"y":32.25806451612903,"width":15.250544662309368,"height":25.161290322580644,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-6043f5f9ce7dc.jpg","mime":"image\/jpeg","copyright":{"license":"U"},"width":577,"height":481},"alt":"Red arrow"},"subContentId":"e65128b3-137d-45df-bb21-2c1bc363b6e7","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":10.893246187363834,"y":12.903225806451612,"width":78.43137254901961,"height":79.56989247311827,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/BR2ViLJsdG0","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"c3aba0a4-a592-46f2-a0f7-cfd79bbd563c","metadata":{"contentType":"Video","license":"U","title":"Shifting y axis"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":29.411764705882355,"y":4.29436559139785,"width":47.930283224400874,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
How to shift the y-axis in Excel (4:45)<\/span><\/p>\n"},"subContentId":"226b578a-d9b5-4c9e-bed6-fbb0feb22ddf","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":5.446623093681917,"y":17.163978494623656,"width":86.05664488017429,"height":70.96774193548387,"action":{"library":"H5P.SingleChoiceSet 1.11","params":{"choices":[{"subContentId":"80e515f9-3e8f-4c97-956a-93d53a8216c2","question":"
If you want to plot negative y values above the x axis in Excel<\/p>\n","answers":["
Format the y axis so that the horizontal axis crosses where desired and format the position of the labels (Low) on the x axis.<\/p>\n","
Make all of the y values postive and then add negative signs in front of the y axis labels.<\/p>\n","
Format the x axis vertical cross value and position the x axis labels next to the axis.<\/p>\n"]},{"subContentId":"61c9aced-b570-4839-8356-a9eabb893d38"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"autoContinue":true,"timeoutCorrect":2000,"timeoutWrong":3000,"soundEffectsEnabled":true,"enableRetry":true,"enableSolutionsButton":true,"passPercentage":100},"l10n":{"nextButtonLabel":"Next question","showSolutionButtonLabel":"Show solution","retryButtonLabel":"Retry","solutionViewTitle":"Solution list","correctText":"Correct!","incorrectText":"Incorrect!","muteButtonLabel":"Mute feedback sound","closeButtonLabel":"Close","slideOfTotal":"Slide :num of :total","scoreBarLabel":"You got :num out of :total points","solutionListQuestionNumber":"Question :num","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."}},"subContentId":"c60ad72e-e509-48d0-9f04-bfb40f8045b7","metadata":{"contentType":"Single Choice Set","license":"U","title":"Shifting the y axis"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":21.052631578947366,"y":4.618937644341801,"width":31.57894736842105,"height":6.928406466512702,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Pick the correct answer.<\/span><\/p>\n"},"subContentId":"463e55fb-be6d-4454-bf79-d0fbde006fc3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":59.01639344262295,"y":25.91792656587473,"width":35.95628415300546,"height":54.64362850971922,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-6036c888a78af.jpg","mime":"image\/jpeg","copyright":{"license":"U"},"width":1194,"height":920},"alt":"A graph showing two data sets"},"subContentId":"94f48584-ec5c-495e-80dc-d504b17a6f7f","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":63.387978142076506,"y":8.646047516198704,"width":34.97267759562841,"height":15.11879049676026,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Figure 10.<\/span><\/span><\/span><\/strong> <\/strong>Activation energy E<\/span><\/span><\/span>a<\/span><\/span><\/span>, as calculated with the KAS method versus degree of conversion \u03b1.<\/span><\/span><\/span><\/p>\n"},"subContentId":"91fa7b2f-5e72-4105-a1a0-a269b1e6c58a","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":61.20218579234973,"y":79.98790496760259,"width":38.14207650273224,"height":19.43844492440605,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Note. From J. John, S. Rugmini, & B. Nair. (2018). Kinetics and Mechanism of the Thermal and Hydrolytic Decomposition Reaction of Rosocyanin<\/em>. International Journal of Chemical Kinetics, 50(3), 164\u2013177. https:\/\/doi.org\/10.1002\/kin.21148. Copyright 2018 Wiley Periodicals, Inc<\/span><\/p>\n"},"subContentId":"45b17fa1-b578-44d2-97b0-8e9d2d5434e1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":6.5359477124183005,"y":32.25806451612903,"width":46.84095860566449,"height":34.40860215053763,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Here is an example from a journal article where two sets of data with the same x values and y values of similar magnitude are plotted on one graph.<\/p>\n\n
Take note of the formatting: axes titles with units, major tick marks, legend, title, etc.<\/p>\n"},"subContentId":"b9b52566-4a04-4e27-87f6-5ac089cd4e7c","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":27.3224043715847,"y":75.5939524838013,"width":32.78688524590164,"height":22.24622030237581,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Also take note of the APA style attribution:<\/span><\/strong><\/span> <\/span><\/strong>The ordering and format of details is slightly different than it will appear on a references page.<\/span><\/span><\/p>\n\n
<\/span><\/span>Visit Seneca library for more details<\/a><\/strong><\/span><\/span><\/p>\n"},"subContentId":"68b29bfb-a052-4153-9b01-f23268982e47","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":5.446623093681917,"y":10.75268817204301,"width":40.30501089324619,"height":10.75268817204301,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Plotting Multiple Data Series<\/span><\/strong><\/p>\n"},"subContentId":"92a0110a-b97e-4c3a-92d2-7936e41f56d7","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":66.66666666666666,"y":17.278617710583152,"width":22.950819672131146,"height":6.479481641468682,"action":{"library":"H5P.Shape 1.0","params":{"shape":{"fillColor":"#fff","borderWidth":"2","borderStyle":"solid","borderColor":"rgb(0, 0, 0)","borderRadius":"0"},"type":"circle","line":{"borderColor":"#000000","borderWidth":"1","borderStyle":"solid"}},"subContentId":"fdd29dbe-1c98-4c5d-9f8a-3acc4dd02185","metadata":{"contentType":"Shapes","license":"U"}},"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false},{"x":56.830601092896174,"y":23.77840172786177,"width":36.0655737704918,"height":55.72354211663067,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"An x versus y plot with multiple data sets","file":{"path":"images\/file-6036caf4a55f9.jpg","mime":"image\/jpeg","copyright":{"license":"U"},"width":867,"height":677}},"subContentId":"7cb7d61b-7e60-45cb-b1b7-4133be917169","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":56.830601092896174,"y":8.639308855291576,"width":41.31147540983606,"height":15.11879049676026,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
FIGURE 4. <\/span><\/strong>Main products of mixture E (HME H precursor) as a function of temperature. We estimate an analytical uncertainty of 6% for most species measured. Lines are only to guide the eyes <\/span><\/span><\/p>\n"},"subContentId":"780119ed-4a60-4b5d-9bf9-5db4f45fbf56","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":52.459016393442624,"y":79.98790496760259,"width":46.448087431693985,"height":19.43844492440605,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Note. From. Kinetics of isopropanol decomposition and reaction with H atoms from shock tube experiments and rate constant optimization using the method of uncertainty minimization using polynomial chaos expansions (MUM\u2010PCE)<\/em>. L. Mertens & J. Manion (2021). International Journal of Chemical Kinetics, 53(1), 95\u2013126. https:\/\/doi.org\/10.1002\/kin.21428<\/a>. Copyright Wiley Periodicals, LLC.<\/span><\/p>\n"},"subContentId":"f6ee197c-68f8-4c66-bfb5-f3364e04e3c7","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":8.743169398907103,"y":41.03671706263499,"width":39.97821350762527,"height":23.65591397849462,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Another figure taken from a journal article showing a graph with multiple data series.<\/span><\/p>\n"},"subContentId":"6a97bcdf-5f52-44fc-9532-d16c17d6fac4","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":1.0893246187363834,"y":32.21763440860215,"width":32.6797385620915,"height":19.354838709677416,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Watch this video (11:56) to learn how to graph one set of x values with multiple series of y values of SIMILAR magnitude.<\/p>\n"},"subContentId":"2619de23-2d35-4c95-8496-a3395f40eaa1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":38.12636165577342,"y":6.451612903225806,"width":58.82352941176471,"height":86.02150537634408,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/2MkVXY7026o","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"a17bb37e-eca8-403a-9268-73677272f812","metadata":{"contentType":"Video","license":"U","title":"Excel graphing single set of x values with multiple y values of similar magnitudes"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091503,"y":77.41935483870967,"width":33.769063180827885,"height":17.204301075268816,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
I recommend watching it on YouTube (not on on the small screen within this app) so that you will have the option to view full screen.<\/span><\/p>\n"},"subContentId":"a8f3d5c0-2afb-41bf-b8d2-663b4f0f7efa","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":2.185792349726776,"y":30.29157667386609,"width":92.89617486338797,"height":62.634989200863934,"action":{"library":"H5P.SingleChoiceSet 1.11","params":{"choices":[{"subContentId":"4b064d85-7090-4e20-9358-6926ba67d755","question":"
Do you always connect the data points on an Excel XY scatterplot?<\/p>\n","answers":["
No. One adds an appropriate trendline to the data series when it is mathematically\/scientifcally relevant.<\/p>\n","
Yes. A graph is not complete unless the data points are connected.<\/p>\n"]},{"subContentId":"e93a618c-1283-44c7-b0b0-041dab637b51","question":"
When Excel generates a graph it is advised to leave the axes as determined by Excel?<\/p>\n","answers":["
No. Often one needs to format the axes so that it makes the most sense for your data and what message you are trying to communicate.<\/p>\n","
Yes. Excel chooses the best boundaries based on your data.<\/p>\n"]},{"subContentId":"b48a3f8f-9d72-4d5a-b388-fc53470fb55b","question":"
If I am using a figure\/graph from an external source I only need to cite it on the References page.<\/p>\n","answers":["
No. A figure or graph taken from somewhere else needs an attribution beneath the figure\/graph as well as to be listed on the References page. The formatting of the attribution is different in style and ordering than what appears on the References page.<\/p>\n","
Yes. You do not need to give credit to the original author more than once.<\/p>\n"]}],"overallFeedback":[{"from":0,"to":67,"feedback":"Review course material on any questions answered incorrectly."},{"from":68,"to":100,"feedback":"Great score."}],"behaviour":{"autoContinue":true,"timeoutCorrect":2000,"timeoutWrong":3000,"soundEffectsEnabled":true,"enableRetry":true,"enableSolutionsButton":true,"passPercentage":100},"l10n":{"nextButtonLabel":"Next question","showSolutionButtonLabel":"Show solution","retryButtonLabel":"Retry","solutionViewTitle":"Solution list","correctText":"Correct!","incorrectText":"Incorrect!","muteButtonLabel":"Mute feedback sound","closeButtonLabel":"Close","slideOfTotal":"Slide :num of :total","scoreBarLabel":"You got :num out of :total points","solutionListQuestionNumber":"Question :num","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."}},"subContentId":"7954d83b-0b41-4ae8-8dc1-6b2bb4df1729","metadata":{"contentType":"Single Choice Set","license":"U","title":"Untitled Single Choice Set"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":15.204678362573098,"y":6.928406466512702,"width":30.409356725146196,"height":6.928406466512702,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Pick the correct answer.<\/span><\/p>\n"},"subContentId":"c6679f05-5eb2-4763-af66-68b8b640b742","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":1.0893246187363834,"y":32.25806451612903,"width":33.769063180827885,"height":36.55913978494623,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Often you will have multiple series of data with different X and Y values, but they are both of similar magnitude. Here is how you use Excel to graph this type of data set.<\/p>\n\n
Video 2:55<\/p>\n"},"subContentId":"4caf9291-cef3-4638-886a-f7943f4e98d2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":37.03703703703704,"y":10.739247311827956,"width":61.00217864923747,"height":86.02150537634408,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/dBdOW7Z5X8E","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"5316862d-5ddd-411e-b1b8-003a7ce1c895","metadata":{"contentType":"Video","license":"U","title":"Plotting two different sets of X and Y values on the same chart, similar magnitudes"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":8.714596949891067,"y":34.40860215053763,"width":37.03703703703704,"height":25.806451612903224,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
You may want to present data on the same graph but the X or Y values are dissimilar and you require a secondary axis. Here is an example from a journal article where a secondary Y axis was used.<\/p>\n"},"subContentId":"fdf0453c-c748-4c9d-b4b0-1ef5b8972d4c","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":51.19825708061002,"y":4.29436559139785,"width":44.66230936819172,"height":73.9784946236559,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"A graph where a secondary Y axis was used to display a data series.","file":{"path":"images\/file-60380f96c012f.png","mime":"image\/png","copyright":{"license":"U"},"width":710,"height":594}},"subContentId":"b92f5e02-d11e-4787-a85b-cd61c47327f0","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":52.287581699346404,"y":77.41935483870967,"width":46.84095860566449,"height":19.354838709677416,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Note. From. Numerical simulation of the mass transfer process of CO2 absorption by different solutions in a microchannel<\/em>. By R. Dong, D. Chu, Q. Sun, Z. Jin. Can J Chem Eng. 2020; 98: 2648\u2013 2664. https:\/\/doi-org.libaccess.senecacollege.ca\/10.1002\/cjce.23781<\/a>. Copyright 2020 Canadian Society for Chemical Engineering.<\/span><\/p>\n"},"subContentId":"cb403a30-71cc-417f-a085-95992b655182","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":21.78649237472767,"y":2.1438172043010755,"width":62.091503267973856,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
How to create a secondary axis in Excel (7:40)<\/span><\/p>\n"},"subContentId":"b0d97c6e-446b-4a76-919f-8ca3abbdbec2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.357298474945534,"y":10.75268817204301,"width":89.32461873638344,"height":86.02150537634408,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/iYoVmYmVGEA","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"b8d235fd-bb93-48f6-97d5-db14e09a2842","metadata":{"contentType":"Video","license":"U","title":"How to create a secondary axis in Excel"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.278688524590164,"y":23.77840172786177,"width":54.6448087431694,"height":53.99568034557235,"action":{"library":"H5P.TrueFalse 1.8","params":{"media":{"disableImageZooming":false},"correct":"false","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"feedbackOnWrong":"If the X and Y values are of similar magnitude a secondary axis in unnecessary. If they are not, and the graph is intended to show trends in both sets of data then an secondary axis may be used."},"l10n":{"trueText":"True","falseText":"False","score":"You got @score of @total points","checkAnswer":"Check","showSolutionButton":"Show solution","tryAgain":"Retry","wrongAnswerMessage":"Wrong answer","correctAnswerMessage":"Correct answer","scoreBarLabel":"You got :num out of :total points","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"
When you are making an XY scatterplot (graph) in Excel and are using two or more data sets with different X and Y values you always need to add secondary axis.<\/p>\n"},"subContentId":"7407871b-a88e-41dc-ba7e-d35c043053e5","metadata":{"contentType":"True\/False Question","license":"U","title":"Using a secondary axis."}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":69.94535519125682,"y":19.43844492440605,"width":28.415300546448087,"height":39.956803455723545,"action":{"library":"H5P.Table 1.2","params":{"text":"
\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t
X1<\/td>\n\t\t\t Y1<\/td>\n\t\t\t X2<\/td>\n\t\t\t Y2<\/td>\n\t\t<\/tr>\n\t\t
<\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t<\/tr>\n\t\t
<\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t<\/tr>\n\t\t
<\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t<\/tr>\n\t\t
<\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t<\/tr>\n\t\t
<\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t\t <\/td>\n\t\t<\/tr>\n\t<\/tbody>\n<\/table>\n\n
\n\n\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t
<\/th>\n\t\t\t <\/th>\n\t\t<\/tr>\n\t<\/thead>\n\t
<\/td>\n\t\t\t <\/td>\n\t\t<\/tr>\n\t<\/tbody>\n<\/table>\n<\/div>\n"},"subContentId":"eb4bdaa7-1700-486c-9404-88e3887ea920","metadata":{"contentType":"Table","license":"U","title":"Data Set"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":0,"y":10.583153347732182,"width":42.185792349726775,"height":84.23326133909288,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"Three quality control graphs with control limit lines","title":"Note. From. Elementary Statistical Quality Control (2nd ed.)by J. Burr (Ed.). (2004). Elementary Statistical Quality Control (2nd ed.). https:\/\/doi-org.libaccess.senecacollege.ca\/10.1201\/b15948. Copyright CRC Press.","file":{"path":"images\/file-603aa7445c7ca.png","mime":"image\/png","copyright":{"license":"U"},"width":678,"height":688}},"subContentId":"3b31a8d1-c35a-43c1-a31b-53556823484d","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":45.24590163934426,"y":23.542116630669547,"width":48.96174863387978,"height":49.892008639308855,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
As the arrows on the left show, at times one way want to add lines or features to an Excel graph that are not data.<\/span><\/p>\n\n
The video on the next slide will show you how to do this.<\/span><\/p>\n"},"subContentId":"f5a4ffde-79bc-4ad0-b23c-22f24b67d5fa","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":31.69398907103825,"y":20.518358531317496,"width":8.743169398907103,"height":5.183585313174946,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"Arrow pointing at control lines on the graph","file":{"path":"images\/file-603aa94a4da54.png","mime":"image\/png","copyright":{"license":"U"},"width":275,"height":55}},"subContentId":"98ee5cca-108e-4093-9575-9facf40b985b","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":31.366120218579233,"y":12.311015118790497,"width":8.743169398907103,"height":5.183585313174946,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"Arrow pointing at control lines on the graph","file":{"path":"images\/file-603aa94a4da54.png","mime":"image\/png","copyright":{"license":"U"},"width":275,"height":55}},"metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"d7483abf-3b20-4a6c-9375-70fc8860a5c8"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":9.508196721311474,"y":13.61365010799136,"width":80.32786885245902,"height":84.88120950323975,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/CN3r1Wdvpbg","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"304f4117-b4cc-4d9c-a392-5b513cdd9a95","metadata":{"contentType":"Video","license":"U","title":"Week 8 Adding a Fake Axis"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":13.071895424836603,"y":4.29436559139785,"width":83.87799564270152,"height":5.376344086021505,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
How to create a fake axis and add horizontal and vertical lines to an Excel graph (27:50)<\/span><\/p>\n"},"subContentId":"21b8b74b-0b47-455a-ae1d-45102a4bf394","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":7.6502732240437155,"y":15.11879049676026,"width":85.24590163934425,"height":75.5939524838013,"action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
No, additional data cannot be included in a chart once it has been created. Delete the chart and create a new chart.<\/div>\n"},{"correct":true,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
Yes, click on the Select Data button in the Data group under the Chart Design tab to extend or reduce the data range.<\/div>\n"},{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"
Yes, click on the chart, select the additional rows or columns of data you wish to add and press Enter on your keyboard.<\/div>\n"}],"overallFeedback":[{"from":0,"to":99,"feedback":"Review the videos again or read more here: https:\/\/peltiertech.com\/multiple-series-in-one-excel-chart\/"},{"from":100,"to":100,"feedback":"Correct!"}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"
After a chart(graph) has been inserted and formatted, is it possible to change the data range it refers to or add new rows of data?<\/p>\n"},"subContentId":"d624cd53-890c-46ba-90c8-9ce3dd06f3a9","metadata":{"contentType":"Multiple Choice","license":"U","title":"Untitled Multiple Choice"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":62.295081967213115,"y":19.43844492440605,"width":24.043715846994534,"height":77.7537796976242,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","alt":"A picture of two similar graphs.","file":{"path":"images\/file-60395266ac1a0.jpg","mime":"image\/jpeg","copyright":{"license":"U"},"width":1604,"height":2611},"title":"Note. From. A graphical method for the determination of optimum operating parameters in a humidification-dehumidification desalination system. X. Huang, X. Ling, Y. Li, W. Liu & T. Ke (2019). Desalination, 455, 19\u201333. https:\/\/doi.org\/10.1016\/j.desal.2018."},"subContentId":"2b29f460-f7ee-4d8f-beb3-4c6fb8edc78e","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":51.36612021857923,"y":6.479481641468682,"width":46.994535519125684,"height":12.958963282937365,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Fig. 7<\/span><\/span>. <\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>Effects of the mass flow rate<\/span><\/a> ratio of solution and dry air on GIR at (A) <\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>T<\/span><\/em><\/span><\/span>lhi<\/span><\/span><\/span><\/em>\u202f=<\/span><\/span>\u202f75<\/span><\/span>\u202f\u00b0C and (B) <\/span><\/span>T<\/span><\/em><\/span>lhi<\/span><\/span><\/span><\/em>\u202f=<\/span><\/span>\u202f85<\/span><\/span>\u202f\u00b0C.<\/span><\/span><\/span><\/span><\/span><\/p>\n"},"subContentId":"f39286bd-8646-4881-9f4e-90a3faa2ac59","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":5.46448087431694,"y":34.557235421166304,"width":44.80874316939891,"height":28.077753779697623,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Often one wants to show related or similar data on side by side graphs. The video on the next slide covers this topic.<\/span><\/p>\n"},"subContentId":"af4a8fb0-e70c-4c56-acc0-035b250fa576","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":8.415300546448087,"y":12.749719222462202,"width":86.775956284153,"height":86.17710583153348,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/youtu.be\/sn19xR76Vbs","mime":"video\/YouTube","copyright":{"license":"U"}}]},"subContentId":"e0805af8-a52b-49be-86e6-cf3d74bad3e7","metadata":{"contentType":"Video","license":"U","title":"Side by Side Graphs\/Chart Formatting"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":21.966884531590413,"y":3.88105376344086,"width":54.46623093681917,"height":5.161290322580645,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Creating side by side graphs and chart templates (8:27)<\/span><\/p>\n"},"subContentId":"6f37eacc-6eeb-4de3-bbb5-4e0f6fbe4f93","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}}],"keywordListEnabled":true,"globalBackgroundSelector":{"imageGlobalBackground":{"path":"images\/imageGlobalBackground-6036cf7153f5a.png","mime":"image\/png","copyright":{"license":"U"},"width":2560,"height":1280}},"keywordListAlwaysShow":false,"keywordListAutoHide":false,"keywordListOpacity":90},"override":{"activeSurface":false,"hideSummarySlide":false,"summarySlideSolutionButton":true,"summarySlideRetryButton":true,"enablePrintButton":false,"social":{"showFacebookShare":false,"facebookShare":{"url":"@currentpageurl","quote":"I scored @score out of @maxScore on a task at @currentpageurl."},"showTwitterShare":false,"twitterShare":{"statement":"I scored @score out of @maxScore on a task at @currentpageurl.","url":"@currentpageurl","hashtags":"h5p, course"},"showGoogleShare":false,"googleShareUrl":"@currentpageurl"}},"l10n":{"slide":"Slide","score":"Score","yourScore":"Your Score","maxScore":"Max Score","total":"Total","totalScore":"Total Score","showSolutions":"Show solutions","retry":"Retry","exportAnswers":"Export text","hideKeywords":"Hide sidebar navigation menu","showKeywords":"Show sidebar navigation menu","fullscreen":"Fullscreen","exitFullscreen":"Exit fullscreen","prevSlide":"Previous slide","nextSlide":"Next slide","currentSlide":"Current slide","lastSlide":"Last slide","solutionModeTitle":"Exit solution mode","solutionModeText":"Solution Mode","summaryMultipleTaskText":"Multiple tasks","scoreMessage":"You achieved:","shareFacebook":"Share on Facebook","shareTwitter":"Share on Twitter","shareGoogle":"Share on Google+","summary":"Summary","solutionsButtonTitle":"Show comments","printTitle":"Print","printIngress":"How would you like to print this presentation?","printAllSlides":"Print all slides","printCurrentSlide":"Print current slide","noTitle":"No title","accessibilitySlideNavigationExplanation":"Use left and right arrow to change slide in that direction whenever canvas is selected.","accessibilityCanvasLabel":"Presentation canvas. Use left and right arrow to move between slides.","containsNotCompleted":"@slideName contains not completed interaction","containsCompleted":"@slideName contains completed interaction","slideCount":"Slide @index of @total","containsOnlyCorrect":"@slideName only has correct answers","containsIncorrectAnswers":"@slideName has incorrect answers","shareResult":"Share Result","accessibilityTotalScore":"You got @score of @maxScore points in total","accessibilityEnteredFullscreen":"Entered fullscreen","accessibilityExitedFullscreen":"Exited fullscreen"}}

Week 8 Graphing with Excel, multiple data series

Description

Paula J MacLeod