Plotting Data with Dual Axes

This video tutorial demonstrates how to plot a line graph with two vertical y-axes in Excel. It begins with an introduction to the concept, followed by an example using lactate and heart rate data. The tutorial guides viewers through the process of creating a graph with dual y-axes, highlighting the importance of clear data visualization. It also covers formatting and customization options to enhance clarity, and concludes with instructions on adding titles and final touches to the graph.

What is the primary focus of the tutorial video?

• Formatting cells in Excel

• Using Excel for data entry

• Plotting a line graph with two vertical y-axes

• Creating a pie chart in Excel

Why is it not ideal to plot lactate and heart rate data on a single axis?

• The heart rate data is too small compared to lactate

• It is difficult to add markers

• The lactate data appears as a steady line due to its small values

• It makes the graph too colorful

What type of chart is recommended for plotting lactate and heart rate data?

• Scatter plot

• Bar chart

• Pie chart

• Line chart

How do you highlight the data in Excel before plotting?

• Right-click and select 'Highlight'

• Double-click the data

• Use the 'Highlight' button in the toolbar

• Click and drag the mouse over the data

What is the first step to format the heart rate data to use a secondary axis?

• Click on the lactate line

• Click on the heart rate line

• Select 'Insert' from the menu

• Change the chart type

What option should you select to move the heart rate data to a secondary axis?

• Primary Axis

• No Axis

• Secondary Axis

• Tertiary Axis

What is a good practice when finalizing a graph in Excel?

• Avoiding any titles

• Using only one color for all lines

• Adding titles to both axes

• Using a pie chart for clarity

What should be included in the axis titles for clarity?

• A description of the data and its unit

• Just the data name

• Only the unit of measurement

• No titles are needed

What is the primary axis used for in the tutorial example?

• Exercise stages

• Blood lactate in mmol

• Time in minutes

• Heart rate in bpm

What is the secondary axis used for in the tutorial example?

• Time in minutes

• Exercise stages

• Heart rate in bpm

• Blood lactate in mmol