Okay, here's your data. Five quarterly values in one block for a column chart, and 229 daily values from 6/30/2021 to yesterday for a line chart.
The evolution of the combination chart is shown below.
You want to combine the column chart and line chart in the top row.
Starting with the Quarterly chart, copy the daily data, select the chart, and use Paste Special to add the copied data to the Quarterly chart as a new series, with series name in the first row and category (X-axis) values in the first column, but don't overwrite existing categories. This results in Combo Chart 1.
Right-click on the new series, and choose Change Series Chart Type from the menu. Change the series to a line on the secondary axis (Combo Chart 2).
Click on the plus icon beside the chart, click the triangle next to Axes, and check the secondary horizontal axis (Combo Chart 3).
Change the secondary axis scale to line it up with the primary scale. You need half a quarter before 6/30/2021 and half a quarter after 6/30/2022, so the minimum has to be 5/15/2021 and the maximum 8/15/2022 (Combo Chart 4).
Finally, clean it up. Format the secondary horizontal axis, format the axis label position to no labels, and format the major tick mark type to none (Combo Chart 5).
