The last chart you want to create is a combo chart to depict the blood pressure readings with the overlay of heart rates.

Create a Clustered Column $$ Line on Secondary Axis combo chart using the range A$2$:D$7$ in the April worksheet. Move the chart to a chart sheet named Combo Chart.

After creating the chart, you will apply a chart style.

Apply Style $4$ chart style to the combo chart.

Change the chart title to Blood Pressure$/$Heart Rates.

Select the dates and select Text axis to remove the extra dates from the chart

Apply Black, Text $1$ font color and $11$ pt font size to the two value axes and the category axis.

You decide to add a title to each axis to describe the data being plotted.

Add a primary vertical axis title Blood Pressure and a secondary vertical axis title Heart Rate.

Move the legend to the top position.

You decide to remove one of the data series.

Edit the data source to remove the $4/1/2024$ data series.

Now you are ready to add Alt Text to the chart.

Display the combo chart and add the Alt Text Shows blood pressure and heart rate for the last four weeks.